public static DataTable getReadingTableFromSchema()
{
string TARIH = DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString() + "-" + DateTime.Now.Year.ToString();
using (SqlConnection conn = new SqlConnection(CS))
{
string sql = string.Format("EXEC[LG_118_ONAY] '','{0}'", TARIH);
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
DbDataAdapter da = new SqlDataAdapter(cmd);
DataTable dtbl = new DataTable();
da.FillSchema(dtbl, SchemaType.Source);
return dtbl;
}
}
private void INITIALIZEGV()
{
DataTable DTNEW = getReadingTableFromSchema();
DataTable DT = _M.SELECT_LISTE();
string TARIH = DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString() + "-" + DateTime.Now.Year.ToString();
foreach (DataRow item in DT.Rows)
{
string STUDENTCODE = item[0].ToString();
DataRow s = _M.SELECT_ONAY(CODE, TARIH).Rows[0];
DTNEW.ImportRow(s);
}
gc_CONTROL1.DataSource = DTNEW;
}