从datareader填充gridview [英] fill gridview from datareader

问题描述

大家好，



我开发了一个桌面应用程序，我想生成一个SqlDataReader来填充gridview。



是类

Hello guys,

I developed a desktop application and I want to generate a SqlDataReader to fill the gridview.

the is class

class operation{
SqlConnection con = new SqlConnection(Connection.connectionString);
        SqlCommand com = new SqlCommand();
public SqlDataReader rd;

        public SqlDataReader getdata(string query)
        {
            com.CommandText = query;
            com.Connection = con;
            con.Open();
            rd = com.ExecuteReader();

            con.Close();
            return rd;      
        }
}

和生成按钮

and the button to generate

 private void button2_Click(object sender, EventArgs e)
{
           oper.getdata("Select * From Customers");
           rd = oper.rd;
           if (rd.HasRows)
           {
               while (rd.Read())
               {

               }
           }
           con.Close();
       }

我有很多错误。我希望能找到答案。



非常感谢！

I have a lot of errors. I hope to find the answer.

Thanks a lot!

推荐答案

Hi
Please试试这个

Hi Please try this

protected void button2_Click(object sender, EventArgs e)
  {
  SqlDataReader sqlDataReader = GetData(query, conString);//conString is Connection String
  }

和'GetData'方法如下

And 'GetData' method is as below

public SqlDataReader GetData(string queryString, string connectionString)
    {

        SqlConnection connection = new SqlConnection(connectionString);
            connection.Open();
            SqlCommand command = new SqlCommand(queryString, connection);
            SqlDataReader reader = command.ExecuteReader();
            SqlDataReader sqlDataReader = reader;
            DataTable dataTable = new DataTable();
            dataTable.Columns.Add("Customer Id");
            dataTable.Columns.Add("Customer Name");
            while (sqlDataReader.Read())
            {
                DataRow row = dataTable.NewRow();
                row["Customer Id"] = sqlDataReader["CustomerId"];
                row["Customer Name"] = sqlDataReader["CustomerName"];
                dataTable.Rows.Add(row);
            }
            GridView1.DataSource = dataTable;
            GridView1.DataBind();
            connection.Close();
        return reader;  
    }

希望它会有所帮助。尝试后将问题标记为已解决。

-

谢谢

Hope it will helpful. Mark question as solved after trying.
--
Thanks

SqlDataReader对象允许您以快进方式读取数据方式。调用SqlDataReader的Close方法以确保没有任何资源泄漏。

SqlDataReader objects allow you to read data in a fast forward-only manner. Call the Close method of the SqlDataReader to ensure there are not any resource leaks.

private void BindGrid()
{
    string strConnString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(strConnString))
    {
        using (SqlCommand cmd = new SqlCommand())
        {
            cmd.CommandText = "select * from Customers";
            cmd.Connection = con;
            con.Open();
            DataGridView1.DataSource = cmd.ExecuteReader(); 
            con.Close();
        }
    }
}

这篇关于从datareader填充gridview的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！