public static void Add_Order(DataTable tbl)
{
SqlConnection con=GetConnect();
SqlCommand com = new SqlCommand("insert into [Order](Pro_Name,Pro_Num,Customer_Name,Data_Out) values(@proname,@num,@cname,@dataout) ", con);
com.Parameters.Add("proname", SqlDbType.VarChar,50,"Pro_Name");
com.Parameters.Add("num", SqlDbType.Int,16,"Pro_Num");
com.Parameters.Add("cname", SqlDbType.VarChar,50,"Customer");
com.Parameters.Add("dataout", SqlDbType.DateTime,10,"Data_Out");
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.InsertCommand = com;
con.Open();
adapter.Update(tbl);
con.Close();
}
{
SqlConnection con=GetConnect();
SqlCommand com = new SqlCommand("insert into [Order](Pro_Name,Pro_Num,Customer_Name,Data_Out) values(@proname,@num,@cname,@dataout) ", con);
com.Parameters.Add("proname", SqlDbType.VarChar,50,"Pro_Name");
com.Parameters.Add("num", SqlDbType.Int,16,"Pro_Num");
com.Parameters.Add("cname", SqlDbType.VarChar,50,"Customer");
com.Parameters.Add("dataout", SqlDbType.DateTime,10,"Data_Out");
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.InsertCommand = com;
con.Open();
adapter.Update(tbl);
con.Close();
}
这是怎么回事?该怎么改啊?
com.Parameters.Add("@num", SqlDbType.Int,16,"Pro_Num");
com.Parameters.Add("@cname", SqlDbType.VarChar,50,"Customer");
com.Parameters.Add("@dataout", SqlDbType.DateTime,10,"Data_Out");
SqlDataAdapter adapter = new SqlDataAdapter();