Problem In SqlDataAdapter

Question

hi

Any one can help me

I use SqlDataAdapter and it has some built in properties like updatecommand, selectcommand, deletecommand,insertcommand and i have also try to use theme but problem is that, these propeties are run successfully but database is not chaged can any one help mee....?

Sam Hobbs · Answer

Is it working? If not then have you given the UpdateCommand SelectCommand DeleteCommand and InsertCommand valid commands?

anand sengar · Answer

nice

Smart Lucky · Answer

Hi I refer this tutorial http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldataadapter.updatecommand.aspx

anand sengar · Answer

hello why you are not using SqlDataAdapter adapter = new SqlDataAdapter(cmd); insted of adapter.SelectCommand = cmd;. Try it once i think this is the good way. Anand