C#数据库数据连接

SqlConnection conn = new SqlConnection();//创建sqlconnection数据库连接对象

conn.ConnectionString = @"server = JOHAN; uid = sa; pwd=8581894633aA; database = userDB";//连接数据库
string sqlString = "select Username,Password from userTable where Username ='" + Username + "'";//匹配username相同的行，传输到dataset中
SqlDataAdapter sda = new SqlDataAdapter(sqlString, conn);//创建并初始化sqlcommand对象
DataSet ds = new DataSet();
sda.Fill(ds);//使用sqldataadapter的fill方法填充dataset

转载于:https://www.cnblogs.com/johanxu/p/5402526.html