gridview连接数据库出错,求大神解决
时间:2011-12-28
来源:互联网
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)
急啊~~
作者: lplpooi 发布时间: 2011-12-28
看看你的连接参数是否有问题
作者: lsj_zrp 发布时间: 2011-12-28
conn.open()都没出错连接应该没有问题啊。
作者: lplpooi 发布时间: 2011-12-28
GridView1.DataSource = dt
作者: huijunliang 发布时间: 2011-12-28
GridView1.DataSource = dt
GridView1.DataBind();
GridView1.DataBind();
作者: fhpu168 发布时间: 2011-12-28
GridView1.DataSource = dt
GridView1.DataBind();
另外检查连接字符串,密码是否正确。
Server=localhost;Database=db_kc; Uid=root;Pwd=;
GridView1.DataBind();
另外检查连接字符串,密码是否正确。
Server=localhost;Database=db_kc; Uid=root;Pwd=;
作者: dalmeeme 发布时间: 2011-12-28
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28