UC知道c#连接数据库
来源：百度知道 编辑：UC知道 时间：2024/05/15 11:00:42
using System;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class add_user : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btAdd_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
string sql = "Insert into users(username,password,email) ";
sql += "values('" + tbName.Text + "','" + tbPsw.Text + "','" + tbEmail.Text + "');";
this.ExcuteSql(sql);
Response.Write("注
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class add_user : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btAdd_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
string sql = "Insert into users(username,password,email) ";
sql += "values('" + tbName.Text + "','" + tbPsw.Text + "','" + tbEmail.Text + "');";
this.ExcuteSql(sql);
Response.Write("注
DbProviderFactory dbProviderFactory = DbProviderFactories.GetFactory("System.Data.SqlClient");
DbConnection dbConn = dbProviderFactory.CreateConnection();
这用的是工厂设计模式和一个叫什么来着。记不起来名了。singletang什么来着。
这样的写法主要是为了数据库切换，要是没有那么频繁的数据库切换。
完全可以用 System.Data.Sql 下的一切命名空间。
参考以下