public void Grid1_NeedRebind(object sender, EventArgs e)
{
DataTable table = new DataTable();
table.Columns.Add("c_id", typeof(Int32));
table.Columns.Add("c_u_TcodeID", typeof(string));
table.Columns.Add("c_u_Description", typeof(string));
if (condition == null)
{
condition = " 1 = 1 ";
}
OdbcDataReader dr = HELPERS.RunSqlSelect("SELECT TOP 20 * FROM t_RBSR_AUFW_u_TcodeDictionary WHERE " + condition);
table.BeginLoadData();
while (dr.Read())
{
string descr = "";
try
{
descr = dr.GetString(2);
}
catch (Exception) { }
table.LoadDataRow(new object[] { dr.GetInt32(0), dr.GetString(1), descr }, true);
}
table.EndLoadData();
DataSet DSET = new DataSet();
DSET.Tables.Add(table);
Grid1.DataSource = DSET;
Grid1.DataBind();
}