SqlConnection conn = new SqlConnection(constr);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from T_News where Id=@id";
方法一:
// cmd.Parameters.AddWithValue("@id", id);
// //方法二:
//SqlParameter par = new SqlParameter("@id", id);
//cmd.Parameters.Add(par);
//方法三:
//SqlParameter par= new SqlParameter("@id",SqlDbType.Int);
//par.Value = id;
//cmd.Parameters.Add(par);
Response.Write(cmd.ExecuteScalar());
cmd.Dispose();
conn.Dispose();
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from T_News where Id=@id";
方法一:
// cmd.Parameters.AddWithValue("@id", id);
// //方法二:
//SqlParameter par = new SqlParameter("@id", id);
//cmd.Parameters.Add(par);
//方法三:
//SqlParameter par= new SqlParameter("@id",SqlDbType.Int);
//par.Value = id;
//cmd.Parameters.Add(par);
Response.Write(cmd.ExecuteScalar());
cmd.Dispose();
conn.Dispose();