C#文本写入数据库(未解决)
Default2.aspx
1![]()
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>
2![]()
3![]()
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
4![]()
5![]()
<html xmlns="http://www.w3.org/1999/xhtml" >
6![]()
<head runat="server">
7![]()
<title>无标题页</title>
8![]()
</head>
9![]()
<body>
10![]()
<form id="form1" runat="server">
11![]()
<div>
12![]()
姓名：<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br />
13![]()
性别：
14![]()
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
15![]()
<br />
16![]()
QQ：<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
17![]()
<br />
18![]()
邮箱：<asp:TextBox ID="TextBox4" runat="server"></asp:TextBox><br />
19![]()
<br />
20![]()
<br />
21![]()
<br />
22![]()
<asp:Button ID="Button1" runat="server" Text="Button" /></div>
23![]()
</form>
24![]()
</body>
25![]()
</html>
26![]()
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>2
3
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">4
5
<html xmlns="http://www.w3.org/1999/xhtml" >6
<head runat="server">7
<title>无标题页</title>8
</head>9
<body>10
<form id="form1" runat="server">11
<div>12
姓名：<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br />13
性别：14
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>15
<br />16
QQ：<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>17
<br />18
邮箱：<asp:TextBox ID="TextBox4" runat="server"></asp:TextBox><br />19
<br />20
<br />21
<br />22
<asp:Button ID="Button1" runat="server" Text="Button" /></div>23
</form>24
</body>25
</html>26
Default2.aspx.cs
1![]()
using System;
2![]()
using System.Data;
3![]()
using System.Configuration;
4![]()
using System.Collections;
5![]()
using System.Web;
6![]()
using System.Web.Security;
7![]()
using System.Web.UI;
8![]()
using System.Web.UI.WebControls;
9![]()
using System.Web.UI.WebControls.WebParts;
10![]()
using System.Web.UI.HtmlControls;
11![]()
using System.Data.OleDb; //这里要引用OleDb空间
12![]()
13![]()
public partial class Default2 : System.Web.UI.Page
14![]()
{
15![]()
//数据库连接字符串
16![]()
static string strCon = @"provider = Microsoft.Jet.OLEDB.4.0;Data source = D:\liuyan\App_Data\db.mdb";
17![]()
18![]()
//申明连接数据源的对象和对数据源进行操作的对象
19![]()
OleDbConnection con = new OleDbConnection(strCon);
20![]()
OleDbCommand cmd = new OleDbCommand();
21![]()
22![]()
//点击按钮添加记录
23![]()
protected void Button1_Click(object sender, EventArgs e)
24![]()
{
25![]()
string name = TextBox1.Text.Trim(); //姓名
26![]()
string sex = TextBox2.Text.Trim(); //性别
27![]()
string qq = TextBox3.Text.Trim(); //QQ
28![]()
string email = TextBox4.Text.Trim(); //Email
29![]()
30![]()
//要插入记录的sql语句
31![]()
string insertText = "insert into biao(name,sex,qq,email) values('" + name + "','" + sex + "','" + qq + "','" + email + "')";
32![]()
33![]()
//数据源打开
34![]()
con.Open();
35![]()
36![]()
//设置操作对象的数据源
37![]()
cmd.Connection = con;
38![]()
39![]()
//要执行的SQL语句
40![]()
cmd.CommandText = insertText;
41![]()
42![]()
//执行操作
43![]()
cmd.ExecuteNonQuery();
44![]()
45![]()
//数据源关闭
46![]()
con.Close();
47![]()
}
48![]()
49![]()
protected void Page_Load(object sender, EventArgs e)
50![]()
{
51![]()
52![]()
}
53![]()
}
using System;2
using System.Data;3
using System.Configuration;4
using System.Collections;5
using System.Web;6
using System.Web.Security;7
using System.Web.UI;8
using System.Web.UI.WebControls;9
using System.Web.UI.WebControls.WebParts;10
using System.Web.UI.HtmlControls;11
using System.Data.OleDb; //这里要引用OleDb空间 12
13
public partial class Default2 : System.Web.UI.Page14
{
15
//数据库连接字符串 16
static string strCon = @"provider = Microsoft.Jet.OLEDB.4.0;Data source = D:\liuyan\App_Data\db.mdb";17
18
//申明连接数据源的对象和对数据源进行操作的对象 19
OleDbConnection con = new OleDbConnection(strCon);20
OleDbCommand cmd = new OleDbCommand();21
22
//点击按钮添加记录 23
protected void Button1_Click(object sender, EventArgs e)24
{
25
string name = TextBox1.Text.Trim(); //姓名 26
string sex = TextBox2.Text.Trim(); //性别 27
string qq = TextBox3.Text.Trim(); //QQ 28
string email = TextBox4.Text.Trim(); //Email 29
30
//要插入记录的sql语句 31
string insertText = "insert into biao(name,sex,qq,email) values('" + name + "','" + sex + "','" + qq + "','" + email + "')";32
33
//数据源打开 34
con.Open();35
36
//设置操作对象的数据源 37
cmd.Connection = con;38
39
//要执行的SQL语句 40
cmd.CommandText = insertText;41
42
//执行操作 43
cmd.ExecuteNonQuery();44
45
//数据源关闭 46
con.Close();47
}48
49
protected void Page_Load(object sender, EventArgs e)50
{51
52
}53
}数据库db.mdb中表:biao
以上是代码文件,运行不出错,可是就是写不进去数据库(ACCESS),极度郁闷,敬请高人指正!不慎感激!
浙公网安备 33010602011771号