用DATALIST绑定的数据库中的用户 TextBox txtName=(TextBox)DataList1.Items[e.Item.ItemIndex].FindControl("namebox"); 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 多谢了!!顺便还问哈,那修改用户呢???下面的程序好几个错误了,不知道怎么改OleDbCommand mycommand = new OleDbCommand(); string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + Server.MapPath("db1.mdb"); OleDbConnection conn = new OleDbConnection(ConnectionString); string strcmd; conn.Open(); try { mycommand.Connection = conn; strcmd = "update tab1 set user_name=?,user_psd=? where username=?"; mycommand.CommandText = strcmd; mycommand.Parameters.Add(new OleDbParameter("@user_name", OleDbType.VarChar, 50, "user_name")); mycommand.Parameters.Add(new OleDbParameter("@user_psd", OleDbType.VarChar, 20, "user_psd")); mycommand.Parameters("@user_name").Value = ToString(e.Item.Findcontrol("user_name"), TextBox).text; mycommand.Parameters("@user_psd").Value = ToString(e.Item.Findcontrol("user_psd"), TextBox).text; mycommand.ExecuteNonQuery(); DataList1.EditItemIndex = -1; bindtodatalist(); } OleDbCommand mycommand = new OleDbCommand(); string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + Server.MapPath("db1.mdb"); OleDbConnection conn = new OleDbConnection(ConnectionString); string strcmd; conn.Open(); try { mycommand.Connection = conn; strcmd = "update tab1 set user_psd=? where username=?"; mycommand.CommandText = strcmd; mycommand.Parameters.Add(new OleDbParameter("?", OleDbType.VarChar, 20)).Value = ((TextBox)e.Item.Findcontrol("user_psd")).Text; mycommand.Parameters.Add(new OleDbParameter("?", OleDbType.VarChar, 50)).Value = ((TextBox)e.Item.Findcontrol("user_name")).Text; conn.Open(); mycommand.ExecuteNonQuery(); conn.Close(); DataList1.EditItemIndex = -1; bindtodatalist(); } 我用的2.0版本.运行还是有问题,错误提示"Datalistitem不包含Findcontrol的定义"???? ExecuteScalar 要求已打开且可用的连接。连接的当前状态为已关闭。 asp.net有类似window.open()方法吗? 在问一下? 弹出窗口传值,这个脚本怎么编阿? 新手请教,时间控件 讨论:数据连接是操作完成后关闭还是总是打开好? 导出excel 求助 新革命遇到老问题,100分求解用程序实现 文件权限设置!!!解决在加100~~ 自动套用格式为什么没起作样? 思归 大哥帮忙看看萨。。--用ASP.NET上传大文件(进度条)得疑惑 批 sqlserver 2000 三种分页方案 砸蛋中奖游戏思路``高人进来指点`顶者散分
OleDbCommand mycommand = new OleDbCommand();
string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + Server.MapPath("db1.mdb");
OleDbConnection conn = new OleDbConnection(ConnectionString);
string strcmd;
conn.Open();
try
{
mycommand.Connection = conn;
strcmd = "update tab1 set user_name=?,user_psd=? where username=?";
mycommand.CommandText = strcmd;
mycommand.Parameters.Add(new OleDbParameter("@user_name", OleDbType.VarChar, 50, "user_name"));
mycommand.Parameters.Add(new OleDbParameter("@user_psd", OleDbType.VarChar, 20, "user_psd"));
mycommand.Parameters("@user_name").Value = ToString(e.Item.Findcontrol("user_name"), TextBox).text;
mycommand.Parameters("@user_psd").Value = ToString(e.Item.Findcontrol("user_psd"), TextBox).text;
mycommand.ExecuteNonQuery();
DataList1.EditItemIndex = -1;
bindtodatalist();
}
string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + Server.MapPath("db1.mdb");
OleDbConnection conn = new OleDbConnection(ConnectionString);
string strcmd;
conn.Open();
try
{
mycommand.Connection = conn;
strcmd = "update tab1 set user_psd=? where username=?";
mycommand.CommandText = strcmd;
mycommand.Parameters.Add(new OleDbParameter("?", OleDbType.VarChar, 20)).Value = ((TextBox)e.Item.Findcontrol("user_psd")).Text;
mycommand.Parameters.Add(new OleDbParameter("?", OleDbType.VarChar, 50)).Value = ((TextBox)e.Item.Findcontrol("user_name")).Text;
conn.Open();
mycommand.ExecuteNonQuery();
conn.Close();
DataList1.EditItemIndex = -1;
bindtodatalist();
}