Update and Delete Rows in a DataTable

Good article sir. I have a question here..What if my columns are dynamic. Let's say date column which comes from database. If I want to update the particular date column with some specific string, how can we write it?

Good Article sir,,Is it possibe to attach a code for asp.net for this article ?

Thank you sir

Hi,I think there is better way(Must Be) to find some Row With Filtering...

Collection was modified; enumeration operation might not execute.

Thanks dude, without AcceptChanges()my Datatable was showing errors .

how to delete a row from sql server2005 database based on datagridview row selection at runtime?

I get this runtime error: System.InvalidOperationException: Collection was modified; enumeration operation might not execute.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> If I try this foreach (DSHelpBillingAssets.MPRNsRequiringBundlingRow row in dsHelp.MPRNsRequiringBundling.Rows)<o:p></o:p> {<o:p></o:p> if (row.Converter + row.AMR == 0)<o:p></o:p> {<o:p></o:p> row.Delete();<o:p></o:p> }<o:p></o:p> <o:p></o:p> }<o:p></o:p> dsHelp.MPRNsRequiringBundling.AcceptChanges();<o:p></o:p>

Actually i have used a grid view that shows values from the datbase table created in SQL Server 2005. The thing I actually want is that I should select rows from the grid view and when I press the delete button the selected values from the grid view must be deleted along with values from the database table. All the code must be in C#.

Actually i have used a grid view that shows values from the datbase table created in SQL Server 2005. The thing I actually want is that I should select rows from the grid view and when I press the delete button the selected values from the grid view must be deleted along with values from the database table. All the code must be in C#.

error Update requires a valid InsertCommand when passed DataRow collection with new rows. my code is dim da as new OleDbDataAdapter("select * from Acces_reg", conn) dim ds as DataSet = new DataSet() da.Fill(ds, "Acces_reg") dim dr as DataRow = ds.Tables("Acces_reg").NewRow() dr(1)=.textbox1.text ------------------------ ds.Tables("Acces_reg").Rows.Add(dr) da.Update(ds, " Acces_reg")

Hi, I working on C#, .Net 1.0. I am getting broadcast from the server which gives me around 50 rows, which i capture it and store it into data table, which is bound to the grid. before storing it, i delete the data table and add new rows. The problem here is, that the grid flickers every time the feed comes from the broadcast. I thought to create an array of DataRow and add the same to the data table at a time how do i add the whole range of datarows into a data table at a time.