DataBinding

[agooddatamgr]

I have created several tables in the Sequel Server 2005 and I am new to Visual Studio 2005 and SQL Server. I am trying to connect a form1.vb to my Sql Data Source and data bind fields. I have a Main Table with Date, Issue, Resolution, Time, and Technician. The Issue, Resolution, time, and technician fields are setup as drop down boxes and I have draged and dropped the fields onto the form1.vb and I can add data to the fields and store them in the SQL database holding my Main Table. The date field is not saving. I noticed that the date field is not binding with the drag and drop method. How can I data bind the date field with the default date of the system and also be able to change the date field? What coding will bind the date field to the server and save the added date to the server so it will appear on each row of the main table? The Date field has null in each row for Date.

Any help is appreciated. I am very new.

agooddatamgr but lacking knowledge

 

[RyanEK]

Hi,

I suggest you ask a .Net forum. This is not specifically a MSSQL issue. However, have you tried commiting the bindingsource before saving? ie. Any changes to a bindingsource are just in a pending state until you call EndEdit().

Ryan