Excel Forum

Code: Select all

 
	public DataSet GetData(string queryString, string connectionString)
	{
	
	DataSet ds = new DataSet();
      // Connect to the database and run the query.
      SqlConnection connection = new SqlConnection(connectionString);        
      SqlDataAdapter adapter = new SqlDataAdapter(queryString, connection);

      // Fill the DataSet.
      adapter.Fill(ds);
      
      return ds;
      }
      

Code: Select all

      <asp:gridview id="dataGridView" 
        autogeneratecolumns="true" 
        runat="server">
      </asp:gridview>

Code: Select all

void Page_Load(Object sender, EventArgs e)
{
	if (!IsPostBack)
	{
		
		dataGridView.DataSource = GetData(queryString,connectionString).Tables[0];
		
	}

}