引用
using System.Data; using System.Data.SqlClient;
代码部分
SqlConnection conn; try { conn = new SqlConnection("Server=地址;DataBase=数据库名;Uid=用户名;pwd=用户密码;");//连接配置 SqlCommand cmd = new SqlCommand("select * from users", conn);//SQL语句 SqlDataReader reader = null;//结果存储 try { conn.Open(); reader = cmd.ExecuteReader(); while (reader.Read()) { Console.WriteLine("username=" + reader[1].ToString() + " ,password=" + reader[2].ToString() );//结果输出 } } catch (Exception ex) { } finally { reader.Close(); conn.Close(); } } catch (Exception oExcept) { Console.WriteLine("错误"); }
🙄 我一直都不懂怎弄SQL数据库….唉!!!!!