Binding dataset to gridview

[satyabhaskar]

hi,
I want to bind the data from the Dataset to GridView
When I run my code I get the error
The type or namespace name 'DataRows' could not be found (are you missing a using directive or an assembly reference?)
I have called the following assemblies
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Web.Configuration;

please help.


thanks

[PRR]

@satyabhaskar
Hi satyabhaskar,

Binding a DataSet to GridView is straight forward...Please post some sample code..

SqlConnection con = new SqlConnection("");
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter("stored proc name/query", con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;//Text
 
da.Fill(ds);
 
gridview1.DataSource = ds;
gridview1.DataBind();
 

[preetis]

//connect to database via dataset & dataadapter
SqlConnection con = new SqlConnection("server=localhost;Initial Catalog=databasename;uid=;pwd=;");
DataSet ds = new DataSet();
 SqlDataAdapter da = new SqlDataAdapter("stored proc name", con);
 da.SelectCommand.CommandType = CommandType.StoredProcedure;
 da.Fill(ds);
 
 //create gridview by code & bind dataset to it
 GridView g = new GridView();
 Page.Controls.Add(g);
 g.DataSource = ds;
 Page.DataBind();

regards

Preeti

[Shabir Ahmed]

if(!IsPostBack)
    {
 
      // Declare the query string.
      String queryString = 
        "Select [CustomerID], [CompanyName], [Address], [City], [PostalCode], [Country] From [Customers]";
 
      // Run the query and bind the resulting DataSet
      // to the GridView control.
      DataSet ds = GetData(queryString);
      if (ds.Tables.Count > 0)
      {
        AuthorsGridView.DataSource = ds;
        AuthorsGridView.DataBind();
      }
      else
      {
        Message.Text = "Unable to connect to the database.";
      }

[007007]

SqlConnection con = new SqlConnection("server=localhost;Initial Catalog=databasename;uid=;pwd=;");
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter("stored proc name", con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.Fill(ds);
 
 
GridView grid = new GridView();
Page.Controls.Add(grid);
grid.DataSource = ds;
Page.DataBind();

[Frinavale]

007007,

Do you have a question?
The code that you have posted already exists within this thread as a part of the answer...Please clarify the reason for your posted code.

-Frinny