protected void Button1_Click(object sender, EventArgs e)
{
string neo = "server=PC-201001251306\\SQLEXPRESS;database=Data_ID;uid=sa;pwd=00";
SqlConnection conn = new SqlConnection(neo);
SqlCommand cmm = new SqlCommand();
cmm.Connection = conn;
try
{
conn.Open();
Response.Write(conn.DataSource.ToString());
SqlTransaction transql = null;
transql = conn.BeginTransaction();
cmm.Transaction = transql;
cmm.CommandText = "Insert Into uid(user,pass)Calues(@user,@pass)";
cmm.Parameters.Add("@user", SqlDbType.NVarChar);
cmm.Parameters.Add("@pass", SqlDbType.NVarChar);
cmm.Parameters["@user"].Value = TextUser.Text;
cmm.Parameters["@pass"].Value = TextPass.Text;
cmm.ExecuteNonQuery();
transql.Commit();
Response.Write("成功!");
}
catch { Response.Write("失败!"); } }
{
string neo = "server=PC-201001251306\\SQLEXPRESS;database=Data_ID;uid=sa;pwd=00";
SqlConnection conn = new SqlConnection(neo);
SqlCommand cmm = new SqlCommand();
cmm.Connection = conn;
try
{
conn.Open();
Response.Write(conn.DataSource.ToString());
SqlTransaction transql = null;
transql = conn.BeginTransaction();
cmm.Transaction = transql;
cmm.CommandText = "Insert Into uid(user,pass)Calues(@user,@pass)";
cmm.Parameters.Add("@user", SqlDbType.NVarChar);
cmm.Parameters.Add("@pass", SqlDbType.NVarChar);
cmm.Parameters["@user"].Value = TextUser.Text;
cmm.Parameters["@pass"].Value = TextPass.Text;
cmm.ExecuteNonQuery();
transql.Commit();
Response.Write("成功!");
}
catch { Response.Write("失败!"); } }
sql 语句?
Calues 什么东东?
Insert Into uid(user,pass)Calues(@user,@pass)
??