请问我的语句有错吗？

[okok999]

private bool list(string li)
{
sqlConnection1.ConnectionString = "server=localhost;uid=lwx;pwd=12345;database=Northwind";
sqlConnection1.Open();
System.Data.SqlClient.SqlDataReader reader1;
reader1=sqlCommand1.ExecuteReader();
DataGrid1.DataSource=reader1;
while(reader1.Read())
{
if(reader1[1]=li){
return true;
break;}
else{return false;

}
}

reader1.Close();
sqlConnection1.Close();

}

[timmy3310]

改为：
private bool list(string li)
{
sqlConnection1.ConnectionString = "server=localhost;uid=lwx;pwd=12345;database=Northwind";
sqlConnection1.Open();
System.Data.SqlClient.SqlDataReader reader1;
reader1=sqlCommand1.ExecuteReader();
DataGrid1.DataSource=reader1;

bool result = false;
while(reader1.Read())
{
if(reader1[1]=li)
result = true;
}

reader1.Close();
sqlConnection1.Close();
return result;
}

[Knight94]

同意timmy，原句中在while中退出，没有关闭数据库连接。

[yuwen16]

up

[yuwen16]

Knight94(愚翁) 大哥，帮我看看这个帖子。。谢谢了！！
http://expert.csdn.net/Expert/topic/1668/1668868.xml?temp=.4463617