Hi Xedem,

    After further investigation, the problem is,  we have set the WebGrid 's width to be 100% and also set the AutoFitcolumn to true as well. So after I removed the width of WebGrid (100%), it fixes the issue. When we used AutoFitColumn to true, we do not need to set the WebGrid to be 100% anymore. It will give us a same behaviour.

    I also attached you a running sample and screenshot of it in both browser. I hope it helps. Thank you and have a nice day.

Best Regards,

Andi Santoso

Hi GS,

   I have tried your scenario and it works just fine. Please ensure that you have put those block of code inside the server side Initialize Layout of WebGrid.

   I also attached you a simple sample of WebGrid using Northwind database and a button on it. After you have made any changes in WebGrid, try to click on the button. It will give us a notification regarding the unsaved data.

   I hope it helps. Thank you and have a nice day.

Best Regards,

Andi Santoso

Hi Ben,

    Basically, if we want to use a SQL Server Connection, we can simply set the return value as a DataTable. After we get the data in DataTable format, we can get the total count of rows and get the value of its row(we can also get by its column as well). Here is the snippet to do so:

 WebNavPane navPane = (WebNavPane)WebPaneManager1.FindControl("WebNavPane1");

           
        DataTable dt = new DataTable();
        
        string connString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Northwind.mdf;Integrated Security=True;User Instance=True";
        
        SqlConnection conn = new SqlConnection(connString);
        SqlDataAdapter daCustomers = new SqlDataAdapter();
        
        conn.Open();
        string queryCustomers = "SELECT * FROM Categories";
        SqlCommand cmd = new SqlCommand(queryCustomers, conn);     
        
        daCustomers.SelectCommand = cmd;
        daCustomers.Fill(dt);
        
        int index = dt.Rows.Count;
            
        for (int i = 0; i < index; i++)
        {
            WebNavBar[] navBar = new WebNavBar[index];
           
            WebNavBarItem[] navBarItem = new WebNavBarItem[index];
            navBar[i] = new WebNavBar();
            navBarItem[i] = new WebNavBarItem();
            navBarItem[i].Name = dt.Rows[i].ItemArray[2].ToString();
            navBarItem[i].Text = dt.Rows[i].ItemArray[2].ToString();
                      
            navBarItem[i].DisplayMode = ISNet.WebUI.WebDesktop.DisplayMode.Text;
           
            navBar[i].Name = dt.Rows[i].ItemArray[1].ToString();
            navBar[i].Text = dt.Rows[i].ItemArray[1].ToString();
            navBar[i].CaptionDisplayMode = ISNet.WebUI.WebDesktop.DisplayMode.Text;
           
            navBar[i].Items.Add(navBarItem[i]);
            navPane.Bars.Add(navBar[i]);
        }

      I hope it helps. Thank you and have a nice day.

Best Regards,

Andi Santoso

Hi Xedem,

     After investigating, the problem is occured because of the table in our sample. There are some settings that are needed to be done in order to use XHTML with this scenario. We will need to set:

- Width at table level. <table style="table-layout:fixed; width:100%;">

- Width at each cell <td style="width:100%">

- Width at Grid level <ISWebGrid:WebGrid Width:"100%">

     To clarify this, I also attached a sample that successfully run in my end and a screenshot of each browser. I have tested them in both browser, IE 8 and Mozilla 3.5.8. I hope it helps. Thank you and have a nice day.

Best Regards,

Andi Santoso

Hi Ben Denison,

     In order to do so, since we need to create an object of NavBar and NavBarItem for each data that we have got from the database list, we will need to use an arrayed of NavBar and NavBarItem object. During the looping, we can add each NavBarItem to NavBar and then, add them to our NavPane one by one.

     Here is the snippet to do so:

    protected void Page_Load(object sender, EventArgs e)
    {
        WebNavPane navPane = (WebNavPane)WebPaneManager1.FindControl("WebNavPane1");

        List<SimpleList.Customer> cust = SimpleList.CustomerManager.GetCustomer();
        int index = cust.Count;

        for (int i = 0; i < index; i++)
        {
            WebNavBar[] navBar = new WebNavBar[index];
           
            WebNavBarItem[] navBarItem = new WebNavBarItem[index];

            navBar[i] = new WebNavBar();
            navBarItem[i] = new WebNavBarItem();
           
            navBarItem[i].Name = cust[i].CustomerName;
            navBarItem[i].Text = cust[i].CustomerName;
            
            navBarItem[i].DisplayMode = ISNet.WebUI.WebDesktop.DisplayMode.Text;
            
            navBar[i].Name = cust[i].CustomerID.ToString();
            navBar[i].Text = cust[i].CustomerID.ToString();
            
            navBar[i].CaptionDisplayMode = ISNet.WebUI.WebDesktop.DisplayMode.Text;
           
            navBar[i].Items.Add(navBarItem[i]);
            navPane.Bars.Add(navBar[i]);
        }
    }

     I also attached you my running sample along with the database list(SimpleList.cs). Please ensure to put this .cs file into the App_Code folder in your project.

     I hope it helps. Thank you and have a nice day.

Best Regards,

Andi Santoso