----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: saileshsaha Message 15 in Discussion Hi BalajiKrishnan, Thanks for your clarification. Let me try to help you out. 1) The data read from the excel file is displayed on the grid. 2) The user clicks the Edit button for a row and changes some values. 3) Now you want to make the database operations. Right? What i suggest is: When you read the data from the excel file and populate your datatable(for displaying data in the datagrid). define a primary key column in that datatable. Even if there is no unique key field, take a combinatuion of columns which will form a unique key. Then after all the editing is doen and database operations needs to be performed, retreive the unique key value(which you have idenfiied/defined earlier), and check again the db table whether it exists or not. And then based on its presence, perform insert/update accordingly. Hope this time i have understood your problem. Regards, Sailesh ----------------------------------------------------------- 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]
