Gridview Binding With SqlConnection Objects...

Hello All, I am new to data access and

i have got the problem to display the data into the page by binding the gridview with sqlConnection, sqlCommand and sqlDataReader objects.  The actually code is written as:protected void Page_Load(object sender, EventArgs e)

{
if (!Page.IsPostBack)

{SqlConnection myConnection;

SqlCommand myCommand;SqlDataReader myReader;

myConnection = new SqlConnection();myConnection.ConnectionString = ConfigurationManager.ConnectionStrings["LatteConnectionString"].ConnectionString;

myCommand = new SqlCommand();myCommand.CommandText = "select * from AntiVirusVendors";myCommand.CommandType = CommandType.Text;

myCommand.Connection = myConnection;

myCommand.Connection.Open();myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);

GridView1.DataSource = myReader;

GridView1.DataBind();

myCommand.Dispose();

myConnection.Dispose();

}

 

}

 

and the GridView in html is listed as:

<div>

<asp:GridView ID="GridView1" runat="server">

</asp:GridView>

</div>

So the problem is ---> there is nothing shown in the page, no errors no anything.... just the empty page.

Any ideas would be appreciated. Thanks in advance!

Joe