MSDN Database Walkthroughs (http://msdn.microsoft.com/en-us/library/fxsa23t6.aspx)

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.

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...

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...

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...

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.

Also Im not sure what the insert line is doing (the first line) you have already added the rows to the table in the first example unless you removed that coding too...

Altogether I would say the...

Perfect sense, the DataAdapter.Update is what sends the new records to the database. The AcceptChanges isnt needed (its redundent), the call to the Update method automatically changes the records row...

Take a look at AcceptChanges in the help file, it does not insert data to the database. I cant say much besides that since I dont know what else your code is doing.

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...

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...

Here are some tutorials for working with VB.Net & Sql Server:
Data Walkthroughs (http://msdn.microsoft.com/en-us/library/fxsa23t6.aspx)

Here is a link dedicated soley to connection strings:...

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...

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...

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...

Lots of different ways you can do the import but automatting Excel is probably the last one I would pick. First if you are importing directly from an Excel file, there is no reason to automate Excel...

Its pretty easy, your basically just making a different connection string that attaches to the file rather then to a database. Plenty of examples online showing how to do it. If your unable to figure...

Nothing really needed, just add a Module file and start creating your public or private subs & functions. If created as public they can be seen and accessed from anywhere else in your project. The...

Public Subs/Functions are best off put into a module file so that all forms within a project can access these methods.

Is this being run on a different computer then what it was created? Reference problems like this are usually a case of having a different version of Excel (or no version) then which it was created...

MSDN Data Walkthroughs (http://msdn.microsoft.com/en-us/library/fxsa23t6.aspx)

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...

Seem to be that it is expecting you to pass an integer value in the c.GetDisplayText function but instead you are passing a tab string. Of course im only taking a guess here since I dont know what...

None of the parameters even have datatypes defined.... An overflow error is usually caused by trying to force a bad value that doesnt fit into a specific datatype.

I guess that mostly depends on what info you are displaying. If you want to display multiple records at a time I would use a DGV. If it is only one record at a time then controls such as Labels or...

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

Time will automatically be applied as 12am thats why its better to use a between statement to give you all records for the specified day.

Also dont forget to include the # signs surrounding your date

Database's hold a DateTime value so its important to include the time such as using a between Todays date at 12:00am and tomorrows date

The field parameters seem to be correct unless im missing a misspelling somewhere between them. I would start by making two changes and see if you still have the same problem.

01) Convert the...

You need to take a look at some tutorials on how to program for databases. What you are asking is rather simple but it seems that you dont yet have a grasp on even connecting to a database since your...

Just to clarify, you want to show a messagebox when the form first loads correct?


Public Class Form1

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)...

Can you show your insert statement from the stored procedure? Without seeing it, I'm guessing either the parameters are wrong, missing or misspelled.

Also assuming that DesignationID is an numeric...

In that example you are still not closing the connection if there is an error. I would add a FINALLY section to that Try/Catch block to close the connection.

Your error should be tripped on the line actually executing your statement. Therefore all that coding in your class sub should be within a Try Catch Finally block. In the finally section you should...

You have to point the datagridview's datasource property to the table you are storing the results

DataGridView1.DataSource = myDataset.Tables("myTable")

As to the pictures, this can be done but...

The following link has many walkthrough examples of how to work with vb.net & sql server. If you still are having a problem, let me know

Data Walkthroughs...

I actually agree with you. I definitely think OOP has its place but for the most part I limit it to things such as needing multiple instances with different data at the same time. If its a case of...

Yes