Sunny

苦心人天不负

导航

Update DataReader

  private void btnUpdateDataReader_Click(object sender, System.EventArgs e)
  {
   SqlConnection conn=new SqlConnection("Integrated Security =True;"
    +"Data Source=172.17.39.19;Initial Catalog=test");
   conn.Open();
   SqlCommand comm=new SqlCommand();
   //comm.CommandText="insert into test(Name,Code) Values ('" + txtName.Text + "','" + txtCode.Text + "')";
   comm.Connection=conn;
   comm.CommandText="insert into test(Name,Code) Values (@P1,@P2)";
   comm.Parameters.Clear();
//   comm.Parameters.Add(new SqlParameter("@P1",SqlDbType.Char,10));
//   comm.Parameters["@P1"].Value="erer";
//   comm.Parameters.Add(new SqlParameter("@P2",SqlDbType.Char,10));
//   comm.Parameters["@P2"].Value="4567";
   SqlParameter name=new SqlParameter("@P1",SqlDbType.Char,10);
   name.Value=txtName.Text;
   comm.Parameters.Add(name);
   SqlParameter code=new SqlParameter("@P2",SqlDbType.Char,10);
   code.Value=txtCode.Text;
   comm.Parameters.Add(code);
   comm.ExecuteNonQuery();
   comm.Parameters.Clear();

  }

posted on 2004-04-29 07:49  Sunny  阅读(742)  评论(1编辑  收藏  举报