以后还是要坚持这么写老是忘了。就单独写一个文章记录一下!
SqlCommand cmd = new SqlCommand("",connection1);
cmd.CommandText="insert into TUserLogin values(@Id,@Name)";
cmd.Parameters.Clear();
cmd.Parameters.Add("@Id",SqlDbType).Value =Id;
cmd.Parameters.Add("@Name",SqlDbType.VarChar).Value = Name;
cmd.ExecuteNonQuery();