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 !
Ïà¹ØÎÊ´ð£º
3¸öradioButton
Ò»¸öButton
Ò»¸ölabel
C# code:
protected void Button1_Click(object sender, EventArgs e)
{
string str = null;
RadioButton rdo=(RadioButton)sender;
......
±¾ÈËÊDzËÄñÒ»¸ö£¬Æ½Ê±Òª×öÉúÒ⣬µ«ÊÇÕÒÁ˺ܶàÈË×öÍøÕ¾£¬¾ù±»ÆÁË¡£×öµÃ²»Èý²»ËÄ£¬ÏÖÔÚ¾öÐÄ×Ô¼ºÀ´×öÒ»¸ö£¬ÒÑѧϰASP.NETÏà¹ØµÄÍøÒ³ÖÆ×÷֪ʶ£¬ÓÐDW»ù´¡£¬¿ÉÒÔ˵ÊÇĿǰֻÓÐÀíÂÛ֪ʶ£¬µ«ÊÇÔÚʵ¼Ê¾ßÌå²Ù×÷µÄʱºò£¬×ÜÊÇÓöµ ......
´úÂë: protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SqlDataSource1.SelectCommand = "SELECT * from [shang_pi ......