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 !
Ïà¹ØÎÊ´ð£º
function CheckOpwd(){//ÑéÖ¤Óû§Ãû
var pwd=document.all.txtOpwd;
var div1=document.getElementById("divPwd");
if (pwd.value=="")
{
......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
ÎÒÏëʵÏÖÒ»¸öЧ¹ûÊÇ£ºÄܰÑÒ³Ãæ·Ö³É¼¸¸ö´ó¿é£¬µãÏ´ó¿éÉϵÄ+±ãÕ¹¿ª£¬µãÏÂ-±ãÕÛµþ¡£
Õâ¸öÓÐʲô¿Ø¼þ¿ÉÒÔÓò»£¬Çë¸ßÊÖ²»Áߴͽ̣¡
ÓÃjs´úÂëÀ´ ¿ØÖÆ divµÄ¶¯×÷´Ó¶øÄÜʵÏÖ
js¿ØÖÆdivÏÔʾ/Òþ²ØÁË
VS2008×Ô´ø·â×°Á ......
ÎÒ×öÁ˸öµÇÂ¼Ò³Ãæ(ûģ°åµÄ),¿ÉÒԳɹ¦
µ«ÎÒ¼ÓÉÏĸ°åºó,¾ÍÔõôҲµÇ¼²»³É¹¦ÁË,ÇëÎÊÊÇÄÄÀï³öÎÊÌâÁË?
Ö÷Òª´úÂëÌùÒ»ÏÂ.........
µÇ¼²»ÉÏ£¬»¹ÊÇÒ³Ãæ³ö´í£¿
³ö´íµÄ»°ÌùÉϳö´íÐÅÏ¢
»¹ÓдúÂë
ÎÒÊÇÕâÑùµÄ
°ÑµÇ ......
´úÂë: protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SqlDataSource1.SelectCommand = "SELECT * from [shang_pi ......