62,046
社区成员
发帖
与我相关
我的任务
分享问个循环填充的问题
try
{
GridView4.Visible = true;
string sql = "select username from surveylog where SurveyStatus='有效'";
con = new SqlConnection(str);
con.Open();
com = new SqlCommand(sql, con);
read = com.ExecuteReader();
while (read.Read())
{
string name = read["username"].ToString();
read.Close();
string sql1 = "select Email,AlternateEmail from member where username='" + name + "'";
SqlDataAdapter ada = new SqlDataAdapter(sql1, con);
//read.Close();
DataSet ds = new DataSet();
ada.Fill(ds);
GridView4.DataSource = ds;
GridView4.DataBind();
}
con.Close();
}
catch(Exception ex)
{
ex.ToString();
}
阅读器关闭时 Read 的尝试无效。请问这个要怎么解决啊？谢谢
{
GridView4.Visible = true;
string sql = "select username from surveylog where SurveyStatus='有效'";
con = new SqlConnection(str);
con.Open();
com = new SqlCommand(sql, con);
read = com.ExecuteReader();
while (read.Read())
{
string name = read["username"].ToString();
read.Close();
string sql1 = "select Email,AlternateEmail from member where username='" + name + "'";
SqlDataAdapter ada = new SqlDataAdapter(sql1, con);
//read.Close();
DataSet ds = new DataSet();
ada.Fill(ds);
GridView4.DataSource = ds;
GridView4.DataBind();
}
con.Close();
}
catch(Exception ex)
{
ex.ToString();
}
阅读器关闭时 Read 的尝试无效。请问这个要怎么解决啊？谢谢
...全文
请发表友善的回复…
发表回复
lys1978900 2008-12-15
- 打赏
- 举报
都read.Close()了，怎么还read.Read()呢？
没必要这么写吧？
可以建个新表，然后把它们连接在一起
最后再绑定
没必要这么写吧？
可以建个新表，然后把它们连接在一起
最后再绑定
heyu1000 2008-12-15
- 打赏
- 举报
在con.Close();之前加上read.Close();
