views:

16

answers:

0

Hello

I've a grid in my winforms application and i bind a huge dataset to the grid. Will the dataset be stored in the memory by the grid after calling DataBind(). How does it operate on the data binded to the grid?

Update

I wrote the following code

DataTable dt = new DataTable();
        using (SqlConnection con = new SqlConnection("Server=server;Initial Catalog=db;User ID=testv;Pwd=pass"))
        {
            con.Open();
            using (SqlCommand com = new SqlCommand("select * from tbl_Sample", con))
            {
                using (SqlDataAdapter ada = new SqlDataAdapter(com))
                {
                    ada.Fill(dt);
                    dgvMain.DataSource = dt;
                    dt.Dispose();
                }
            }
        }

After assigning the datatable as the datasource i'm able to dispose it. So does it make a copy in the memory?

Thanks

NLV