Hello,
In debug mode, the RadGridView within the application gets it's information from a SQLCE Database just fine. But once I set it to release mode, The itemsource does have items inside, but the RadGridView shows nothing.
Thank you for reading my problem,
Joe Nguyen
In debug mode, the RadGridView within the application gets it's information from a SQLCE Database just fine. But once I set it to release mode, The itemsource does have items inside, but the RadGridView shows nothing.
public
partial
class
MainWindow : Window
{
public
MainWindow()
{
InitializeComponent();
//radGridView1.ItemsSource = getData();
radGridView1.IsFilteringAllowed =
true
;
}
public
DataTable getData()
{
// Creating a datatable to bind to the radgrid
DataTable tableItem =
new
DataTable();
//Readonly Fields, not for inlinje editing
DataColumn code =
new
DataColumn(
"Code"
,
typeof
(
string
));
code.ReadOnly =
true
;
DataColumn product =
new
DataColumn(
"Product"
,
typeof
(
string
));
product.ReadOnly =
true
;
// Adding fields
tableItem.Columns.Add(
new
DataColumn(
"Username"
,
typeof
(
string
)));
tableItem.Columns.Add(product);
tableItem.Columns.Add(
new
DataColumn(
"Company"
,
typeof
(
string
)));
tableItem.Columns.Add(
new
DataColumn(
"Model"
,
typeof
(
string
)));
tableItem.Columns.Add(
new
DataColumn(
"Serial"
,
typeof
(
string
)));
tableItem.Columns.Add(
new
DataColumn(
"Status"
,
typeof
(
string
)));
tableItem.Columns.Add(
new
DataColumn(
"Date"
,
typeof
(
string
)));
tableItem.Columns.Add(code);
// Connection string for the local Database, and grab all the data from it to store into the grid
string
conString = Properties.Settings.Default.ExternalInventoryDBConnectionString;
string
queryString =
"Select * from externalInventory"
;
using
(SqlCeConnection con =
new
SqlCeConnection(conString))
{
try
{
con.Open();
SqlCeCommand cmd =
new
SqlCeCommand(queryString, con);
// create data adapter
SqlCeDataAdapter da =
new
SqlCeDataAdapter(cmd);
da.Fill(tableItem);
}
finally
{
con.Close();
}
}
return
tableItem;
}
}
Thank you for reading my problem,
Joe Nguyen