Hi Marchesini,
Thanks for contacting Syncfusion support.
We have analyzed your query and we suspect that you want to bind the dataTable to the Grid with the dDataSourceCachingMode as viewstate. We are able to reproduce the reported issue from our end. Because binding grid dataTable, when its go for postBack then it will need to get serialize. This is the root cause of the issue.
Refer the below code example.
public partial class _Default : Page
{
protected void Page_Load(object sender, EventArgs e)
{
var datatable = GetGridDT();
var emp = (from DataRow row in datatable.Rows
select new OrderTable
{
OrderID = Convert.ToInt32(row["OrderID"]),
CustomerID = row["CustomerID"].ToString(),
EmployeeID = Convert.ToInt32(row["EmployeeID"]),
ShipCountry = row["ShipCountry"].ToString()
}).ToList();
this.FlatGrid.DataSource = emp;
}
public static DataTable GetGridDT()
{
var connection = ConfigurationManager.ConnectionStrings["NORTHWNDConnectionString"].ConnectionString;
var dataTable = new DataTable();
using (var dataAdapter = new SqlDataAdapter("SELECT * from Orders", connection))
{
dataAdapter.Fill(dataTable);
}
return dataTable;
}
|
We have prepared a sample and it can be downloadable from the below location.
If we misunderstood your query then please get back to us.
Regards,
Thavasianand S.
