C#里ADO.NET的SqlDataAdapter新增数据

//查找   

string myconn = "Data Source=USER-20150605LO;Initial Catalog=JXC;Integrated Security=True";
            string mysql = "select * from tb_Commodity";
            SqlConnection myconnection = new SqlConnection(myconn);
            myconnection.Open();
            SqlCommand mycommand = new SqlCommand(mysql, myconnection);
            SqlDataReader myreader = mycommand.ExecuteReader();


            //1
            while (myreader.Read())
            {
                Console.WriteLine(myreader.GetInt32(0) + "," + myreader.GetString(1));
                Console.ReadLine();
            }


            myreader.Close();
            myconnection.Close();


            //2
            DataSet ds = new DataSet();
            SqlDataAdapter myadapter = new SqlDataAdapter(mycommand);
            myadapter.Fill(ds, "tb_Comodity");


            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                Console.WriteLine(Convert.ToString(dr["CQuarter"]), "季节");
            }

//新增

string connString = "Data Source=USER-20150605LO;Initial Catalog=JXC;Integrated Security=True";
           
            using (SqlConnection conn = new SqlConnection(connString))
            {
             
                SqlDataAdapter adapter = new SqlDataAdapter("select * from tb_Commodity", conn);
                SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
                DataSet ds = new DataSet();
                adapter.Fill(ds, "tb_Commodity");

                DataRow updateRow = ds.Tables["tb_Commodity"].NewRow();
                updateRow["CNum"]="DN1009";
                updateRow["CType"]="棉衣";
                updateRow["CQuarter"]="冬季";
                updateRow["CCodeNumGroup"]="衣服码数组";
                updateRow["CPurchasePrice"]=110;
                updateRow["CUnitPrice"] = 120;
                ds.Tables["tb_Commodity"].Rows.Add(updateRow);
                adapter.Update(ds, "tb_Commodity");
                Console.WriteLine(ds.Tables["tb_Commodity"].Rows.Count);

            }

//修改

string connString = "Data Source=USER-20150605LO;Initial Catalog=JXC;Integrated Security=True";
           
            using (SqlConnection conn = new SqlConnection(connString))
            {
               SqlCommand cmd = new SqlCommand("select * from tb_Commodity", conn);
               SqlDataAdapter  sda = new SqlDataAdapter();
               sda.SelectCommand = cmd;
               DataSet  ds = new DataSet();
               sda.Fill(ds, "tb_Commodity");
              
               ds.Tables[0].Rows[1]["CNum"] = "DN1024";
               ds.Tables[0].Rows[1]["CType"] = "秋裤4";
               ds.Tables[0].Rows[1]["CQuarter"] = "冬季4";
               SqlCommandBuilder cmdbuilder = new SqlCommandBuilder(sda);
               sda.Update(ds, "tb_Commodity");           
            }

//删除

string connString = "Data Source=USER-20150605LO;Initial Catalog=JXC;Integrated Security=True";
           
            using (SqlConnection conn = new SqlConnection(connString))
            {
                SqlCommand cmd = new SqlCommand("select * from tb_Commodity", conn);
                SqlDataAdapter sda = new SqlDataAdapter();
                sda.SelectCommand = cmd;
                DataSet ds = new DataSet();
                sda.Fill(ds, "tb_Commodity");


                ds.Tables["tb_Commodity"].Rows[2].Delete();
                SqlCommandBuilder cmdbuilder = new SqlCommandBuilder(sda);
                sda.Update(ds, "tb_Commodity");  

            }

//新增2

SqlConnection con=new SqlConnection;

SqlCommand com;

string sql;

com=new SqlCommand("",con);

com.CommandText="select top 1 * from score2"

sql="insert  into score2 values('TOM','11')"

con.Open();

com=new SqlCommand(sql,con);

com.ExecuteNonQuery();

con.Close();

MessageBox.Show("添加成功!");

</pre><pre name="code" class="html">