asp.net + mysql 报错问题
报错: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是存储过程名字
存储过程:
SQL code:
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;
}
????有人会吗?
给我说说呗
我的神啊!!!!
我急用啊 就是 老出错 给我说说呗 谢谢大家le !
相关问答:
select top 12 * from Product where [id] not in (select top 12 [id] from Product)
这样可以分页,但是我在后面想加个条件
select top 12 * from Product where [id] not in (select top 12 [id] from Prod ......
function CheckOpwd(){//验证用户名
var pwd=document.all.txtOpwd;
var div1=document.getElementById("divPwd");
if (pwd.value=="")
{
......
3个radioButton
一个Button
一个label
C# code:
protected void Button1_Click(object sender, EventArgs e)
{
string str = null;
RadioButton rdo=(RadioButton)sender;
......
例如我有一件事。今天完成百分之20,就用一个圆形,分两部分,一部分弧区(一种颜色)是显示以完成部分,另一部分用另一种颜色显示,表示为完成部分,并把数字写在上面,这样的话,怎么实现,有没有什么实例。或者要 ......