Need to connect to sqlserver...
-
How can I connect to sql server and (Select - update - insert -Delete) the data using other method than Dataset. I want the connection to be directly to the database and not cache as dataset. Is it possible to use sqldataadapter to retrive ,update , insert and delete data? Thanks
-
How can I connect to sql server and (Select - update - insert -Delete) the data using other method than Dataset. I want the connection to be directly to the database and not cache as dataset. Is it possible to use sqldataadapter to retrive ,update , insert and delete data? Thanks
-
Use an SqlCommand object. Put an SQL query or a stored procedure call in it, and use the ExecuteReader method (for select) or ExecureNonQuery method (for update/insert/delete) to call it. --- b { font-weight: normal; }