Question

SQL查询出语句的结果 赋值给变量

中间数据库 具体怎么写 不太清楚 麻烦大家帮忙了

public partial class DataBindingDemo : System.Web.UI.Page
{

protected static int vote1 = 0;
protected static int vote2 = 0;
protected static int vote3 = 0;

protected void Page_Load(object sender, EventArgs e)
{
conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["SqlConnectionString"].ConnectionString);
conn.Open();
//vote1是 变量 他的值等于 SQL语句查询出来的结果 中间这块怎么写我不太清楚 麻烦大家指教
vote1=SELECT COUNT(Topic1) FROM RoundTable1 WHERE (Topic1 = 'a')
vote2=SELECT COUNT(Topic1) FROM RoundTable1 WHERE (Topic1 = 'b')
vote3=SELECT COUNT(Topic1) FROM RoundTable1 WHERE (Topic1 = 'c')

conn.Close();

this.DataBind();

}

Answer 1

呵，不是太麻烦的用Reader可以实现，给你个小例子：

SqlConnection conn = new SqlConnection("Server=(local);DataBase=tmp;Uid=sa;Pwd=1122");
SqlDataReader r ;
SqlCommand cmd = new SqlCommand("select count(*) from table1",conn);
conn.Open();
r = cmd.ExecuteReader();
if (r.Read()) //如果sql查询到了数据
MessageBox.Show(r.GetInt32(0).ToString());
conn.Close();

如果还不明白发消息给我。