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(); }