Using Stored Procedures in Conjuction with DataAdapter


sqlCmd = new SqlCommand();
sqlCmd.Connection = conn;
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "get_wf";
SqlDataAdapter adapter = new SqlDataAdapter();
conn.Open();
adapter.SelectCommand = sqlCmd;
adapter.Fill(dataTable);

Comments

Popular posts from this blog

Singleton pattern implementation in C#

DataSet vs DataView