DataGrid

Question

Mark!友情UP

Answer 1

SqlConnection sqlConn = new SqlConnection();
sqlConn.ConnectionString = "Server   =   Fiona;Database   =   Fiona;   integrated   security=SSPI"; SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = sqlConn;
sqlCmd.CommandText = @"select   *   from   stu";
SqlDataAdapter sqlApt = new SqlDataAdapter();
sqlApt.SelectCommand = sqlCmd; DataSet ds = new DataSet();
sqlApt.Fill(ds);

Answer 2

objDataSet  实例化了没？

Answer 3

给你一个函数吧，返回记录集的，  public static DataSet dataToGridView(string strSql)
            {
                /// <summary> 
                /// 读取数据库表 
                /// </summary> 
                /// <param name="Path">文件名称</param> 
                /// <returns>返回一个数据集</returns>                 OleDbConnection conn = new OleDbConnection();
                conn.ConnectionString = connStrto;
                conn.Open();
                OleDbDataAdapter myCommand = null;
                DataSet ds = null;
                myCommand = new OleDbDataAdapter(strSql, connStrto);
                ds = new DataSet();
                myCommand.Fill(ds);
                conn.Close();
                return ds;
            }