
c# 的连接mysql执行一个存储过程 返回这个结果集 但是报错哦,大神们给看看什么情况 20
报错为can'treturnaresultsetinthegivencontext说语句没有返回一个结果集语句如下:MySQLConnectionconn=null;co...
报错为can't return a result set in the given context 说语句没有返回一个结果集 语句如下:
MySQLConnection conn = null;
conn = new MySQLConnection(new MySQLConnectionString( "localhost", "testpamp", "root", "000").AsString);
string sql = string.Format("call temp_memcard('%{0}%')", into);
try
{
conn.Open();
MySQLDataAdapter mda = new MySQLDataAdapter(sql, conn);
ds = new DataSet();
mda.Fill(ds, "table1"); //到这一步就报这个错误 错
GridView1.DataSource = ds.Tables["table1"];
GridView1.DataBind();
}
finally
{
conn.Close();
} 展开
MySQLConnection conn = null;
conn = new MySQLConnection(new MySQLConnectionString( "localhost", "testpamp", "root", "000").AsString);
string sql = string.Format("call temp_memcard('%{0}%')", into);
try
{
conn.Open();
MySQLDataAdapter mda = new MySQLDataAdapter(sql, conn);
ds = new DataSet();
mda.Fill(ds, "table1"); //到这一步就报这个错误 错
GridView1.DataSource = ds.Tables["table1"];
GridView1.DataBind();
}
finally
{
conn.Close();
} 展开
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询