Is entity framework better than ado.net?
No Answer is Posted For this Question
Be the First to Post Answer
What are the advantage of ado.net?
What is the role of clr?
Why do we serialize data?
Explain what is datagrid with an example?
What is Pooling? what is data pooling? what is sql pooling?
What is ole in excel?
Which method is used by command class to execute SQL statements that return single value?
What are the 4 types of classes in ADO.NET?
Define isolation?
Can we do database operations without using any of the ado.net objects?
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();
Explain why edit is not possible in repeater?