public static DataTable SqlConnectionInformation()

{

string connstr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

DataTable dt = new DataTable();

using (SqlConnection conn = new SqlConnection(connstr))

{

if (conn.State == ConnectionState.Closed)

{

conn.Open();

}

string sql = "select * from table";

SqlCommand com = new SqlCommand(sql, conn);

SqlDataAdapter adapter = new SqlDataAdapter(com);

adapter.Fill(dt);

}

return dt; 

}

 for (int i = ; i < dt.Rows.Count; i++)

            {

                string s = "select count(*) from " + dt.Rows[i]["AliasName"] + ".dbo.web_historydata where factoryid=" + dt.Rows[i]["FactoryID"] + " and  datetime >dateadd(HOUR,-1,GetDate())";

                int count = my_SqlHelper.SelectCounts(s);

                if (count<=)

                {

                    Log.Save("蜀云泉真帅啊");

                }

            }

   for (int i = ; i < dataTable.Rows.Count; i++)

            {

                for (int j = ; j < dataTable.Columns.Count; j++)

                {

                    Console.WriteLine(dataTable.Rows[i][j].ToString());

                }

            }