What is the use of sqldatareader class?
What is ado.net object model?
differences between ADO and ADO.NET
Define isolation?
What are the differences between OLEDB and SQLClient Providers?
How To Update A Column In A DataGrid Using C#.NET? I am getting InvalidCastException as (Specified cast is not valid) while updating 2nd column in a datagrid? Id,firstname,lastname are the three columns of my datagrid respectively. I wanted to edit the second column(lastname) and update it. I did the following code in DataGrid's updatecommand(),but failed to update ! Int varid=(int)DataGrid1.DataKeys[e.Item.ItemIndex]; TextBox lnm=(TextBox)e.Item.Cells[2].Controls[0]; string str=lnm.Text ; SqlCommand cmd=new SqlCommand("update customer set lastname='" + str + "' where id=" + varid + "",con); cmd.ExecuteNonQuery(); DataGrid1.EditItemIndex=- 1; DataGrid1.DataBind();
Can a DataReader be used as a DataSource for a GridView. If it is so how will you handle paging.
How can we add/remove row's in "datatable" object of "dataset"?
Explain executenonquery?
How to connect and retrieve data from database using dataset
What are ado.net objects?
What does ado stand for in ado.net?
How to insert multiple records in asp .net from Gridview to Sql Database with out using loop condition ?