string worksitename = this.Request.QueryString["worksitename"].ToString();
this.Label1.Text = worksitename; string sql = "select Count(worksitename) from jy_workcircs_tb where worksitename=" + worksitename;
SqlConnection conn = new SqlConnection(ConnString);
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
int count = int.Parse(cmd.ExecuteScalar().ToString());
this.Label2.Text = count.ToString();
this.Label1.Text = worksitename; string sql = "select Count(worksitename) from jy_workcircs_tb where worksitename=" + worksitename;
SqlConnection conn = new SqlConnection(ConnString);
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
int count = int.Parse(cmd.ExecuteScalar().ToString());
this.Label2.Text = count.ToString();
string worksitename = this.Request.QueryString["worksitename"].ToString();
this.Label1.Text = worksitename; string sql = "select Count(worksitename) from jy_workcircs_tb where worksitename='" + worksitename+"'"; //字符串前後加上單引號'
SqlConnection conn = new SqlConnection(ConnString);
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
int count = int.Parse(cmd.ExecuteScalar().ToString());
this.Label2.Text = count.ToString();
==>
Int32 count = (int32) cmd.ExecuteScalar();