[C#] Query Search to Datagrid

[puuts]

Hello,

Mga boss, can you please check my below code why it display no data in my datagrid?


I have class

class mdlDashboard : OM.DashboardHyperion

In my class DashboardHyperion

#region DATASOURCE FOR SEARCH DASHBOARD REPORTS


        public virtual DataSet SEARCH_DatasetSource(string strWhere)
        {


            if (strWhere != null) strWhere = " WHERE " + strWhere;
            

            OleDbDataAdapter dap = new OleDbDataAdapter(cmd);

            cmd.CommandText = "SELECT * FROM " + this.TableName + strWhere;
            cmd.CommandType = CommandType.Text;
            cmd.Connection = cn;

            try
            {

                ds.Clear();
                dap.Fill(ds, "dg_Completed");


            }
            catch (Exception ex)
            {

                throw ex;
            }
            finally
            {
                dap = null;
                cn.Close();
            }

            return ds.Copy();
        }



        #endregion

In my TextChanged event

private void txt_Dashboard_Search_TextChanged(object sender, EventArgs e)
{

HYPERION_.MODEL.mdlDashboard myMDL = new HYPERION_.MODEL.mdlDashboard();
this.dg_Report.AutoGenerateColumns = false;
this.dg_Report.DataSource = myMDL.SEARCH_DatasetSource("Report_Name LIKE '%" + this.txt_Dashboard_Search.Text + "%'");

}

Actually, niddisplay nya sa datagrid kung ilan ung nasearch, kaso blanko lng.
View attachment 203368

 

[marveldee]

Sir baka nag return null yung commandtext nyo dahil dito.

OleDbDataAdapter dap = new OleDbDataAdapter(cmd);
cmd.CommandText = "SELECT * FROM " + this.TableName + strWhere;
cmd.CommandType = CommandType.Text;
cmd.Connection = cn;

try nyo po sa baba i instantiate yung adapter nyo ganito

cmd.CommandText = "SELECT * FROM " + this.TableName + strWhere;
cmd.CommandType = CommandType.Text;
cmd.Connection = cn;
OleDbDataAdapter dap = new OleDbDataAdapter(cmd);

 

[puuts]

Sir baka nag return null yung commandtext nyo dahil dito.

OleDbDataAdapter dap = new OleDbDataAdapter(cmd);
cmd.CommandText = "SELECT * FROM " + this.TableName + strWhere;
cmd.CommandType = CommandType.Text;
cmd.Connection = cn;

try nyo po sa baba i instantiate yung adapter nyo ganito

cmd.CommandText = "SELECT * FROM " + this.TableName + strWhere;
cmd.CommandType = CommandType.Text;
cmd.Connection = cn;
OleDbDataAdapter dap = new OleDbDataAdapter(cmd);

still not working.

 

[rhon6260]

Check mo yung data ng cmd.CommandText if meron result yung query