C#查询数据库所有表名,并显示到ListView
我的代码如下:publicstringdbAdd,dbName,dbUser,dbPwd,dbSql,connectionString,DbNameStr;publicv...
我的代码如下:
public string dbAdd, dbName, dbUser, dbPwd, dbSql, connectionString,DbNameStr;
public void btn_Set_Click(object sender, EventArgs e)
{
dbAdd = "localhost";
dbName = "test";
dbUser = "root";
dbPwd = "123";
connectionString = "User Id=" + dbUser + ";Host=" + dbAdd + ";Database=" + dbName + ";password=" + dbPwd + ";Allow Zero Datetime=true";
MySqlConnection myConn = new MySqlConnection(connectionString);
myConn.Open();
DbNameStr = "select name from test where xtype='u'";
MySqlDataAdapter DbNameAdp = new MySqlDataAdapter(DbNameStr, myConn);
MySqlCommandBuilder DbNameCbd = new MySqlCommandBuilder(DbNameAdp);
DataSet DbNameDs = new DataSet();
for (int i = 0; i < DbNameDs.Tables[0].Rows.Count; i++)
{
ListView Lv = new ListView();
Lv.Text = DbNameDs.Tables[0].Rows[i]["name"].ToString();
LV_Tables.Items.Add(Lv.Text);
}
}
运行好像提示没有找到表。
这个代码怎么修改啊? 展开
public string dbAdd, dbName, dbUser, dbPwd, dbSql, connectionString,DbNameStr;
public void btn_Set_Click(object sender, EventArgs e)
{
dbAdd = "localhost";
dbName = "test";
dbUser = "root";
dbPwd = "123";
connectionString = "User Id=" + dbUser + ";Host=" + dbAdd + ";Database=" + dbName + ";password=" + dbPwd + ";Allow Zero Datetime=true";
MySqlConnection myConn = new MySqlConnection(connectionString);
myConn.Open();
DbNameStr = "select name from test where xtype='u'";
MySqlDataAdapter DbNameAdp = new MySqlDataAdapter(DbNameStr, myConn);
MySqlCommandBuilder DbNameCbd = new MySqlCommandBuilder(DbNameAdp);
DataSet DbNameDs = new DataSet();
for (int i = 0; i < DbNameDs.Tables[0].Rows.Count; i++)
{
ListView Lv = new ListView();
Lv.Text = DbNameDs.Tables[0].Rows[i]["name"].ToString();
LV_Tables.Items.Add(Lv.Text);
}
}
运行好像提示没有找到表。
这个代码怎么修改啊? 展开
展开全部
你的DataSet数据集只是分配到了空间,但是并没有通过适配器为其填充数据。
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
DataSet DbNameDs = new DataSet();
后面将数据适配器引入
后面将数据适配器引入
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
你好,你的问题出在与数据库链接的问题上,你仔细找找,应该不算难!
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询