using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using MySql.Data.MySqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
String CONN = "User Id=root;Host=localhost;Database=db_kc;password=12";
MySqlConnection conn = new MySqlConnection(CONN);
conn.Open();
MySqlDataAdapter sda = new MySqlDataAdapter("select * from cp", conn);
DataSet ds = new DataSet();
sda.Fill(ds, "cp");
DataTable dt = ds.Tables["cp"];
GridView1.DataKeyNames = new string[] { "id" };
GridView1.DataBind();
}
}最后的gridview1.databind()出错。Access denied for user 'root'@'localhost' (using password: NO)急啊~~
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using MySql.Data.MySqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
String CONN = "User Id=root;Host=localhost;Database=db_kc;password=12";
MySqlConnection conn = new MySqlConnection(CONN);
conn.Open();
MySqlDataAdapter sda = new MySqlDataAdapter("select * from cp", conn);
DataSet ds = new DataSet();
sda.Fill(ds, "cp");
DataTable dt = ds.Tables["cp"];
GridView1.DataKeyNames = new string[] { "id" };
GridView1.DataBind();
}
}最后的gridview1.databind()出错。Access denied for user 'root'@'localhost' (using password: NO)急啊~~
GridView1.DataBind();
GridView1.DataBind();另外检查连接字符串,密码是否正确。
Server=localhost;Database=db_kc; Uid=root;Pwd=;