Question

使用两个textbox 一个dropdownlist 一个button 和一个Gridview 来实现数据显示

例如一个表
id title date status
1 小说 2009-03-01 发货
2 英语 2008-06-05 未发货
3 数学 2009-02-05 发货
4 物理 2007-01-03 未发货
我想查询从2007-01-03到2009-02-05 status为 “未发货”的数据

我的想法是两个textbox输入时间 dropdownlist可以选择 “发货”或是“未发货” 然后点击确定显示
假设 数据库连接为 Data Source=8C08C\\MSSV;Initial Catalog=test;Integrated Security=True
表名称 name
string ConnStr = "Data Source=BEIFA-888C078AC\\MSSQLSERVER08;Initial Catalog=test;Integrated Security=True";
SqlConnection conn = new SqlConnection(ConnStr);
SqlCommand cmd = new SqlCommand();
SqlDataAdapter sda = new SqlDataAdapter();
DataSet ds = new DataSet();
conn.Open();
cmd.Connection = conn;
string mn = TextBox1.Text.Trim().ToString();
string mnn = TextBox2.Text.Trim().ToString();
cmd.CommandText = "select * from name where date>='"+mn+"' and date<='"+mnn+"'and date=@Sqlpara"; 这里 怎么加上dropdownlist的值
sda.SelectCommand = cmd;
SqlParameter para = new SqlParameter();
para.ParameterName = "@Sqlpara";
para.Value = sqlPara; 这里 根据一个textbox改的 请问这里怎么取到两个textbox的中间值
cmd.Parameters.Add(para);
sda.Fill(ds);
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataBind();

Answer 1

//最好不要使用集成身份验证
string ConnStr = "Data Source=BEIFA-888C078AC\\MSSQLSERVER08;Initial Catalog=test;Integrated Security=True";
SqlConnection conn = null;
SqlCommand cmd = null;
SqlDataAdapter sda = null;
string sql = "select * from name where date>= @startDate and date<= @endDate and status=@status";
DataSet ds = new DataSet();
try
{
conn = new SqlConnection(ConnStr);
cmd = new SqlCommand(sql, conn);
sda = new SqlDataAdapter(cmd);
cmd.Parameters.AddWithValue("@startdate", TextBox1.Text.Trim());
cmd.Parameters.AddWithValue("@endDate", TextBox2.Text.Trim());
cmd.Parameters.AddWithValue("@status", DropDownList1.SelectedValue);
//链接要最晚打开
conn.Open();
sda.Fill(ds);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
if (conn != null)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
conn.Dispose();
}
if (cmd != null)
{
cmd.Dispose();
}
}
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataBind();

Answer 2

代码是要自己写的，写完有问题是需要问的

Answer 3

没看懂要问什么啊，dropdownlist的值不就是取SelectedValue就行了
还有两个textbox的中间值啥意思啊

Answer 4

cmd.CommandText = "select * from name where date>='"+mn+"' and date<='"+mnn+"'and date=@Sqlpara and status='"+dropdownlist.selectedvalue+"'";