can you please give me a complete code of example, in which i can populate the webgrid from database using backend C# programming.

        string condition = Request.QueryString["cond"];        string connectString = ConfigurationManager.ConnectionStrings["ConnectionString2"].ConnectionString;        OleDbConnection Connection1 = new OleDbConnection(connectString);        OleDbCommand Cmd = Connection1.CreateCommand();
        Cmd.CommandType = CommandType.Text;
        Cmd.CommandText = "SELECT MENU_PARAMETER_8 FROM ADM_MENU WHERE MENU_ID='" + condition + "'";
        Cmd.Connection.Open();
        OleDbDataAdapter da = new OleDbDataAdapter(Cmd);
        OleDbCommandBuilder comBuilder = new OleDbCommandBuilder(da);
        DataTable dt = new DataTable();
        da.Fill(dt);
        if (dt.Rows.Count > 0)
        {
            foreach (DataRow row in dt.Rows)
            {
                query = row[0].ToString();
            }
        }
        Cmd.Connection.Close();
        OleDbCommand Cmd1 = Connection1.CreateCommand();
        Cmd1.CommandType = CommandType.Text;
        Cmd1.CommandText = query;
        Cmd1.Connection.Open();
        OleDbDataAdapter da1 = new OleDbDataAdapter(Cmd1);
        OleDbCommandBuilder comBuilder1 = new OleDbCommandBuilder(da1);
        DataTable dt1 = new DataTable();
        da1.Fill(dt1);
        WebGrid1.DataSource = dt1;
        WebGrid1.RetrieveStructure();
        WebGrid1.DataBind();
        Cmd1.Connection.Close();

this is the code i have used. Here i am getting the data displayed on the grid. But with this any of the functionality of grid sucha as grouping , virtual load, filtering etc are not working.

please reply me with example code and let me know how can enable features of your webgrid on that(like virtual load).

i have solved this problem by

        WebGrid1.RootTable.AllowAddNew = ISNet.WebUI.WebGrid.AddNew.No;

        WebGrid1.RootTable.AllowEdit = ISNet.WebUI.WebGrid.Edit.No;

        WebGrid1.RootTable.AllowDelete = ISNet.WebUI.WebGrid.Delete.No;

thank you all

hi,

ok.

also i have tried some button event to catch the selected node. But it seems not working.

below is the code,  i have used.

 protected void Button1_Click(object sender, EventArgs e)

    {

          Label1.Text = WebTreeView1.SelectedNode.ToString();

    }

thanks .... i got solution.