sql数据库,vs2010网站,C#语言;
sql数据库表 如图:
后台代码:
int id = 15002;
string constr = ConfigurationManager.AppSettings["cn"].ToString();
for (int i = 20; i < 100; i++)
{
SqlConnection con1 = new SqlConnection(constr);
con1.Open();
string sqlstr5 = "select * from yz where yid= '" + id + "'and bid ='" + i + "' ";
SqlCommand cmd5 = new SqlCommand(sqlstr5, con1);
SqlDataReader sdr5 = cmd5.ExecuteReader();
if (sdr5.Read())
{
SqlConnection con2 = new SqlConnection(constr);
con2.Open();
string sqlstr6 = "select * from ym where id= ' " + i + "'and name ='" + HyperLink1.Text.ToString().Trim() + "'";
SqlCommand cmd6 = new SqlCommand(sqlstr6, con2);
SqlDataReader sdr6 = cmd6.ExecuteReader();
if (sdr6.Read())
{
HyperLink1.Visible = true;
}
else
{
HyperLink1.Visible = false;
}
sdr6.Close();
string sqlstr7 = "select * from ym where id= ' " + i + "'and name ='" + HyperLink2.Text.ToString().Trim() + "'";
SqlCommand cmd7 = new SqlCommand(sqlstr7, con2);
SqlDataReader sdr7 = cmd7.ExecuteReader();
if (sdr7.Read())
{
HyperLink2.Visible = true;
}
else
{
HyperLink2.Visible = false;
}
sdr7.Close();
string sqlstr8 = "select * from ym where id= ' " + i + "'and name ='" + HyperLink3.Text.ToString().Trim() + "'";
SqlCommand cmd8 = new SqlCommand(sqlstr8, con2);
SqlDataReader sdr8 = cmd8.ExecuteReader();
if (sdr8.Read())
{
HyperLink3.Visible = true;
}
else
{
HyperLink3.Visible = false;
}
sdr8.Close();
string sqlstr9 = "select * from ym where id= ' " + i + "'and name ='" + HyperLink4.Text.ToString().Trim() + "'";
SqlCommand cmd9 = new SqlCommand(sqlstr9, con2);
SqlDataReader sdr9 = cmd9.ExecuteReader();
if (sdr9.Read())
{
HyperLink4.Visible = true;
}
else
{
HyperLink4.Visible = false;
}
sdr9.Close();
con2.Close();
}
sdr5.Close();
con1.Close();
}
第一个表是 用户组
第二个 是页面
第三个 是 用户所在分组
有没有什么办法让for循环结果整合在一起,上面代码这个for循环只显示了最后一个结果,有没有大神指教一下:谢谢!