datagridview不显示数据库表中的数据

[fanxiaoye1]

代码如下，如何解决呢。。。
private void Showdata()
{
SqlConnection myconn = new SqlConnection(constr);
mycon = new SqlConnection(constr);
string mysql = "select * from 用户信息表";
SqlDataAdapter myada = new SqlDataAdapter(mysql, mycon);
mytable = new DataTable();
myada.Fill(mytable);
dataGridView1.DataSource = mytable.DefaultView;
mycon.Close();


private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
pstr = mytable.Rows[e.RowIndex][0].ToString();
textBox1.Text = mytable.Rows[e.RowIndex][1].ToString();
textBox2.Text = mytable.Rows[e.RowIndex][2].ToString();

}

[fanxiaoye1]

好急呀。。初学者

[Struggle_hardllz]

你这样写明显不对，获取数据库中的表，代码中还要写个类， 下面是我写过的参考: string sql = "select id,Name,Sex_Tag,Birth,UserID from ElderTable where UserID='" + user_LoginID + "'"; DataTable dt = ado.SelectDataTable(sql); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { try { older o = new older(); o.Name = dt.Rows[i]["Name"].ToString(); o.Sex_Tag = Convert.ToInt32(dt.Rows[i]["Sex_Tag"]); o.Birth = DateTime.Parse(dt.Rows[i]["Birth"].ToString()).ToShortDateString(); o.ID = Convert.ToInt32(dt.Rows[i]["id"]); o.id = i + 1; listO.Add(o); }

[大鱼>]

你先看看你的mytable里面是不是有数据。