UC知道FROM子语句错误？
来源：百度知道 编辑：UC知道 时间：2024/05/13 03:43:14
string xx_id,user_name,conn;
xx_id = "1";
conn = ConfigurationManager.ConnectionStrings["connzxg"].ConnectionString;
OleDbConnection bz_connection = new OleDbConnection(conn);
OleDbDataAdapter bz_adapter = new OleDbDataAdapter("select * from xiang_bz where xiang_bz_cid="+xx_id,bz_connection);
DataSet bz_dataset = new DataSet();
bz_adapter.Fill(bz_dataset, "xiang_bz");
user_name=bz_dataset.Tables[0].Rows[0]["xiang_bz_user"].ToString();
OleDbDataAdapter user_adapter = new OleDbDataAdapter("select * from user where user_name='" +user_name+"'", bz_connection);
user_adapter.Fill(bz_dataset,"user");
Repeater1.DataSource = bz_dataset.Tables[0];
Repeater1.DataBind();
}
==================================
请问哪里出了问题呢 我运行就提示FROM 子语法错误？
xx_id = "1";
conn = ConfigurationManager.ConnectionStrings["connzxg"].ConnectionString;
OleDbConnection bz_connection = new OleDbConnection(conn);
OleDbDataAdapter bz_adapter = new OleDbDataAdapter("select * from xiang_bz where xiang_bz_cid="+xx_id,bz_connection);
DataSet bz_dataset = new DataSet();
bz_adapter.Fill(bz_dataset, "xiang_bz");
user_name=bz_dataset.Tables[0].Rows[0]["xiang_bz_user"].ToString();
OleDbDataAdapter user_adapter = new OleDbDataAdapter("select * from user where user_name='" +user_name+"'", bz_connection);
user_adapter.Fill(bz_dataset,"user");
Repeater1.DataSource = bz_dataset.Tables[0];
Repeater1.DataBind();
}
==================================
请问哪里出了问题呢 我运行就提示FROM 子语法错误？
OleDbDataAdapter bz_adapter = new OleDbDataAdapter("select * from xiang_bz where xiang_bz_cid="+xx_id,bz_connection);
这句，你的xx_id是string类型，应该先转换成int类型。
int xx_idint = Convert.ToInt32(xx_id);
把这句放前面，然后把上面改成：
OleDbDataAdapter bz_adapter = new OleDbDataAdapter("select * from xiang_bz where xiang_bz_cid="+xx_idint ,bz_connection);
试试。