private void BindCountrySite()
{
DataSet dataset = sitecode.GetSiteCodeFinalData();
GridView gv = new GridView();
//grdmmauditingreport.DataSource = dt;
//grdmmauditingreport.DataBind();
for (int row = 0; row < dataset.Tables[0].Rows.Count; row++)
{
if (dataset.Tables[0].Rows[row][1].ToString() == DDRSessionEntity.Current.SiteCode)
{
DDRSessionEntity.Current.CountryCode = dataset.Tables[0].Rows[row][2].ToString();
}
}
}
protected DataTable sitecodebindtableheader()
{
DataTable sctable = new DataTable();
sctable.Columns.Add("SAPID", typeof(string));
sctable.Columns.Add("Site Code", typeof(string));
sctable.Columns.Add("ISO Code", typeof(string));
sctable.Columns.Add("Description", typeof(string));
DataSet datasettotable = sitecode.GetSiteCodeFinalData();
DataRow scrow;
for (int row = 0; row < datasettotable.Tables[0].Rows.Count; row++)
{
scrow = sctable.NewRow();
scrow["SAPID"] = datasettotable.Tables[0].Rows[row][0];
scrow["Site Code"] = datasettotable.Tables[0].Rows[row][1];
scrow["ISO Code"] = datasettotable.Tables[0].Rows[row][2];
scrow["Description"] = datasettotable.Tables[0].Rows[row][3];
sctable.Rows.Add(scrow);
}
return(sctable);
}