----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: ExploreGuna Message 1 in Discussion Hi People, I am new to .NET (VB.NET) technology. As to start with, I tried to implement a simple transaction like having a table with columns & descriptions given below ID(primary key, identity column, to be hidden in DataGrid and used for Internal Purpose), ShortName (Unique), Description. I created a windows form with one DataGrid to show the table values. I also have 5 buttons 1)Add values to table, 2)Modify value to table, 3) Save values to table, 4) Cancel Changes, 5) Close application and 2 Text box for holding my values for editing or inserting. I created connection to SQL Server thru OLEDB. I used OLEDBDataAdapter for doing transactions with the table (implemented command objects for inserting/updating values). The DataGrid's DataSource property is set to the DataSet's Table(0). I have done some DataGridTableStyle & DataGridColumnStyle things to DataGrid to look & make as I want. Here comes my problems. 1) I need to show a column titled S.No (Serial Number to be generated manually ie. each row number of the grid is the s.no.) which is only for external use & the respective values in each row, (I have hidden ID Column since its only for my internal purpose) * require urgently 2) When I added new values and update the datasource thru dataadapter, and when I try to modify the same immediately it throws an exception since my ID is null or ID didnt have the updated value. Hope I have given a clear picture, waiting to get a Solution ASAP. for further reference I have attached my code as a text file. Thanks, Guna. View Attachment(s): http://groups.msn.com/BDOTNET/_notifications.msnw?type=msg&parent=1&item=4353 ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDOTNET/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
