static void Main(string[] args)
{
// select id, uid, pwd from Exe2.LoginTbl;
string connStr = @"server=.;database=MyFirstDataBase;uid=sa;pwd=727003369;";
string sql = "select Id as 列名, UserName as 用户名, UserPwd as 密码 from TblLogin;";
using (SqlConnection conn = new SqlConnection(connStr))
{
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
using (reader)
{
Console.WriteLine("{0}\t{1}\t{2}",
reader.GetName(0),
reader.GetName(1),
reader.GetName(2)
);
while (reader.Read())
{
/*
object id = reader[0];
object uid = reader[1];
object pwd = reader[2];
*/
object id = reader["列名"];
object uid = reader["用户名"];
object pwd = reader["密码"];
Console.WriteLine("{0}\t{1}\t{2}", id, uid, pwd);
}
}
}
}
Console.ReadKey();
}
{
// select id, uid, pwd from Exe2.LoginTbl;
string connStr = @"server=.;database=MyFirstDataBase;uid=sa;pwd=727003369;";
string sql = "select Id as 列名, UserName as 用户名, UserPwd as 密码 from TblLogin;";
using (SqlConnection conn = new SqlConnection(connStr))
{
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
using (reader)
{
Console.WriteLine("{0}\t{1}\t{2}",
reader.GetName(0),
reader.GetName(1),
reader.GetName(2)
);
while (reader.Read())
{
/*
object id = reader[0];
object uid = reader[1];
object pwd = reader[2];
*/
object id = reader["列名"];
object uid = reader["用户名"];
object pwd = reader["密码"];
Console.WriteLine("{0}\t{1}\t{2}", id, uid, pwd);
}
}
}
}
Console.ReadKey();
}