using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MySql.Data.MySqlClient;namespace WebApplication1
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MySqlConnection cn = new MySqlConnection(@"server=.;uid=root;pwd=sasasa;database=test");
MySqlCommand cmd = new MySqlCommand(@"select * from Demo;", cn);
try
{ cn.Open();
grdData.DataSource = cmd.ExecuteReader(CommandBehavior.CloseConnection);
grdData.DataBind();
}
catch (MySqlException er)
{
Response.Write(er.Message);
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close();
}
}
}
}
}
}
我啥都搞过了,但是就是不对,总是有错误,请各位指点啊,谢谢!
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MySql.Data.MySqlClient;namespace WebApplication1
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MySqlConnection cn = new MySqlConnection(@"server=.;uid=root;pwd=sasasa;database=test");
MySqlCommand cmd = new MySqlCommand(@"select * from Demo;", cn);
try
{ cn.Open();
grdData.DataSource = cmd.ExecuteReader(CommandBehavior.CloseConnection);
grdData.DataBind();
}
catch (MySqlException er)
{
Response.Write(er.Message);
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close();
}
}
}
}
}
}
我啥都搞过了,但是就是不对,总是有错误,请各位指点啊,谢谢!
你要在打开数据库之前先在CMD(MySqlCommand)指定连接为cn(MySqlConnection)
cmd.Connection=cn
然后再open
再ExecuteReader没有指定哪个连接是没办法执行语句的.
MySqlCommand cmd = new MySqlCommand(@"select * from Demo;", cn);
你这里的“@”是什么意思 我从来没这么用过mysql 中不用这个的~~~~
还有mysql中server=localhost;这样的格式 怎么会是点呢那是MSSQL啊~~~