Which property is used to check whether a DataReader is closed or opened?
No Answer is Posted For this Question
Be the First to Post Answer
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?
0 Answers SwanSoft Technologies,
Which is better entity framework or ado.net?
What is the key feature of ADO.NET compared to ADO ?
What is ado object model?
Describe the command object and its method.
Difference between OLEDB Provider and SqlClient ?
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();
What is oledb connection?
What is difference between ado.net and asp net?
Which is faster entity framework or ado.net?
Can we load multiple tables in a dataset?
What is sqldatareader?