string conStr = "server=ip地址;database=Test001;uid=sa;pwd=123";
using (SqlConnection conn = new SqlConnection(conStr)) {
conn.Open();
string sql = "select * from AAAA";
using (SqlCommand cmd = new SqlCommand(sql,conn)) {
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows) {
while (reader.Read()) {
Console.Write(reader["列名"].ToString().Trim());
Console.WriteLine(reader["列名"].ToString().Trim());
}
}
Console.ReadKey();
}
}