Explain the different row versions available in table?
No Answer is Posted For this Question
Be the First to Post Answer
What is the namespaces being used to access oracle database?
What does datareader object do?
How to Read, Add, Update and Delete record in Entity Framework ?
Explain the difference between data reader and data adapter?
What is the difference between a Dataset and DataReader? Can dataReader hold data from multiple tables?
3 Answers Fulcrum Logic, Merrill Lynch,
What are the advantages using ado.net?
What are the classes in System.Data.Common Namespace?
Is it possible to load multiple tables in a Dataset?
Which method do you invoke on the DataAdapter control to load your generated dataset with data?
5 Answers IBM, Veegyapan Impacts,
How can you identify whether or not any changes are made to the DataSet object since it was last loaded?
What is 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();
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)