求vs2005下操作access数据库的asp.net的完整例子 原来用vs2003,现想用vs2005,发现2005下有很多和2003下写法不一样想求vs2005下使用access开发asp.net的资料,包括如何连接数据库,查询,添加,删除等操作最好是vb.net的.非常感谢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 唉,msdn自己看看,什么都有了 本来是想发点代码的。。可是楼主最后一句话vb.net 直接让我飘过了~ 想来想去还是给楼主发份ASP.NET C#代码吧,反正看个差不多就行了。下面是我以前做的一个例子//webconfig配置数据库连接 <appSettings> <add key="Ysn" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="/> <add key="dbPath" value="~/App_Data/zzt.mdb"/> </appSettings>//类中new数据库连接对象string dbname = string.Empty; OleDbConnection oc; OleDbTransaction ot; public ConnData() { dbname = System.Configuration.ConfigurationManager.AppSettings["Ysn"].ToString() + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dbPath"]) + ";"; oc = new OleDbConnection(dbname); } //修改密码 public new bool GetUpdatePwd(string pwd, string name) { int k = 0; this.OcOpen(); try { OleDbCommand cm = new OleDbCommand("update ZztUser set pwd=@pwd where name=@name", oc); cm.Parameters.Add("@pwd", pwd); cm.Parameters.Add("@name", name); k = cm.ExecuteNonQuery(); } catch { return false; } finally { this.OcClose(); } if (k > 0) return true; else return false; } //查询用户 public new UserBean GetSelUser(string name) { UserBean U = new UserBean(); this.OcOpen(); try { OleDbCommand cm = new OleDbCommand("select * from ZztUser where name=@name", oc); cm.Parameters.Add("@name", name); OleDbDataReader dr = cm.ExecuteReader(); if (dr.Read()) { U.Name = Convert.ToString(dr.GetValue(0)); U.Pwd = Convert.ToString(dr.GetValue(1)); } } catch { return null; } finally { this.OcClose(); } return U; } //添加客户留言 public new bool AddKhmsg(KhmsgBean kb) { int k = 0; this.OcOpen(); try { OleDbCommand cm = new OleDbCommand("INSERT INTO khmsg(name, gs, zw, sj, tel, cz, email, address, khmsg) VALUES (@name, @gs, @zw, @sz, @tel, @cz, @email,@address,@khmsg)", oc); cm.Parameters.Add("@name", kb.Name); cm.Parameters.Add("@gs", kb.Gs); cm.Parameters.Add("@zw", kb.Zw); cm.Parameters.Add("@sj", kb.Sj); cm.Parameters.Add("@tel", kb.Tel); cm.Parameters.Add("@cz", kb.Cz); cm.Parameters.Add("@email", kb.Email); cm.Parameters.Add("@address", kb.Address); cm.Parameters.Add("@khmsg", kb.Khmsg); k = cm.ExecuteNonQuery(); } catch(Exception ex) { return false; } finally { this.OcClose(); } if (k > 0) return true; return false; } //删除客户留言 public new bool DelKhmsg(int ID) { int k = 0; this.OcOpen(); try { OleDbCommand cm = new OleDbCommand("delete * from khmsg where id=@id", oc); cm.Parameters.Add("@id", ID); k = cm.ExecuteNonQuery(); this.OcClose(); } catch { return false; } finally { this.OcOpen(); } if (k > 0) return true; return false; } 问AJAX安装包 访问数据库问题! 发个今天遇到的奇怪问题 DataReader语句转换成Dataset datagrid的问题 [高分请教] Excel文件中单位编码列,按照第3 4位进行排序,如何进行…… 又一个datagrid的问题!! 改过超文本编辑器的大哥进来看看 急求一段sql语句:把bit的1、0返回成是、否。在线等,马上几结贴 DataGrid分页的问题? 如何用CHECKBOX实现多选 验证码问题..
下面是我以前做的一个例子//webconfig配置数据库连接
<appSettings>
<add key="Ysn" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="/>
<add key="dbPath" value="~/App_Data/zzt.mdb"/>
</appSettings>
//类中new数据库连接对象
string dbname = string.Empty;
OleDbConnection oc;
OleDbTransaction ot; public ConnData()
{
dbname = System.Configuration.ConfigurationManager.AppSettings["Ysn"].ToString() + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dbPath"]) + ";";
oc = new OleDbConnection(dbname);
} //修改密码
public new bool GetUpdatePwd(string pwd, string name)
{
int k = 0;
this.OcOpen();
try
{
OleDbCommand cm = new OleDbCommand("update ZztUser set pwd=@pwd where name=@name", oc);
cm.Parameters.Add("@pwd", pwd);
cm.Parameters.Add("@name", name);
k = cm.ExecuteNonQuery();
}
catch
{
return false;
}
finally { this.OcClose(); }
if (k > 0)
return true;
else
return false;
}
//查询用户
public new UserBean GetSelUser(string name)
{
UserBean U = new UserBean();
this.OcOpen();
try
{
OleDbCommand cm = new OleDbCommand("select * from ZztUser where name=@name", oc);
cm.Parameters.Add("@name", name);
OleDbDataReader dr = cm.ExecuteReader();
if (dr.Read())
{
U.Name = Convert.ToString(dr.GetValue(0));
U.Pwd = Convert.ToString(dr.GetValue(1));
}
}
catch
{
return null;
}
finally { this.OcClose(); }
return U;
}
//添加客户留言
public new bool AddKhmsg(KhmsgBean kb)
{
int k = 0;
this.OcOpen();
try
{
OleDbCommand cm = new OleDbCommand("INSERT INTO khmsg(name, gs, zw, sj, tel, cz, email, address, khmsg) VALUES (@name, @gs, @zw, @sz, @tel, @cz, @email,@address,@khmsg)", oc);
cm.Parameters.Add("@name", kb.Name);
cm.Parameters.Add("@gs", kb.Gs);
cm.Parameters.Add("@zw", kb.Zw);
cm.Parameters.Add("@sj", kb.Sj);
cm.Parameters.Add("@tel", kb.Tel);
cm.Parameters.Add("@cz", kb.Cz);
cm.Parameters.Add("@email", kb.Email);
cm.Parameters.Add("@address", kb.Address);
cm.Parameters.Add("@khmsg", kb.Khmsg);
k = cm.ExecuteNonQuery();
}
catch(Exception ex)
{
return false;
}
finally { this.OcClose(); }
if (k > 0)
return true;
return false;
}
//删除客户留言
public new bool DelKhmsg(int ID)
{
int k = 0;
this.OcOpen();
try
{
OleDbCommand cm = new OleDbCommand("delete * from khmsg where id=@id", oc);
cm.Parameters.Add("@id", ID);
k = cm.ExecuteNonQuery();
this.OcClose();
}
catch
{
return false;
}
finally { this.OcOpen(); }
if (k > 0)
return true;
return false;
}