Grid View control update delete with dataset disconnected environment.
-
Dear Friend, Scenario I have one grid view showing user access model having field as 'User'(Textbox), 'Group'(Dropdown), 'View' (Checkbox), 'Edit'(Checkbox) column. I have on Data Set where i stored the data fetch from database. now i bind this dataset to Grid View Control DataSet ds = getData(); GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); Note: Where getData() method fetch the data from database. Problem i change only two record from all ten records, now i want to update only that record in my database how could i do this... Actually i know DataSet having HasChange() Method which use to know the changes in dataset but dont know how to use it for the above scenario.. Please help me Thanks and regard's in advance Sasmi
-
Dear Friend, Scenario I have one grid view showing user access model having field as 'User'(Textbox), 'Group'(Dropdown), 'View' (Checkbox), 'Edit'(Checkbox) column. I have on Data Set where i stored the data fetch from database. now i bind this dataset to Grid View Control DataSet ds = getData(); GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); Note: Where getData() method fetch the data from database. Problem i change only two record from all ten records, now i want to update only that record in my database how could i do this... Actually i know DataSet having HasChange() Method which use to know the changes in dataset but dont know how to use it for the above scenario.. Please help me Thanks and regard's in advance Sasmi
A little thing like documention might help, http://msdn.microsoft.com/en-us/library/zky7370c.aspx[^]
I know the language. I've read a book. - _Madmatt
-
Dear Friend, Scenario I have one grid view showing user access model having field as 'User'(Textbox), 'Group'(Dropdown), 'View' (Checkbox), 'Edit'(Checkbox) column. I have on Data Set where i stored the data fetch from database. now i bind this dataset to Grid View Control DataSet ds = getData(); GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); Note: Where getData() method fetch the data from database. Problem i change only two record from all ten records, now i want to update only that record in my database how could i do this... Actually i know DataSet having HasChange() Method which use to know the changes in dataset but dont know how to use it for the above scenario.. Please help me Thanks and regard's in advance Sasmi
Look how i use it here http://www.codeprojecCoding an N-Tier Application in C# Without Any Wizard: Part II[^]t.com/KB/cs/N-Tier22.aspx
Vuyiswa Maseko, Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code. C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/