效果是根据dropdownlist的变化来选择数据表的内容显示到datagrid里面,不知道哪错了,datagrid不显示.
protected void SchList_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("server=.;database=extdata;uid=sa;pwd=");
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("SELECT ID as 编号,SubmitTime as 提交时间,SendState as 发送状态 FROM SMS_SmsAmortize where SendState = '"+SchList.SelectedValue.ToString()+"'",con);
DataSet GraDs = new DataSet();
sda.Fill(GraDs);
int GraCount = GraDs.Tables[0].Rows.Count;
if (GraCount == 0)
{
MessageBox.Show(this, "没有找到短信");
}
else
{
this.grid.DataSource=GraDs.Tables[0].DefaultView;
this.grid.DataBind();
}
}
protected void SchList_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("server=.;database=extdata;uid=sa;pwd=");
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("SELECT ID as 编号,SubmitTime as 提交时间,SendState as 发送状态 FROM SMS_SmsAmortize where SendState = '"+SchList.SelectedValue.ToString()+"'",con);
DataSet GraDs = new DataSet();
sda.Fill(GraDs);
int GraCount = GraDs.Tables[0].Rows.Count;
if (GraCount == 0)
{
MessageBox.Show(this, "没有找到短信");
}
else
{
this.grid.DataSource=GraDs.Tables[0].DefaultView;
this.grid.DataBind();
}
}
奇怪的是我加了con.Colse()之后就可以了
this.grid.DataSource=GraDs
试试