这里有现成的代码
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 );//搬运数据,