What do you know about ado.net's objects?
No Answer is Posted For this Question
Be the First to Post Answer
How can you implement sub data grid in a master datagrid?
How can we add relation between tables in a dataset?
Which is faster datareader or dataadapter?
What are dataproviders?
can we change the data in dataset? if yes what is the process?
What?s the role of the DataReader class in ADO.NET connections?
Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.
What is the default provider in ado.net?
Describe briefly an ADO.NET Dataset ?
How to work with disconnected data - the dataset and sqldataadapter?
What are the major difference between classic ADO and ADO.NET?
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();
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)