这两段代码哪个比较好呀
while (mySdr.Read())
{
ListItem myLi = new ListItem(mySdr["ProvinceName"].ToString(), mySdr["ProvinceId"].ToString());
ddlProvince.Items.Add(myLi);
}ListItem myLi = null;
while (mySdr.Read())
{
myLi = new ListItem(mySdr["ProvinceName"].ToString(), mySdr["ProvinceId"].ToString());
ddlProvince.Items.Add(myLi);
}
while (mySdr.Read())
{
ListItem myLi = new ListItem(mySdr["ProvinceName"].ToString(), mySdr["ProvinceId"].ToString());
ddlProvince.Items.Add(myLi);
}ListItem myLi = null;
while (mySdr.Read())
{
myLi = new ListItem(mySdr["ProvinceName"].ToString(), mySdr["ProvinceId"].ToString());
ddlProvince.Items.Add(myLi);
}
finally
{
if (myConn.State == ConnectionState.Open)
{
myConn.Close();
}
}finally
{
if (myConn.State != ConnectionState.Close)
{
myConn.Close();
}
}
还有这两段
{
ListItem myLi = new ListItem(mySdr["ProvinceName"].ToString(), mySdr["ProvinceId"].ToString());
ddlProvince.Items.Add(myLi);
}ListItem myLi = null;
while (mySdr.Read())
{
myLi = new ListItem(mySdr["ProvinceName"].ToString(), mySdr["ProvinceId"].ToString());
ddlProvince.Items.Add(myLi);
}
============================================第2个优于第1个,提高.net性能
{
if (myConn.Open)
{
myConn.Close();
}
}