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 !
Ïà¹ØÎÊ´ð£º
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽÎļþ
<folder state="unchecked" label="È«²¿">
¡¡¡¡<folder state="unchecked" isBra ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
±¾ÈËÊDzËÄñÒ»¸ö£¬Æ½Ê±Òª×öÉúÒ⣬µ«ÊÇÕÒÁ˺ܶàÈË×öÍøÕ¾£¬¾ù±»ÆÁË¡£×öµÃ²»Èý²»ËÄ£¬ÏÖÔÚ¾öÐÄ×Ô¼ºÀ´×öÒ»¸ö£¬ÒÑѧϰASP.NETÏà¹ØµÄÍøÒ³ÖÆ×÷֪ʶ£¬ÓÐDW»ù´¡£¬¿ÉÒÔ˵ÊÇĿǰֻÓÐÀíÂÛ֪ʶ£¬µ«ÊÇÔÚʵ¼Ê¾ßÌå²Ù×÷µÄʱºò£¬×ÜÊÇÓöµ ......