怎么在for循环中查询sql语句,像这样的
public static List<Brands> GetAllBrands()
{
List<Brands> list = null;
for (int i = 0; i < GetNames().Count;i++ )
{
SqlConnection conn = new SqlConnection(connstring);
string DataNames = GetNames()[i].ToString()+".dbo.Brand";
string sql = string.Format("select * from "+DataNames);
string sql1 = string.Format(" union all select * from "+DataNames);
sql = sql + sql1;
SqlCommand comm = new SqlCommand(sql, conn);
SqlDataReader sdr = comm.ExecuteReader();
conn.Open();
if (sdr.HasRows)
{
list = new List<Brands>();
}
while (sdr.Read())
{
Brands brand = new Brands();
brand.Id = Convert.ToInt32(sdr["Id"]);
brand.Name = Convert.ToString(sdr["Name"]);
brand.Describe = Convert.ToString(sdr["Describe"]);
brand.IsPublish = Convert.ToInt32(sdr["IsPublish"]);
brand.Models = Convert.ToString(sdr["Models"]);
brand.CreateTime = Convert.ToString(sdr["CreateTime"]);
brand.BlongData = Convert.ToString(sdr["BlongData"]);
list.Add(brand);
}
sdr.Close();
conn.Close();
}
return list;
}
其实我想把数据库名循环出来,可是不会啊啊啊啊~~~求解。还有就是他跟我报错说我的connstring没打开