asp.net怎么和Access数据库链接(具体代码)

来源:百度知道 编辑:UC知道 时间:2024/06/23 22:20:50
要实现登陆注册功能!!!
Asp.net中如何以不同的身份登录到不同的界面的代码!~!~!

这是一个登陆功能!!看一下注册也应该会吧!!!

bool UserLogin(UserInfo userInfo, out ErrorMsg errMsg)
{
errMsg = ErrorMsg.None; ;
string strConnection = string.Format("Provider=Microsoft.Jet.OleDb.4.0;Data Source={0}", Server.MapPath("~/App_Data/Database12.mdb"));
using (OleDbConnection objConnection = new OleDbConnection(strConnection))
{
objConnection.Open();
using (OleDbCommand cmd = objConnection.CreateCommand())
{
OleDbParameter pUserName = new OleDbParameter("@UserName", userInfo.UserName);
string sqlstr = "SELECT [ID], [UserName], [PassWord] FROM [UserInfo] WHERE ([UserName] = @UserName)";
cmd.CommandText = sqlstr;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(pUserName);
using (OleDbDataReader reader = cm