查询事件 gridview.datasourse=sqlhelper("select * from mytb where datetime "+between txtBTime.text+" and "+txtETime.text) gridview.databind()
web是Calendar,winform才是datetimepicker Sorry!!
protected void Button1_Click(object sender, EventArgs e) { GridView1.DataSource=DBUtility.SqlHelper("select * from Errarticle where datetime "+between tb_bgtime.text+" and "+tb_endtime.text); GridView1.DataBind(); }假设这是点查询后触发的事件 单这句SQL语句有错 谁能指点一下 分都归你,拜托拉
select * from Errarticle where datetime between"+ tb_bgtime.text+" and "+tb_endtime.text
protected void Button1_Click(object sender, EventArgs e) { GridView1.DataSource=DBUtility.SqlHelper("select * from Errarticle where datetime between "+tb_bgtime.text+" and "+tb_endtime.text); GridView1.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { GridView1.DataSource=DBUtility.SqlHelper("select * from Errarticle where datetime between" + tb_bgtime.Text +" and "+ tb_endtime.Text"); GridView1.DataBind(); }现在问题出现在最后个.Text上;错误原因 :应输入) 应输入;
public static DataSet Query(string SQLString) { using (SqlConnection connection = new SqlConnection(connectionString)) { DataSet ds = new DataSet(); try { connection.Open(); SqlDataAdapter command = new SqlDataAdapter(SQLString, connection); command.Fill(ds, "ds"); } catch (System.Data.SqlClient.SqlException ex) { throw new Exception(ex.Message); } return ds; } } protected void Button1_Click(object sender, EventArgs e) { GridView1.DataSource=DBUtility.DbHelperSQL.Query("select * from Errarticle where datetime between" + tb_bgtime.Text +" and "+ tb_endtime.Text); GridView1.DataBind(); }还是不行 - -
GridView1.DataSource=DBUtility.DbHelperSQL.Query("select * from Errarticle where datetime between " + tb_bgtime.Text +" and "+ tb_endtime.Text).Tables["ds"]; GridView1.DataBind(); 这样再试试看。。
gridview.datasourse=sqlhelper("select * from mytb where datetime "+between txtBTime.text+" and "+txtETime.text)
gridview.databind()
web是Calendar,winform才是datetimepicker
Sorry!!
protected void Button1_Click(object sender, EventArgs e)
{
GridView1.DataSource=DBUtility.SqlHelper("select * from Errarticle where datetime "+between tb_bgtime.text+" and "+tb_endtime.text);
GridView1.DataBind();
}假设这是点查询后触发的事件 单这句SQL语句有错 谁能指点一下 分都归你,拜托拉
protected void Button1_Click(object sender, EventArgs e)
{
GridView1.DataSource=DBUtility.SqlHelper("select * from Errarticle where datetime between "+tb_bgtime.text+" and "+tb_endtime.text);
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
GridView1.DataSource=DBUtility.SqlHelper("select * from Errarticle where datetime between" + tb_bgtime.Text +" and "+ tb_endtime.Text");
GridView1.DataBind();
}现在问题出现在最后个.Text上;错误原因 :应输入) 应输入;
“DBUtility.SqlHelper”是一个"类型",这在给定的上下文中无效
这个错误是什么意思?怎么解决?
while (dr.Read())
{
str += dr["StudentNO"].ToString();
}
dr.Close();
你这里的DBUtility.SqlHelper应该是类似public static DataTable SqlHelper(string strSQL){}这样一个方法才行。。
public static DataSet Query(string SQLString)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
DataSet ds = new DataSet();
try
{
connection.Open();
SqlDataAdapter command = new SqlDataAdapter(SQLString, connection);
command.Fill(ds, "ds");
}
catch (System.Data.SqlClient.SqlException ex)
{
throw new Exception(ex.Message);
}
return ds;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
GridView1.DataSource=DBUtility.DbHelperSQL.Query("select * from Errarticle where datetime between" + tb_bgtime.Text +" and "+ tb_endtime.Text);
GridView1.DataBind();
}还是不行 - -
GridView1.DataSource=DBUtility.DbHelperSQL.Query("select * from Errarticle where datetime between " + tb_bgtime.Text +" and "+ tb_endtime.Text).Tables["ds"];
GridView1.DataBind();
这样再试试看。。
Calendar1.SelectedDate.ToString();