110,567
社区成员
发帖
与我相关
我的任务
分享
try
{
MySQLConnection con = new MySQLConnection("Password=zxc123123110;User ID=root;Location=localhost;Data Source=user");
con.Open();
DataSet ds = new DataSet();
MySQLDataAdapter adp = new MySQLDataAdapter("select * from user", con);
adp.Fill(ds);
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
StringBuilder sb = new StringBuilder();
// 设置字段名
for (int i = 0; i < ds.Tables[0].Columns.Count; ++i)
{
sb.Append(ds.Tables[0].Columns[i].ColumnName +"\t");
}
sb.Append("\r\n");
// 打印数据行
for (int i = 0; i < ds.Tables[0].Rows.Count; ++i)
{
for (int j = 0; j < ds.Tables[0].Rows.Count; ++j)
{
sb.Append(ds.Tables[0].Rows[i][j].ToString() + "\t");
}
sb.Append("\r\n");
}
lable1.Text = sb.ToString();