VS2005环境,本人菜鸟,请大侠给出详细代码。
ADD.ASPX.CS的代码: 总是提示数据库链接及下面两行少了分号!!!
using System;
using System.Data;
using System.Data.OleDb;
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 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ }
protected void Button1_Click(object sender, EventArgs e)
{
string muser=Request.Form(user);
string mpass=Request.Form(pass);
string myConn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=" & server.mappath("App_Data/free.mdb"));
string myInsertQuery=insertinto user (user,pass) values (&muser,&mpass);
string myOleDbCommand=New OleDbCommand(myInsertQuery);
myOleDbCommand.Connection = myConn;
myConn.Open();
myOleDbCommand.ExecuteNonQuery();
myOleDbCommand.Connection.Close();
Response.Write("成功");
}
}
ADD.ASPX.CS的代码: 总是提示数据库链接及下面两行少了分号!!!
using System;
using System.Data;
using System.Data.OleDb;
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 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ }
protected void Button1_Click(object sender, EventArgs e)
{
string muser=Request.Form(user);
string mpass=Request.Form(pass);
string myConn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=" & server.mappath("App_Data/free.mdb"));
string myInsertQuery=insertinto user (user,pass) values (&muser,&mpass);
string myOleDbCommand=New OleDbCommand(myInsertQuery);
myOleDbCommand.Connection = myConn;
myConn.Open();
myOleDbCommand.ExecuteNonQuery();
myOleDbCommand.Connection.Close();
Response.Write("成功");
}
}
解决方案 »
- HTML input file控件怎么控制文件选择对话框的过滤器?
- 子窗口向父窗口传值,父窗口如何让他刷新获得值
- VS2005中有关FLASH显示的问题
- 谁给我个ASP.NET用户自定义控件的源代码实例,或者发送到我的电子邮件 [email protected]
- 第一次发贴,大家讨论一下web标准和asp.net
- 框架中a.aspx怎么调用b.aspx中的函数?
- (20分)vs2005(C#)调试成功后,不再有错误对话框,可浏览器没有显示网页呀?
- 在asp.net中,如何不使用服务器控件(仅使用html控件)上传文件??
- 我装.NET的时候总是到最后3分钟或者最后1分钟时候出现死机状态!谁能帮帮我?
- .net 如何实例Repeater里面的fileupload
- 代码管理软件
- 求助:datagrid导出的excel文件出现乱码,vb.net,webform下.
====================
改为:
string myInsertQuery="insert into user (user,pass) values (muser,mpass)";
=======================
连接数据库不需要用户名和密码的?
string mpass = Convert.ToString(Request.Form["pass"]);
OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~/App_Data/free.mdb"));
string myInsertQuery = "insert into user (user,pass) values ('" + muser.Replace("'","''") + "','" + mpass.Replace("'","''") + "')";
OleDbCommand myOleDbCommand=new OleDbCommand(myInsertQuery);
myOleDbCommand.Connection = myConn;
myConn.Open();
myOleDbCommand.ExecuteNonQuery();
myConn.Close();
Response.Write("成功");
string myInsertQuery = "insert into user (user,pass) values ('" + muser.Replace("'","''") + "','" + mpass.Replace("'","''") + "')";我记得 user 是关键字,应该加[]的吧
string myInsertQuery = "insert into user ([user] , [pass]) values ('" + muser.Replace("'","''") + "','" + mpass.Replace("'","''") + "')";
就是这句错了string myInsertQuery=insertinto user (user,pass) values (&muser,&mpass);ls已经给出解决方法了
string mpass = Convert.ToString(Request.Form["pass"]);
OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~/App_Data/free.mdb"));
string myInsertQuery = "insert into [user] ([user],pass) values ('" + muser.Replace("'","''") + "','" + mpass.Replace("'","''") + "')";
OleDbCommand myOleDbCommand=new OleDbCommand(myInsertQuery, myConn);
myConn.Open();
myOleDbCommand.ExecuteNonQuery();
myConn.Close();
Response.Write("成功");楼主的错误不少
string mpass = Request.Form["pass"];
OleDbConnection myConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~/App_Data/free.mdb"));
string myInsertQuery = String.Format("insert into [user]([user],[pass]) values ('{0}', '{1}')", muser, mpass);
OleDbCommand myOleDbCommand = new OleDbCommand(myInsertQuery);
myOleDbCommand.Connection = myConn;
myConn.Open();
myOleDbCommand.ExecuteNonQuery();
myOleDbCommand.Connection.Close();
Response.Write("成功");