配置文件内容:
<connectionStrings>
<add name="StudentInfoConnectionString" connectionString="Data Source=TANGPRO;Initial Catalog=StudentInfo;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
代码页内容:
//调用配置文件中的连接对象
string constr = System.Configuration.ConfigurationManager.ConnectionStrings["StudentInfoConnectionString"].ConnectionString;
//建立连接
using(SqlConnection conn = new SqlConnection(constr))
{
//打开连接
conn.Open();
//命令
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select no as 学号,name as姓名, gender as 性别, birthday as 出生日期 from student";
//数据集
SqlDataReader reader = cmd.ExecuteReader();
//数据集赋给显示控件
GridView1.DataSource = reader;
GridView1.DataBind();
//最后记得关闭连接
conn.Close();
}
法二:
//调用连接字符串
string strConn = System.Configuration.ConfigurationManager.ConnectionStrings["StudentInfoConnectionString"].ConnectionString;
//建立连接对象
SqlConnection conn = new SqlConnection();
//打开连接
conn.Open();
//sql语句
string strSql = "select no as 学号,name as姓名, gender as 性别, birthday as 出生日期 from student";
//操作对象
SqlCommand cmd = new SqlCommand(strSql, conn); //注意后面需要加上 操作语句 + 连接对象
//数据集
SqlDataReader reader = cmd.ExecuteReader();
//显示数据
GridView1.DataSource = reader;
GridView1.DataBind();
//关闭连接
conn.Close();
向数据库中插入数据
string orderID = TextBox1.Text;
string orderNAME = TextBox2.Text;
string conStr = System.Configuration.ConfigurationManager.ConnectionStrings["NewTestConnectionString"].ConnectionString;
SqlConnection conn = new SqlConnection(conStr);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "insert into OrderTest(orderId,orderName) values('" + orderID + "','" + orderNAME + "')";//注意格式
cmd.ExecuteNonQuery();//用于执行不返回结果,eg: 插入,删除,更像操作
Label1.Text = "信息录入完成";
conn.Close();