Help! Creating an update form for SQL
-
I am trying to create a Windows Form to update a simple database, but cannot get the code right for the update process. I felt like I had it down in class, but ... not! The SQL 2000 database has 21 fields (datetime, nvarchar, int) data types. I created 2 forms, one with textboxs for each field and the other with a data grid. I cannot seem to get either one to work. As some of the fields are lengthy, the form with individual textboxs would be the preferred way. Any help would be greatly appreciated! I have the load function working to see all of the records. I also 3 fields that use a listbox and I am able to select the different values. Thank you, LWhite
-
I am trying to create a Windows Form to update a simple database, but cannot get the code right for the update process. I felt like I had it down in class, but ... not! The SQL 2000 database has 21 fields (datetime, nvarchar, int) data types. I created 2 forms, one with textboxs for each field and the other with a data grid. I cannot seem to get either one to work. As some of the fields are lengthy, the form with individual textboxs would be the preferred way. Any help would be greatly appreciated! I have the load function working to see all of the records. I also 3 fields that use a listbox and I am able to select the different values. Thank you, LWhite
What do you want to do? Maybe DATAFORM Wizard could help you. ICQ:258-235-734 MSN:msnadair@hotmail.com
-
What do you want to do? Maybe DATAFORM Wizard could help you. ICQ:258-235-734 MSN:msnadair@hotmail.com
I do use the wizard, but since the wizard defaults to OleDb vs SQL, my problem occurs changing the connection over to SQL. LWhite