Question

c#中获取数据库中相应的年月在Gridview显示

用的是c#, 想要弄一页查询页面，使用户选择年月后就能在gridview中显示相应年月的信息，数据库中存的是年月日

Answer 1

先把数据库中的年月日读取出来绑定到用来给用户选择的控件上，比如dropdownlist，然后编写dropdownlist的初始化代码
protected void Page_Load(object sender, EventArgs e)
{
string sqlstr = "server=(local);uid=sa;pwd=000;Database=MilkTea";
string cmdstr = "select * from[article]";
SqlConnection conn = new SqlConnection(sqlstr);
DataSet ds = new DataSet();
ds.Clear();
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(cmdstr, conn);
da.Fill(ds);
conn.Close();
if (ds.Tables[0] != null)
{
DropDownList1.DataSource = ds.Tables[0].DefaultView;
DropDownList1.DataValueField = "pubtime";
DataBind();
DropDownList1.Items.Insert(0, new ListItem("--请选择--", ""));
}
}
然后再编写dropdownlist的selectedindexchanged方法
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
string sqlstr = "server=(local);uid=sa;pwd=000;Database=MilkTea";
string cmdstr = "select * from[article]";
SqlConnection conn = new SqlConnection(sqlstr);
DataSet ds = new DataSet();
ds.Clear();
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(cmdstr, conn);
da.Fill(ds);
conn.Close();
if (ds.Tables[0] != null)
{
GridView1.DataSource = ds;
DataBind();
}
}
以上代码我调试过是可以用的~有什么地方你在问