如何使用sqldatareader加载gridview [英] how to load gridview using sqldatareader

问题描述

dbCommand = new SqlCommand("SELECT Game.GameId,Location,Date,Time FROM Game,Results WHERE Game.GameId = Results.GameId AND CountryId ='" + cboCountryName.SelectedValue + "'", dbConnection);

            if (dbConnection.State = ConnectionState.Closed)
            {
                dbConnection.Open();
            }
            dbread = dbCommand.ExecuteReader();
            while (dbread.Read())
            {
              
            }

推荐答案

嗨！

不要使用循环来遍历SqlDataReader ...

你应该创建一个 DataTable

您通过数据读取器填充它并将表绑定到网格

Hi!
Don't use loop to iterate through SqlDataReader...
You should create a DataTable
You fill it though data reader and bind your table to grid

 DataTable table = new DataTable();

 table.Load( dbCommand.ExecuteReader());

dataGrid.DataSource = table;

con.Open(); 
SqlDataReader reader = cmd.ExecuteReader();
GridView1.DataSource = reader;
GridView1.DataBind();
reader.Close();
con.Close();

SqlConnection obj_Conn = new SqlConnection();
            obj_Conn.ConnectionString = strConn;

            obj_Conn.Open();
            SqlCommand obj_Cmd = new SqlCommand(strCmd, obj_Conn);
            SqlDataReader obj_Reader = obj_Cmd.ExecuteReader();

            DataTable dt = new DataTable();
            dt.Columns.Add("Id");
            dt.Columns.Add("FName");
            dt.Columns.Add("LName");

         
            while (obj_Reader.Read())
            {
                DataRow row = dt.NewRow();
                row["Id"] = obj_Reader["Id"];
                row["FName"] = obj_Reader["FName"];
                row["LName"] = obj_Reader["LName"];
                dt.Rows.Add(row);
            }
            dataGridView1.DataSource = dt;

这篇关于如何使用sqldatareader加载gridview的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！