读书人

executereader无可用的连接,已关闭解决

发布时间: 2012-01-19 20:57:59 作者: rapoo

executereader无可用的连接,已关闭
if (this.comboBox1.SelectedItem.ToString () == "蜀山区 ")
{

if (dbcon == null)
{
dbcon = leiku.connection.sqlconnect();

}
SqlCommand sqlcmd0 = dbcon.CreateCommand();
sqlcmd0.CommandText = leiku.connection.getshushandiqu();
SqlDataReader sqlD = sqlcmd0.ExecuteReader();
if (sqlD.Read())
{
this.listBox1.Items.Clear();
this.listBox1.Items.Add(sqlD.GetString(0).Trim());

}
//sqlcmd.Dispose();
//sqlD.Close();
}
else if (this.comboBox1.SelectedItem.ToString () == "包河区 ")
{
SqlCommand sqlcmd1 = dbcon.CreateCommand();
sqlcmd1.CommandText = leiku.connection.getbaohediqu();
MessageBox.Show(sqlcmd1.CommandText.ToString());
SqlDataReader sqlB = sqlcmd1.ExecuteReader();
if (sqlB.Read())


{
this.listBox1.Items.Clear();
this.listBox1.Items.Add(sqlB.GetString(0).Trim());

}
//sqlcmd.Dispose();
//sqlB.Close();
}
为什么不加else if就行了.是不是前面的executereader没有释放啊.

[解决办法]
你加了Else if 后,dbcon就没有被初始化或连接,代码明显有问题

读书人网 >C#

热点推荐