Hello,

You still have to use your data binding in InitializeDataSoruce event.
Instead of using DataBind, e.DataSource should be working without a problem.
I bind dynamically several tables with DropDownList option. It works well and I also can use VirtualLoad or export.
Hope this helps.

Regards,
Handy

hi Handy Surya,

I am sorry,your answer can not resolve my problem!
I wanna bind many datasets dynamically without other control like"dropdownlist"!

Like MS's Gridview :

   grid.DataSource = dataset1;
   grid.DataBind();

maybe webgrid  does not support "multiTables-Binding",is not it???

only one bind way: e.DataSource ?but this way can not bind multiTables dynamically

how can i do???

Help me please!!

WebGrid supports your required scenario that binds WebGrid to multiple dataset.

I enclosed a sample where WebGrid initially bind to ‘Categories’ dataset of Northwind.mdb database. After the page load, you can change WebGrid’s datasource by selecting a table from the dropdownlist. You can still perform sorting, grouping, column moving and resizing after the new datasource has been applied.

Please check the attached sample for more detail information.

Hello,

So, if you don't want to use DropDownList, may I know how do you want to bind your WebGrid dynamically?
There should be someway you used to trigger bind dynamically in your scenario. 

e.g in my sample, I used DropDownList. 
So, I need to know the detail before can suggest you a sample.

I am sure that our WebGrid supports multiTables.

Regards,
Handy

Like this:

:using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using H.Database;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using ISNet.WebUI.WebGrid;
using ISNet.WebUI.WebCombo;

namespace WebApplication1
{
    public partial class Demo : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                BindList();
            }
        }
        protected void BindList()
        {
            using (StoreDA da = new StoreDA())
            {
                var aa = da.Query();

                this.WebGrid1.DataSource = da.Query1(TextBox1.Text);
                WebGrid1.RetrieveStructure();
                WebGrid1.DataBind();   
             
                WebGrid1.RootTable.DataKeyField = "序列号";
                WebGrid1.RootTable.Columns.GetNamedItem("序列号").IsRowChecker = true;
                         }
        }

          protected void WebGrid1_InitializeDataSource(object sender, ISNet.WebUI.WebGrid.DataSourceEventArgs e)
        {
            //  BindList();
            using (StoreDA da = new StoreDA())
            {
                var aa = da.Query1("");//this is a  query SQl,get a datatable
                e.DataSource = aa;
                WebGrid1.RetrieveStructure();
                WebGrid1.RootTable.DataKeyField = "序列号";
                WebGrid1.DataBind();
                WebGrid1.RootTable.Columns.GetNamedItem("序列号").IsRowChecker = true;
            }
        }

        protected void WebGrid1_PrepareDataBinding(object sender, ISNet.WebUI.WebGrid.DataSourceEventArgs e)
        {

        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            using (StoreDA da = new StoreDA())
            {
                var aa = da.Query1(TextBox1.Text);
                WebGrid1.DataSource = aa;
                WebGrid1.RetrieveStructure();
                WebGrid1.RootTable.DataKeyField = "序列号";
                WebGrid1.DataBind();
                WebGrid1.RootTable.Columns.GetNamedItem("序列号").IsRowChecker = true;
            }
        }

        protected void Button2_Click(object sender, EventArgs e)
        {
            using (StoreDA da = new StoreDA())
            {
                var aa = da.Query2(TextBox2.Text);
                WebGrid1.DataSource = aa;
                WebGrid1.RetrieveStructure();
                WebGrid1.RootTable.DataKeyField = "序列号";
                WebGrid1.DataBind();
                WebGrid1.RootTable.Columns.GetNamedItem("序列号").IsRowChecker = true;
            }
        }

        protected void Button3_Click(object sender, EventArgs e)
        {
            using (StoreDA da = new StoreDA())
            {
                var aa = da.Query3(TextBox3.Text);
                WebGrid1.DataSource = aa;
                WebGrid1.RetrieveStructure();
                WebGrid1.RootTable.DataKeyField = "序列号";
                WebGrid1.DataBind();
                WebGrid1.RootTable.Columns.GetNamedItem("序列号").IsRowChecker = true;
            }
        }

        protected void Button4_Click(object sender, EventArgs e)
        {
            using (StoreDA da = new StoreDA())
            {
                var aa = da.Query4(TextBox4.Text);
                WebGrid1.DataSource = aa;
                WebGrid1.RetrieveStructure();
                WebGrid1.RootTable.DataKeyField = "序列号";
                WebGrid1.DataBind();
                WebGrid1.RootTable.Columns.GetNamedItem("序列号").IsRowChecker = true;
            }
        }
    

    when I input some informations and click a button,get a new dataset,I want bind the dataset to the same webgrid!How can I do ?Please help me!thank you!

Hello, 

Please see my attached sample. I bind WebGrid with diffrent tables via button. Hope this helps.

Regards,
Handy

thank you  Handy Surya;

the answer is perfect!