private void DisplayUpdatedCountries()
{
GeneralConnection cn = ConnectionHelper.GetConnection();
string query = getSQL();
DataSet ds = cn.ExecuteQuery(query, null, QueryTypeEnum.SQLQuery, false);
ds.Tables[0].PrimaryKey = new DataColumn[1] {
ds.Tables[0].Columns["CountryID"]
};
DataTable table = ds.Tables[0];
table.Rows.Clear();
GetAndUpdateCustomTableQueryItem();
//DataSet dsAvailable = (DataSet)UniGridAvailable.DataSource;
//dsAvailable.Tables[0].PrimaryKey = new DataColumn[1] { dsAvailable.Tables[0].Columns["CountryID"] };
foreach (int i in iCountry)
{
DataRow drow = table.NewRow();
DataRow findrow = dsAvailable.Tables[0].Rows.Find(i.ToString());
if (findrow != null)
{
drow["CountryId"] = findrow["CountryID"];
drow["CountryDisplayName"] = findrow["CountryDisplayName"];
drow["UnitPrice"] = findrow["UnitPrice"];
drow["ShippingBase"] = findrow["ShippingBase"];
table.Rows.Add(drow);
}
DataRow d = dsAvailable.Tables[0].Rows.Find(i.ToString());
if (d != null)
{
dsAvailable.Tables[0].Rows.Remove(d);
}
}
UniGridUpdated.DataSource = ds;
UniGridUpdated.DataBind();
UniGridAvailable.ReBind();
SetConfirmText(null, null);
}
