62,243
社区成员




<connectionStrings>
<add name="conn" connectionString="Data Source=.;Initial Catalog=test;User ID=sa" />
</connectionStrings>
using System.Configuration;
using System.Data.SqlClient;
// string app = ConfigurationManager.AppSettings[""]; //获取你appSettings下的key值
string conn = ConfigurationManager.ConnectionStrings["conn"].ToString(); //获取你connectionStrings下的name值
string sql = "insert into tb_users values('连接测试','123')"; //sql语句
SqlConnection sqlconn = new SqlConnection(conn);//链接数据库
sqlconn.Open();//打开数据库链接
SqlCommand sqlcomm = new SqlCommand(sql, sqlconn);//执行命令
int result = sqlcomm.ExecuteNonQuery();//返回受影响的行数
if (result > 0)
{
Response.Write("<script>alert('添加成功!');</script>");
}
else
{
Response.Write("<script>alert('添加失败!');</script>");
}
sqlconn.Close();//关闭数据库连接