Hello,

Thank you for your report. I will let you know when this issue has been fixed.

Regards,

Hans.

Hello,

You could use DataTable in your scenario if you want to.

I made a new sample. I did like before, I use nortwind.mdb database and shippers table then I added a new row that have a null/blank text at Phone field.

In my sample, I want to change the null value in Phone field with “No Phone Number” value.

I made two DataTable. The first DataTable, I get the data from database. The second DataTable, I created/added the columns and the rows programmatically.

I copied row data from the first DataTable to the second DataTable. But while copying data row, I checked if the value in Phone field is null, I changed it to “No Phone Number” value.

I put the script in InitializeDataSource() server side event. Here’s the script below.

protected void WebGrid1_InitializeDataSource(object sender, ISNet.WebUI.WebGrid.DataSourceEventArgs e)
{
        OleDbConnection oConn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\Northwind.mdb;Persist Security Info=True");
        oConn.Open();
        string t = "SELECT * FROM Shippers";
        OleDbDataAdapter da = new OleDbDataAdapter(t, oConn);
        DataTable table = new DataTable();
        da.Fill(table);
        // Create new DataTable
        DataTable newTable = new DataTable();
        // Create new column
        DataColumn col1 = new DataColumn("ShipperID");
        col1.DataType = System.Type.GetType("System.Int32"); 
        DataColumn col2 = new DataColumn("CompanyName");
        col2.DataType = System.Type.GetType("System.String");
        DataColumn col3 = new DataColumn("Phone");
        col3.DataType = System.Type.GetType("System.String");
        // Add the columns to newTable
        newTable.Columns.Add(col1);
        newTable.Columns.Add(col2);
        newTable.Columns.Add(col3);
        // Get the number of data in Shippers table
        DataRowCollection rows= table.Rows;
        // It's looping as much as number of data in Shippers table
        for(int i=0;i<rows.Count;i++)
        {
            DataRow row = newTable.NewRow();
            
            row[col1] = rows[i].ItemArray[0];
            row[col2] = rows[i].ItemArray[1];
            // If the phone field is null
            if (rows[i].ItemArray[2].ToString() == "")
            {
                row[col3] = "No Phone Number";
            }
            // If the phone field isn't null
            else
            {
                row[col3] = rows[i].ItemArray[2];
            }
            // Add rows to newTable
            newTable.Rows.Add(row);       
        }
        
        e.DataSource = newTable;
    }

I also attached my sample, in order you can more easily to understand my sample.

But in my opinion, there aren’t any different in export process if you are using DataTable or not.

Hope this help. Thank you.

Regards,

Hans

Hello,

I’m sorry for this misunderstanding. I also can replicate your issue. This issue occurs because the new value [“**”] have a different type (string) with the column field type (integer).

If you still want to use this scenario, I suggest to create/add a new column with string type. Then copy the (integer) column’s value to the new (string) column.

I made a simple sample that maybe have the same with your scenario. In my sample, I’m using Nortwind.mdb and Order Details table.

In WebGrid, I add new column (string type), named Qty_Extended. I also set the Visible property in Quantity column to false.

In InitializeRow() event, if the Quantity have value less than 10, I set the value to “**” and then I add the value in Quantity column to Qty_Extended column.

protected void WebGrid1_InitializeRow(object sender, ISNet.WebUI.WebGrid.RowEventArgs e)
{
        var qty = Convert.ToInt32(e.Row.Cells[3].Value);
        // If the value in Quantity column less than 10
        if (qty < 10)
        {
            // Set text in Quantity column to "**"
            e.Row.Cells[3].Text = "**"; // 
        }
        // Set text and value in Qty_Extended column
        e.Row.Cells[4].Text = e.Row.Cells[3].Text;
        e.Row.Cells[4].Value = e.Row.Cells[3].Text;
}

I attached my sample, in order you can more easily to understand my sample.

Hope this one can help you. Thank you.

Regards,

Hans

Hello,

This error appears because the control can’t load any script / sources (like JavaScript or Images) file that the control need.

According to you error, it seems you are using WebPaneManager control.

So, please check your project’s bin folder.

-If you are using Smart Web Resource, please make sure there are ISNet.WebUI.WebDesktop.dll & ISNet.WebUI.WebDesktop.Resource.dll assemblies in your Bin folder.

-If you are not using Smart Web Resource, please make sure ISNet.dll, ISNet.WebUI.dll & ISNet.WebUI.WebDesktop.dll assemblies in your Bin folder.

And please also check your WebPaneManager’s path ScriptDirectory property is correct.

Hope this helps. Thank you.

Hello,

I’m sorry for this inconvenience. I already made a simple sample that maybe similar with your sample.

I’m using nortwind.mdb database and shippers table then I add a new row that have a null/blank text at Phone field.

I also set a FormatCondition in WebGrid and set NullText property (in Phone field) to “**”.

Like you said before the “**” text will appear in WebGrid but doesn’t appear in Excel.

Therefore, I’m using server side event InitializeRow to handle this null text. The result is the “**” text appears in WebGrid and Excel.

I sent you my sample. If you don’t mind please help me to modify the sample. Perhaps, I’m missing something when replicate your issue.

Thank you..

Regards,

Hans