这里有现成的代码
DBhelper.conString.Open();//打开数据库连接
string sql = "SELECT Id, FlightNO, LeaveCity, Destination, LeaveTime FROM TicketInfo";//要填充的数据的SQL语句
DataSet set = new DataSet("par");//临时存储数据的仓库
SqlDataAdapter ter = new SqlDataAdapter(sql,DBhelper.conString );//搬运数据,
ter.Fill(set,"TicketInfo");//把指定的数据放到dataadapter
dataGridView1.DataSource=set.Tables [0];//填充到DataGridview
DBhelper.conString.Close();
你是否把数据源绑定正确...或者是你的datagridview的字段和数据库的字段不对应..也会导致不能绑定数据,,最好还是调试跟踪下吧
SqlConnection cn = new SqlConnection("server = .; database = advnet;uid = sa;pwd = sa");
string sql = "select * from Champions";
SqlDataAdapter da = new SqlDataAdapter(sql, cn);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
可以借鉴一下这个代码