TomW

In the Combobox's property window Set AutoCompleteMode to Append Set AutoCompleSource to ListItems

It is very bad programming to store images in a database. It is much better to instead store the file name and path to point to loading the files. Images are much larger then text and will quickly accumalate the size of the database. Even if using very small resolution …

It depends on the type of numbers you are inputting. If whole numbers, I would suggest using the numericupdown control such as suggested above. Other options such as suggested above will be triggered with each key stroke, just of the textbox's validating event might be better since it would not …

You need to make a dynamic connection string. Meaning that you need a way to prompt the user (if the settings werent previously saved) to select the server & database they will be using and from there save your connection string.

Just went through this exact situation a few weeks ago myself. Suprisingly there is [U]not [/U]an easy solution for this although I did find a work around. There is no way to set the total height of the details section iteself, only the height of the individual item records. So …

MessageBox.Show("No record found")

Ok first, you dont need to explictily call open and close to your database connection, your dataadapter will open & close the connection as needed. Your error is being caused by your concatenated query string. Your connection object is actually within your query double quotes becoming part of the select …

[Code=vb] intTotalRecordsUpdated = command.ExecuteNonQuery() [/code]

You can use a select statement to fill a DataSet/DataTable. You can then export the entire dataset to an xml file with a single call, youDataSet.WriteXml(strYourFileNameAndPath) Exporting to a text file is a bit more involved, you have to loop thru each of the records in the datatable to extract …

Saving pictures to a database isnt optimal and should be avoided if possible. Including pictures can greatly increase the size of your database and reduce the speed of its processing. Likewise everytime you update a record that contains a picture, even if your not touching the column with the picture, …

It sounds as if, the groupboxes 2-4 are contained within the first groupbox container... If you move groubbox1 around on the form, does all the other groupboxes move with it?

Take a look at "FileMode" in the help index. Your use of FileMode.Create will always create a new file including overwriting the file if it already exists. Instead you want to create a file if it doesnt exist but append to a file if it does exist.

If you use the Code icon at the text area toolbar it will format your code for easier understanding here on the site. Im not sure why your closing your connection before you even open it but either way both open & close calls are not needed. When you use …

Using database functionality you can read and write to an excel file without having to automate Excel as long as what you are writing following a consistent table structure. I definitely prefer this method it is very easy and doesnt require the user to even have Excel. However you do …

You can create a view of your table and then use Find & Filter methods available. This has performance benefits over using datatable select methods which then lose table indexing.

When you created the report using the wizard, did you point it to a database or directly to your typed dataset (.xsd file)? Im wondering if the report is somehow attempting to pull the data from the db rather then use the dataset set being passed to it. Either way …

The problem is in your connection statement. Your specifying the database twice, each a different way and your not specifying the security.

If that much isnt working then either the name given to your DataSource or Database is incorrect. Unless of course its not actually windows authenticated and you need a login & password. [Code] Dim strCon As String = "" strCon = "Data Source=[COLOR="Red"].\ISCDEV[/COLOR];Initial Catalog=[COLOR="red"]mangiamos[/COLOR];Integrated Security=True" Using con As New SqlConnection(strCon) …

In the properties window make sure CheckedOnClick equals true for each of the menu items. Add to your menu item events: mnuUnitedStates_Click mnuMexico.Checked = Not mnuUnitedStates.Checked End Sub mnuMexico_Click mnuUnitedStates.Checked = Not mnuMexico.Checked End Sub

If you use a NumericUpDown control it will save you some datatype conversions and validation and will limit users to only entering numeric values. For the calculation I would use a loop; passing the days worked and starting amount. [Code=VB] decPay = decStartingAmount For intDay = 2 To intTotalDaysWorked decPay …

[URL="http://lmgtfy.com/?q=backup+database"]Here let me google that for you[/URL] You could even possibly take that one step further and adding the type of database you want to back up...

[QUOTE=adatapost;1148252][b]>will you provide some real good example on backgroundworker control in vb.net for doing some process in background.[/b] Not the real question. [URL="http://www.lmgtfy.com?q=BackgroundWorker+Tutorials"]Let me google that for you.[/URL][/QUOTE] Excellent answer. And surprising how much it applies to such a majority of the entire threads posted.

Theres a few books on the subject over on amazon

A little more detail about what isnt working would be helpful. Also you should properly declare instances of each for you want to create. [Code=VB] Private Sub LoadForm3( ) Dim frm As New Form3 frm.Show() End Sub [/Code]

You need to clarify this and provide a bit more detail. Reading your post I have no clue what your trying to accomplish.

You need to provide a bit more detail but I dont think there is any real need of using a timer just to update a status bar. For example if your looping thru rows in a returned dataset or lines in a file, you want to start by simply setting …

Wow did you even try looking up the answer for yourself before asking others to do it for you?

No need to code to keep validating texbox values. Just use a NumericUpDown control. It is essientially a textbox control that only allows numbers. Also you then wont need to keep converting your textbox values back & forth to a numeric datatype.

Your IF statement is returning that message box if you have any records in your dataset table at all. Second your insert command is never even set to execute anything to the database. You really should start by learning how to step thru your code

It is important to note that a datagridview is only a means of displaying an underlying datasource. When working to manipulate that data you should work directly with that underlying source. Unless the column you are searching happens to be the table primary key, using a dataview as Adapost suggests …