Search:

You can also use A Dataset to store your data. The following is a sample project to show how to load and save a dataset.


<Code>
Imports System.Data
Imports System.Data.SqlClient
Imports...

Every VB Programmer should have this one


http://www.amazon.com/gp/product/0735613753/qid=1143051929/sr=1-1/ref=sr_1_1/104-9088175-4089548?s=books&v=glance&n=283155

A good place for additional info
http://www.functionx.com/adonet/

http://databases.about.com/od/specificproducts/a/normalization.htm

Sorry about that should be
Me.DataGrid1.UnSelect(DataGrid1.CurrentCell.RowNumber)

this is side by side execution to avoid dll hell
see
http://www.ssw.com.au/SSW/Database/DLLHell.aspx

try using
DataGrid1.CurrentCell.ColumnNumber

For the situation u describe I would look at storing my data in XML, no support requirements, hosting ect... and .net has excellent support for it. Then use html and stylesheets to do your reporting

Your use of try catch blocks makes this difficult to debug.

Replace your catch statement with this and the app will tell you what is wrong, I suspect it is the sql statement
Catch ex As...

make the button style graphical

Curious, as to why you need to repopulate the ID, Numbers are cheap and this is the whole purpose of AutoIncrementing an ID.

Not quite sure I understand the problem this code shows how to do it with 3 strings for month,day, year and the second just sets a date for a string date

Dim d As String = "15"
Dim m As...

Change the DropDownStyle Property of the ComboBox to DropDownList

look at the overload method 2 of the date
Dim birthDate As New Date(val(Year), val(Month), val(Day))

if you change your default button to
MsgBoxResult.No that will fix the problem

If you are using a dataset to populate your grid then all you have to is use the datasets WriteXML and ReadXML functions like this


Private Function SaveData(ByVal FileName As String, ByVal...

See this link for the Dot net way to do this
http://msdn.microsoft.com/vbasic/atthemovies/howto/default.aspx