如何把前台的数据写入数据库中(如注册界面)

你是指什么语言呀。

我就以asp+access为例吧

比如在前台画面上有一个文本框叫name

那么我们要把name写到数据库里代码如下

界面（jiemian.asp）

<form name=f1 action=houtai.asp method=post>

<input type=text name=name>

<input type=submit value=submit>

<form>

后台（houtai.asp）

<!--#include file="conn.asp"-->

<%

conn.execute("insert into 表名(username) values('"&request.form("name") &"')") 'username是字段名

call endConnection()

%>

conn.asp

<%

dim conn

dim connstr

dim db

db="数据库名.mdb"

Set conn = Server.CreateObject("ADODB.Connection")

connstr="driver={Microsoft Access Driver (*.mdb)}dbq=" &Server.MapPath(""&db&"")

conn.Open connstr

sub endConnection()

conn.close

set conn=nothing

end sub

%>

这样就行了。

C#就更好作了

代码如下，我只写登陆按钮的事件

OledbConnection conn=new OledbConnection("连接串")

OledbCommand comm=new OledbCommand()

comm.Connection=conn

comm.CommandText="insert into ....."

comm.ExecuteNonQuery()

这样就可以了。

用c# *** 作数据库吗？

SqlConnection sqlConn = new SqlConnection(connectionString)

sqlConn.Open()打开数据库

SqlCommand cmd = new SqlCommand(SQLString, connection) cmd.ExecuteNonQuery()

connectionString是连接数据库字符串

SQLString:sql语句

金仓数据库 ？

-----------------------给你一段C# *** 作sqlserver的示例代码

1.数据库建表，

create table mytable(

pkid nvarchar(40) not null,

a nvarchar(40) null

)

insert into mytable(pkid,a) values(newid(),'测试')

2.新建对应此表的实体类

[Serializable]

public class mytable

{

private String _pkid = ""

public String pkid

{

get { return _pkid}

set { _pkid = value}

}

private String _a = ""

public String a

{

get { return _a}

set { _a = value}

}

}

3.新建 *** 作类：

public class mytableDAO

{

private String _ConnectionString

public mytableDAO(String ConnectionString)

{

this._ConnectionString = ConnectionString

}

public int New(Entities.MsgRecord obj)

{

String sql = "insert into mytable(pkid,a) values(@pkid,@a)"

SqlConnection cn = new SqlConnection(this._ConnectionString)

SqlCommand cmd = new SqlCommand(sql, cn)

cmd.Parameters.AddWithValue("@a", obj.a)

cmd.Parameters.AddWithValue("@pkid",

String.Empty.Equals(obj.pkid) ? System.Guid.NewGuid().ToString() : obj.pkid)

try

{

if (cn.State != ConnectionState.Open)

cn.Open()

return cmd.ExecuteNonQuery()

}

catch

{

return -1

}

finally

{

if (cn.State != ConnectionState.Closed)

cn.Close()

}

}

public int Update(Entities.mytable obj)

{

String sql = "Update mytable Set a=@a Where pkid=@ObjectID"

SqlConnection cn = new SqlConnection(this._ConnectionString)

SqlCommand cmd = new SqlCommand(sql, cn)

cmd.Parameters.AddWithValue("@a", obj.a)

cmd.Parameters.AddWithValue("@pkid", obj.pkid)

try

{

if (cn.State != ConnectionState.Open)

cn.Open()

return cmd.ExecuteNonQuery()

}

catch

{

return -1

}

finally

{

if (cn.State != ConnectionState.Closed)

cn.Close()

}

}

public int Del(Entities.mytable obj)

{

String sql = "delete from mytable Where pkid=@ObjectID"

SqlConnection cn = new SqlConnection(this._ConnectionString)

SqlCommand cmd = new SqlCommand(sql, cn)

cmd.Parameters.AddWithValue("@ObjectID", obj.pkid)

try

{

if (cn.State != ConnectionState.Open)

cn.Open()

return cmd.ExecuteNonQuery()

}

catch

{

return -1

}

finally

{

if (cn.State != ConnectionState.Closed)

cn.Close()

}

}

public int Del(String where)

{

String sql = String.Format("delete from mytable Where {0}", where.ToLower().Replace("update", "").Replace("delete", ""))

SqlConnection cn = new SqlConnection(this._ConnectionString)

SqlCommand cmd = new SqlCommand(sql, cn)

try

{

if (cn.State != ConnectionState.Open)

cn.Open()

return cmd.ExecuteNonQuery()

}

catch

{

return -1

}

finally

{

if (cn.State != ConnectionState.Closed)

cn.Close()

}

}

public DataTable Query(String where)

{

String sql = String.Format("select * from mytable Where {0}", where.ToLower().Replace("update", "").Replace("delete", "").Replace("insert", "").Replace("", "").Replace("--", "").Replace("exec", ""))

try

{

SqlDataAdapter da = new SqlDataAdapter(sql, new SqlConnection(this._ConnectionString))

DataTable dt = new DataTable()

da.Fill(dt)

return dt

}

catch

{

return null

}

}

}

4.在ui中调用：

4.1 新增：

private void NewData()

{

String conn=System.Configuration.ConfigurationManager.ConnectionStrings["dbCon"].ConnectionString

mytableDao dao=new mytableDao(conn)

mytable obj=new mytable()

obj.a=this.txtbox_a.Text

obj.b=this.txtbox_b.Text

obj.c=this.txtbox_c.Text

dao.New(obj)

}

4.2 取数据绑定GridView

private void LoadData_InitGridView()

{

String conn=System.Configuration.ConfigurationManager.ConnectionStrings["dbCon"].ConnectionString

mytableDao dao=new mytableDao(conn)

Table dt=dao.Query(String.Format(" a ='{0}'",this.txtbox_a.Text))

//gridview

this.GridView1.DataSource=dt

this.GridView1.DataBind()

//textbox control

this.textbox_a.Text=dt.Rows[0][0].ToString()

}

4.3删除

private void Del()

{

String conn=System.Configuration.ConfigurationManager.ConnectionStrings["dbCon"].ConnectionString

mytableDao dao=new mytableDao(conn)

//根据条件删除指定记录

dao.Del(where)

}

4.4更新

private void Update()

{

String conn=System.Configuration.ConfigurationManager.ConnectionStrings["dbCon"].ConnectionString

mytableDao dao=new mytableDao(conn)

dao.Update(obj)//obj 为mytable的一个实例：需要更新的

}

5.配置文件中连接信息

<connectionStrings>

<add name="dbCon" connectionString="Data Source=192.168.1.100Initial Catalog=NorthwindUser ID=saPassWord=sa" providerName="System.Data.SqlClient"/>

</connectionStrings>

6.读取连接信息

System.Configuration.ConfigurationManager.ConnectionStrings["dbCon"].ConnectionString

---