读书人

报错:You have an error in your SQL

发布时间: 2012-03-15 11:50:39 作者: rapoo

报错:You have an error in your SQL syntax; check the manual .....
报错:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'xx' at line 1
xx是存储过程名字
存储过程
create procedure xx
begin
select bb from test;
end;

C# 业务层:
public DataSet testa()
{
DataBase db = new DataBase();
return db.GetDataSet("xx");
}
数据层:
public DataSet GetDataSet(String ProcName)
{
Open();
MySqlDataAdapter adapter = new MySqlDataAdapter(ProcName, conn);
DataSet ds = new DataSet();
adapter.Fill(ds);
Close();
return ds;
}

各位帮帮我啊 急用啊

[解决办法]
create procedure xx
AS
begin
select bb from test;
end;
[解决办法]
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
你不指定,谁知道是存储过程啊?

读书人网 >.NET

热点推荐