Binding a DataReader in a GridView in WinForm

Hi mehdi_csharp,

conn.Open();
SqlCommand cmd= new SqlCommand("<your sql="" command="">", conn);
SqlDataReader dr = cmd.ExecuteReader();
Gridview1.DataSource = dr;
Gridview1.DataBind();
conn.Close();
</your>

I hope this help,
:)

I pesonally wouldn't use a DataReader to bind to a GridView. I would use the reader to populate a DataTable and then bind the GridView to the DataTable Something like this

SqlConnection con = new SqlConnection("Your Connection String Here");
            con.Open();
            SqlCommand cmdQuery = new SqlCommand("Your Query Here", con);
            SqlDataReader drQuery = cmdQuery.ExecuteReader();
            DataSet dsQuery = new DataSet();
            DataTable dtQuery = new DataTable();
            dsQuery.Tables.Add(dtQuery);
            dsQuery.Load(drQuery, LoadOption.PreserveChanges, dsQuery.Tables[0]);
            DataGridView1.DataSource = dsQuery.Tables[0];

Happy Coding.

i do it with DataGridView RadComponent..

public Form1()
       {
           InitializeComponent();

           SqlCommand k = new SqlCommand()
           {
         Connection = new SqlConnection() { ConnectionString = @"Data source=.\sqldeveloper;Integrated
                                            Security=true;Database=shop" },

               CommandText = "select * from customer"

           };

         k.Connection.Open();
         SqlDataReader g=  k.ExecuteReader();

         radGridView1.MasterGridViewTemplate.LoadFrom(g);
       }