Explain the difference between sqlcommand object and command behavior object?
What is the difference between dataset and datatable?
What is the difference between Data adaptor and Data set?
What is ado.net in vb net?
What is the provider and namespaces being used to access oracle database?
Differences between dataset.clone and dataset.copy?
i making a project using windows application c#, i want to show user name, password, and one button login. i wanna make it with sealed class .how its possible . when i clicked my login button all project should be open. pls cleare me.
Explain the basic use of "dataview" and explain its methods.
Which parameter of ConnectionString is used to specify the name of the database?
Define the executescalar method?
What do you mean by performing asynchronous operation using command object?
What is the difference between ado.net and entity framework?
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();