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 …

Yes you can and should use an ampersign instead of a plus sign. With that said though, concatenating strings isn't the most efficient way to program. Although you may only be using one variable, every time you concatenate into that variable it is actually making a new variable in memory. …

I have a process that does a lot of data manipulation and then prints a simple report directly to a printer. The overall priority is speed. Tens of thousands of records need to be scanned & processed individually so moving thru them quickly as possible is the goal. Pseudo code …

I have already answered this with an example on the other board you posted the same question

You can use ODBC to output a dataset or datatable directly to an excel file without the need of automating Excel itself or even requiring the user to have Excel installed. In this case, I would fill a datatable and bind it to your listbox and then export to the …

I think your confusing yourself with so many different timers. I would suggest only using one timer (interval to one second) and through coding keep track of the elapsed time and which light should be displayed. Also take a look at "StopWatch" in the help file it shows how to …

[QUOTE=lss123;1053457]So really what I'm asking is, is that for any object created that has a number of functions, procedures, and maybe constants defined - are these functions/procedures/constants taking up memory for [I]each[/I] object defined? For instance, if a word object has the function "getWord()" defined in memory, if I create …

[QUOTE=sknake;999722] [code=c#] public static string BuildSqlNativeConnStr(string server, string database) { return string.Format("Data Source={0};Initial Catalog={1};Integrated Security=True;", server, database); } /* -------------------------------------------------------------------- */ public static string BuildSqlNativeConnStr(string server, string database, string username, string password) { return string.Format("Data Source={0};Initial Catalog={1};Integrated Security=False;User Id={2};Password={3};", server, database, username, password); } [/code][/QUOTE] No need to build your …

[URL="http://msdn.microsoft.com/en-us/library/fxsa23t6.aspx"]MSDN Database Walkthroughs[/URL]

The record is either added/inserted to the dataset/datatable or it is not. AcceptChanges will only change the rowstate (if it already exists in the dataset) of the record from New to Unchanged and will then prevent the record from then being saved to the database since the datatable sees it …

Im trying to understand your project and a bit confused. Why would you want to extract data from the XML file and store in multiple flat text files? It would seem to me (without know more about your project) that it would be easier to keep everything in the xml …

It is much more efficient (specially using access) to store just the file name & path of your file in the database and retrieve that info to use in loading your file. Images take up larges amounts of space and everytime you edit a record that contains a picture (even …

You dont need to automate Excel at all to output your dataset/datatable to an Excel file. You can use OLEDB to create your file.

Ok I'm lost I guess because this is marked as solved. AcceptChanges does not save the data to the database; it instead changes the row state properties of the dataset/datatable making the new records to UnChanged so that they cant be saved to a database when calling update.

cboMonthC.Items("")) The parameter should be an interger value not a string

The footer section is not like the details section and does not list multiple records. Its more for summaries (single rows) type of info. Im not sure of the type of info your looking to display but try taking a look at grouping the sections, this may answer your question.

Here are some tutorials for working with VB.Net & Sql Server: [URL="http://msdn.microsoft.com/en-us/library/fxsa23t6.aspx"]Data Walkthroughs[/URL] Here is a link dedicated soley to connection strings: [URL="http://www.connectionstrings.com/"]Connection Strings[/URL]

There are several ways you can accomplish this. You can either define there security through coding as mentioned above and then handle it in the project depending on the users level or you can define it right in Sql Server itself by assigning the proper permissions per table for each …

Agree with Adapost, not many will help those that at least are not attempting to do the work for themselves. A quick suggestion that may help though, using the proper controls will help make validation easier. Such as using the NumericUpDown control instead of a textbox to allow only numeric …

If you want an inputbox where the user enters the input into the messagebox, then you do have to assign the return value to a string variable. But as Sknake say above, its not needed if it is only displaying a message.

All programming languages are dependent on some type of base class files that it calls for functionality. Dot net attempts to include all in the dot net framework instead of a ton of seperate files (dll hell) . Even languages such as C++ will use system dll files.