是控制台程序
代码如下:
SqlConnection connection=new SqlConnection(@"Data Source=(local);Integrated Security=SSPI;"+"Initial Catalog =NorthWind");
connection.Open();
SqlCommand cmd=new SqlCommand("select * from employees where FirstName=@FirstName",connection);
cmd.Parameters.Add("@FirstName",SqlDbType.NVarChar,10);
cmd.Parameters["@FirstName"].Value="Andrew"; SqlDataAdapter adapter=new SqlDataAdapter();
adapter.SelectCommand=cmd;
DataSet dataset=new DataSet();
adapter.Fill(dataset,"Employees");
Console.WriteLine("name before change:{0}",
dataset.Tables["Employees"].Rows[0]["FirstName"]);
SqlCommand upcmd=new SqlCommand("Update Employees set FirstName=@FirstName where FirstName=@OldFirstName",connection);
upcmd.Parameters.Add("@FirstName",SqlDbType.NVarChar,10);
upcmd.Parameters["@FirstName"].Value="Rock";
upcmd.Parameters.Add("@OldFirstName",SqlDbType.NVarChar,10);
upcmd.Parameters["@OldFirstName"].Value="Andrew";
adapter.UpdateCommand=upcmd;
adapter.Update(dataset.Tables["Employees"]);
Console.WriteLine("name after change:{0}",
dataset.Tables["Employees"].Rows[0]["FirstName"]);
connection.Close();
代码如下:
SqlConnection connection=new SqlConnection(@"Data Source=(local);Integrated Security=SSPI;"+"Initial Catalog =NorthWind");
connection.Open();
SqlCommand cmd=new SqlCommand("select * from employees where FirstName=@FirstName",connection);
cmd.Parameters.Add("@FirstName",SqlDbType.NVarChar,10);
cmd.Parameters["@FirstName"].Value="Andrew"; SqlDataAdapter adapter=new SqlDataAdapter();
adapter.SelectCommand=cmd;
DataSet dataset=new DataSet();
adapter.Fill(dataset,"Employees");
Console.WriteLine("name before change:{0}",
dataset.Tables["Employees"].Rows[0]["FirstName"]);
SqlCommand upcmd=new SqlCommand("Update Employees set FirstName=@FirstName where FirstName=@OldFirstName",connection);
upcmd.Parameters.Add("@FirstName",SqlDbType.NVarChar,10);
upcmd.Parameters["@FirstName"].Value="Rock";
upcmd.Parameters.Add("@OldFirstName",SqlDbType.NVarChar,10);
upcmd.Parameters["@OldFirstName"].Value="Andrew";
adapter.UpdateCommand=upcmd;
adapter.Update(dataset.Tables["Employees"]);
Console.WriteLine("name after change:{0}",
dataset.Tables["Employees"].Rows[0]["FirstName"]);
connection.Close();
1。系统偷懒生成
2。自己定义update语句
3. Primary Key
系统明明执行了sqlDataAdapter1.Update(dsNorthwind1)这一句
可是数据源并没有被更新