string strCon = "Data Source=xxx;Database=db;Uid=xx;Pwd=xx";
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection connection = new SqlConnection(strCon);
connection.Open();
string username = Environment.UserName;
string sql = "select 語句";
SqlCommand sqlcom = new SqlCommand(sql, connection);
string n = sqlcom.ExecuteScalar().ToString ();
if (n!="0")
{
Response.Redirect("頁面");
}
}
1、返回update、delete、insert的行数
int rows = cmd.ExecuteNonQuery();