protected void Button1_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(Request.QueryString["lookid"]);
OleDbConnection strConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(ConfigurationManager.AppSettings["DbPath"]));
string sql = "update a_mulu set a_neirong=@a_neirong where id=@id";
OleDbCommand cmd = new OleDbCommand(sql, strConn);
cmd.Parameters.Add("@a_neirong", OleDbType.Char, 666).Value = TextBox1.Text;
cmd.Parameters.Add("@id", OleDbType.Integer, 8).Value = id;
strConn.Open();
cmd.ExecuteNonQuery();
strConn.Close();
Response.Redirect("showmsg.aspx?msg=" + "留言回复成功。");
}数据库a_neirong 修改不了,大家帮忙啊 Access数据库
{
int id = Convert.ToInt32(Request.QueryString["lookid"]);
OleDbConnection strConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(ConfigurationManager.AppSettings["DbPath"]));
string sql = "update a_mulu set a_neirong=@a_neirong where id=@id";
OleDbCommand cmd = new OleDbCommand(sql, strConn);
cmd.Parameters.Add("@a_neirong", OleDbType.Char, 666).Value = TextBox1.Text;
cmd.Parameters.Add("@id", OleDbType.Integer, 8).Value = id;
strConn.Open();
cmd.ExecuteNonQuery();
strConn.Close();
Response.Redirect("showmsg.aspx?msg=" + "留言回复成功。");
}数据库a_neirong 修改不了,大家帮忙啊 Access数据库
解决方案 »
- 有朋友或高手知道怎么在网页上显示多页tif格式图片的吗?望解答!! 有详细代码最好提供下!!谢谢
- 关于编码转换的问题
- 在关闭子页面的同时怎么更新父页面的绑定数据啊?
- 请教一个短信收发的问题?短信高手请进
- 有关接口的问题
- 对程序集“D:\oss\nHibernate\src\NHibernate\obj\Debug\NHibernate.dll”签名时加密失败 --“读取密钥文件“..\NHibernate.snk”时出错
- 美观界面与界面刷新速度的矛盾,寻求您的建议?
- 关于修改web.config文件的问题(急用,在线等待!!)
- 如何注册net中的com组件-----送50分
- C#写的COM C++调用出错
- 一个asp.net的问题,请教高手
- icmp数据包 头部校验和的问题
string sql = "update a_mulu set a_neirong=? where id=?";
后面在AddParameter的时候按顺序添加并且不指定名称即可。
*****************************************************************************
欢迎使用CSDN论坛阅读器 : CSDN Reader(附全部源代码)
http://www.cnblogs.com/feiyun0112/archive/2006/09/20/509783.html
{
int id = Convert.ToInt32(Request.QueryString["lookid"]);
OleDbConnection strConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(ConfigurationManager.AppSettings["DbPath"]));
string sql = "update a_mulu set a_neirong=@a_neirong where id=@id";
OleDbCommand cmd = new OleDbCommand(sql, strConn);
cmd.Parameters.Add("@a_neirong", OleDbType.Char, 666).Value = "3123123";
cmd.Parameters.Add("@id", OleDbType.Integer, 8).Value = id;
strConn.Open();
cmd.ExecuteNonQuery();
strConn.Close();
Response.Redirect("showmsg.aspx?msg=" + "留言回复成功。");
}
这样的话 数据库里的a_neirong项=3123123 不知道怎么=TextBox1.Text里的内容!
{
}
{
TextBox1.Text="3123123";//试试
}
protected void Page_Load(object sender, EventArgs e)
{
int id = Convert.ToInt32(Request.QueryString["lookid"]);
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(ConfigurationManager.AppSettings["DbPath"]);
OleDbConnection conn = new OleDbConnection(strConn);
strSQL = "select * from a_mulu where id=lookid";
OleDbCommand cmd = new OleDbCommand(strSQL,conn);
conn.Open();
cmd.Parameters.Add("lookid", OleDbType.Integer, 8).Value = id;
OleDbDataReader dr = cmd.ExecuteReader(CommandBehavior.SingleRow);
dr.Read();
TextBox1.Text = dr["a_neirong"].ToString();
conn.Close();
dr.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(Request.QueryString["lookid"]);
OleDbConnection strConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(ConfigurationManager.AppSettings["DbPath"]));
string sql = "update a_mulu set a_neirong=w where id=xx";
OleDbCommand cmd = new OleDbCommand(sql, strConn);
cmd.Parameters.Add("w", OleDbType.Char, 666).Value = TextBox1.Text;
cmd.Parameters.Add("xx", OleDbType.Integer, 8).Value = id;
strConn.Open();
cmd.ExecuteNonQuery();
strConn.Close();
Response.Redirect("showmsg.aspx?msg=" + "留言回复成功。");
}
}
全部放出,大家解决一下
事件,然后再处理的Button1_Click(object sender, EventArgs e)事件。所以每次Button1 OnClick 时 TextBox1.Text 始终等于 dr["a_neirong"].ToString(),所以数据库中 a_neirong
列其实是更新的,只是更新的值是相同的。代码应改为:String strConn=null;
String strSQL=null;
protected void Page_Load(object sender, EventArgs e)
{
int id = Convert.ToInt32(Request.QueryString["lookid"]);
if(!PostBack)
{
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(ConfigurationManager.AppSettings["DbPath"]);
OleDbConnection conn = new OleDbConnection(strConn);
strSQL = "select * from a_mulu where id=@lookid";
OleDbCommand cmd = new OleDbCommand(strSQL,conn);
conn.Open();
cmd.Parameters.Add("@lookid", OleDbType.Integer, 8).Value = id;
OleDbDataReader dr = cmd.ExecuteReader(CommandBehavior.SingleRow);
dr.Read();
TextBox1.Text = dr["a_neirong"].ToString();
dr.Close();
conn.Close();
}
}