The Windows Forms DataGrid has a different requirement than the Web Forms one: you need to be able to get data at a given row (IList) instead of just read it through forward once (IEnumerable, which is what DataReader is).  One way around this is to use BindingSource, which will read the data out:
  Dim source As New BindingSource
  source.DataSource = datareader
  datagrid1.DataSource = source

-Scott

The Windows Forms DataGrid has a different requirement than the Web Forms one: you need to be able to get data at a given row (IList) instead of just read it through forward once (IEnumerable, which is what DataReader is).  One way around this is to use BindingSource, which will read the data out:
  Dim source As New BindingSource
  source.DataSource = datareader
  datagrid1.DataSource = source

-Scott

Hi Scott, but I found BinidingSource is part of framework 2.0, Is there any alternative way in 1.1 to achieve the same.

-prince

SqlConnection con = new SqlConnection("SERVER=.;UID=sa;PWD=123;DATABASE =NorthWind");

con.Open();

SqlCommand objCommand = new SqlCommand("SELECT FirstName, LAstName from Employees",con);

sqlDataReader = objCommand.ExecuteReader(System.Data.

CommandBehavior.CloseConnection);

BindingSource bindingSource = new BindingSource();

bindingSource = sqlDataReader;

/// Here i am getting error "Can not implicity convert type"

this.dataGridT1.DataSource = sqlDataReader;


-Balamurugan.S