如何将选定记录计入变量？ [英] how to get count of selected record into the variable?

问题描述

protected void Page_Load(object sender, EventArgs e)
    {
 string current_date = DateTime.Now.ToString("dd-MMM-yy");
        Lbl_todays_date.Text = current_date;

        string total_booked = "select count(selected_date) from user_record where selected_date='" + Lbl_todays_date.Text + "'";
        cmd2 = new OleDbCommand(total_booked, cn);
        dr2 = cmd2.ExecuteReader();
        cn.Close();
}

推荐答案

使用

Use

protected void Page_Load(object sender, EventArgs e)
    {
 string current_date = DateTime.Now.ToString("dd-MMM-yy");
        Lbl_todays_date.Text = current_date;
 
        string total_booked = "select count(selected_date) from user_record where selected_date='" + Lbl_todays_date.Text + "'";
        cmd2 = new OleDbCommand(total_booked, cn);
       dr2 = Convert.ToInt32(cmd2.ExecuteScaler()); //instead of cmd2.ExecuteReader();
      //ExecuteScalar method will return you the integer value
        
        cn.Close();
}

这篇关于如何将选定记录计入变量？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！