数据库连接: (查询)
的第一种方法:
SqlConnection conn = new SqlConnection("Server=(local);database=数据库名称;uid='sa';pwd=''");
//SqlConnection conn = new SqlConnection("Server='.';database=数据库名称";uid='sa';pwd='');
conn.Open();
String strsql = "select * from 表名";
SqlCommand cmd = new SqlCommand(strsql,conn);
SqlDataReader rd = cmd.ExecuteReader();
while(rd.Read()) //rd.Read() 是用来 检索数据库中是否存在数据.
{
Response.Write(rd.GetValue(0).ToString());//数据库第一个是从零开始.这个打印出来.
}
//ra.Read();就是检索数据库不打印出任何东西.
conn.Close();
数据库连接的第二种方法:(查询)
SqlConnection conn = new SqlConnection();
conn.ConnectionString= "Server=(local);database=数据库名称;uid='sa';pwd=''";
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText="sql语句";
cmd.Connection =conn;
SqlDataReader rd = cmd.ExecuteReader();
while(rd.Read())
{
Response.Write(rd.GetValue(0).ToString());
}
conn.Close();
要是不是查询的:
SqlConnection conn = new SqlConnection("Server=(local);database=数据库名称;uid='sa';pwd=''");
//SqlConnection conn = new SqlConnection("Server='.';database=数据库名称";uid='sa';pwd=''");
conn.Open();
SqlCommand cmd = new SqlCommand("sql语句",conn);
cmd.ExecuteNonQuery();
conn.Close();