[Solved] Using keyword with radgrid needdatasource

[Dana Cobb]

When i bind a grid to a datareader in the needdatasource like this:

Dim rs As SqlDataReader = SqlHelper.ExecuteReader(GetConnectionString("mv4Conn", "mvdata", ConfigurationManager.AppSettings("CircViewDB")), Data.CommandType.Text, sbFilter.ToString)
               Me.RadGrid1.DataSource = rs

should i be using the USING keywod like this:

Using reader As SqlDataReader = getReader()
    ddlCustomer.DataSource = reader
End Using

 
to make sure that the datareader is disposed of?

thanks,
Dana

[Shinu]

Hi,

You can use reader.Close(); method to close the reader. Check the following help documentation which explains more about this.
Binding To DataReader

Thanks,
Shinu