用OleDb和数据库连接,然后把操作传回数据库,Page_Load正确,Button2_Click有错误,请帮忙看一下问题出在哪里,先谢过了~~
private string id = "2";
protected void Page_Load(object sender, EventArgs e)
{
OleDbConnection s = new OleDbConnection("provider=vfpoledb.1;Data Source=D:/Vfp98/我的东西/asp2.dbc;collating sequence=machine;");
OleDbCommand cmd = new OleDbCommand("select item from 表1 where id="+this.id, s);
cmd.Connection.Open();
string i = Convert.ToString(cmd.ExecuteScalar());
this.Label1.Text = i;
OleDbCommand cmd1 = new OleDbCommand("select xyid,nr from 表2 where id=" + this.id, s);

OleDbDataReader a = cmd1.ExecuteReader();
this.RadioButtonList1.DataTextField = "nr";
this.RadioButtonList1.DataValueField = "xyid";
this.RadioButtonList1.DataSource = a;
this.RadioButtonList1.DataBind();
a.Close();
s.Close();

}

protected void Button2_Click(object sender, EventArgs e)
{
OleDbConnection m= new OleDbConnection("provider=vfpoledb.1;Data Source=D:/Vfp98/我的东西/asp2.dbc;collating sequence=machine;");
OleDbCommand n = new OleDbCommand();
n.Connection = m;
n.Connection.Open();
n.CommandText = "update 表2 set xx=xx+1 where id="+id+"and xyid=" +this.RadioButtonList1.SelectedValue.ToString();
n.ExecuteNonQuery();
m.Close();
运行后用户代码未处理框提示"Missing operand."出错的位置是 n.ExecuteNonQuery();请教~~

n.CommandText = "update 表2 set xx=xx+1 where id="+id+"　and xyid=" +this.RadioButtonList1.SelectedValue.ToString();

and 前面还有个空格。

[此贴子已经被作者于2006-12-5 20:23:06编辑过]

上面的问题解决了,不过又提示"Command contains unrecognized phrase/keyword."出错的位置还是n.ExecuteNonQuery();请版主指教

哪位帮忙解决问题啊~~~

这个问题很困难么?这么久了也没解决的了,郁闷中!!!

再次明确问题
protected void Button2_Click(object sender, EventArgs e)
{
OleDbConnection m= new OleDbConnection("provider=vfpoledb.1;Data Source=D: fp98/我的东西/asp2.dbc;collating sequence=machine;");
OleDbCommand n = new OleDbCommand();
n.Connection = m;
n.Connection.Open();
n.CommandText = "update 表2 set xx=xx+1 where id="+id+" and xyid=" +this.RadioButtonList1.SelectedValue.ToString();
n.ExecuteNonQuery();
m.Close();
运行后用户代码未处理框提示"Missing operand.",出错的位置是 n.ExecuteNonQuery();请教~~

经过反复的调试现在的问题简化为:
OleDbConnection m= new OleDbConnection("provider=vfpoledb.1;Data Source=D:/Vfp98/我的东西/asp2.dbc;");
m.Open();
OleDbCommand n = new OleDbCommand("update 表2 set xx=xx+1 ",m );

n.ExecuteNonQuery();

m.Close();
如果是这样,就可以执行,但是运行结果是把表2中所有记录的xx都加了1,我的想法是只有xyid被选中的记录的xx才加1.这样说的够明白了哈,我知道应该在xx=xx+1后面加where语句,但是这个语句怎么写?怎么判断某一记录的xyid是否被选中?

xyid?
xyid是数据库字段：update 表2 set xx=xx+1 where xyid=1
如果是checkboxlist 判断那个ckeckbox被选择，然后在where 写上去

[CODE]int xy_id = 0;
try
{
xy_id = int.Prase(this.RadioButtonList1.SelectedValue.ToString());
}
catch
{
Response.Write("<Script>alert('错误，请稍后再试！');</script>");
return;
}
n.CommandText = "update 表2 set xx=xx+1 where id="+id+" and xyid=" + xy_id;
[/CODE]

belin2000你的意思我不是很懂,而且是RadioButtonList,不是checkboxlist

版主大人,我不明白那个try和catch的作用,不过把你的程序抄下来了,结果一运行就是catch里的"错误，请稍后再试！"
是怎么回事?