how do I filter data from gridview which binded by dataset

Question

Im selecting all records from no of columns from 5 tables by joining. aftre bind it to gridview want to search records on demand on columns without go to server? so how to to do that?by xml or datatable or dataset then how?

Azaad Abbas · Answer

sir now how to paging from that dataset?

Azaad Abbas · Answer

daAcc.Fill(Ds); //at this line iam gettin error : Value cannot be null. Parameter name: dataSet

Khargesh Rajput · Answer

this is read property for dataset if dataset is null then return null otherwise return dataset value from viewstate

Dawood Abbas · Answer

return temp == null ? null : temp as DataSet; //here what it meant?

Dawood Abbas · Answer

daAcc.Fill(Ds); //at this line

Gowtham Rajamanickam · Answer

great one..

Khargesh Rajput · Answer

debug your code and check which line showing this error

Azaad Abbas · Answer

If I do like this then throwing error: Value cannot be null. Parameter name: dataSet public DataSet Ds { get { object temp = ViewState[Ds]; return temp == null ? null : temp as DataSet; } set { ViewState[Ds] = value; } } public void gridCustBind(int pageIndex) { try { //open the db connection if it is closed... if (connection.State == ConnectionState.Closed) connection.Open(); command = new SqlCommand(); command.CommandText = sp_Get_CustInfoSerach; command.CommandType = CommandType.StoredProcedure; command.Connection = connection; command.Parameters.AddWithValue(@PageIndex pageIndex); command.Parameters.AddWithValue(@PageSize int.Parse(ddlPaging.SelectedValue)); command.Parameters.Add(@RecordCount SqlDbType.Int 4); command.Parameters[@RecordCount].Direction = ParameterDirection.Output; //SqlParameter outParam = command.Parameters.Add(@bal SqlDbType.Float); //outParam.Direction = ParameterDirection.Output; command.Parameters.Add(@bal SqlDbType.Int 4); command.Parameters[@bal].Direction = ParameterDirection.Output; SqlDataAdapter daAcc = new SqlDataAdapter(command); daAcc.Fill(Ds); } catch (Exception ex) { lblMessageCustSerach.Text = ex.Message; lblMessageCustSerach.Visible = true; } finally //Close db Connection if it is open.... { if (connection.State == ConnectionState.Open) connection.Close(); } } protected void Page_Load(object sender EventArgs e) { if (!IsPostBack == true) { gridCustBind(1); if (gridCustomer.Rows.Count > 0) { gridCustomer.DataSource = Ds; gridCustomer.DataBind(); } } }

Azaad Abbas · Answer

Iam using dropdown list for the paging onselectedindexchanged=PageSize_Changed> 5 10 25 50 100 250 500 1000

Khargesh Rajput · Answer

only write properties in gridview AllowPaging=true PageSize=10 and on event OnPageIndexChanging grdSearch.PageIndex = e.NewPageIndex; fncBindGrid();// this is function where You write the code on page load to bind gridview

Azaad Abbas · Answer

can u send the code for paging plz.

Khargesh Rajput · Answer

you can use paging in gridview by settiong allowpaging=true and pagesize=10 pagesize depend on you

Azaad Abbas · Answer

sir before u only sended me link of asp sippest for paging the gridview so that worked. but here for paging need IDataReader coz its coming from sql query if bind dataset then cant do paging.

Khargesh Rajput · Answer

sorryi have never used Idatareader You can try to check otherwise use dataset

Azaad Abbas · Answer

But here iam binding the gridview from IDataReader object for paging the gridview so can I have to create IDataReader object globally instead of dataset? My gridview bind code is below. public void gridCustAllInfoBind(int pageIndex) { try { //open the db connection if it is closed... if (connection.State == ConnectionState.Closed) connection.Open(); command = new SqlCommand(); command.CommandText = sp_Get_CustInfoSerach; command.CommandType = CommandType.StoredProcedure; command.Connection = connection; command.Parameters.AddWithValue(@PageIndex pageIndex); command.Parameters.AddWithValue(@PageSize int.Parse(ddlPaging.SelectedValue)); command.Parameters.Add(@RecordCount SqlDbType.Int 4); command.Parameters[@RecordCount].Direction = ParameterDirection.Output; SqlParameter outParam = command.Parameters.Add(@bal SqlDbType.Float); outParam.Direction = ParameterDirection.Output; SqlDataAdapter daAcc = new SqlDataAdapter(command); DataSet dataset = new DataSet(); daAcc.Fill(dataset); IDataReader idr = command.ExecuteReader(); gridCustomer.DataSource = idr; gridCustomer.DataBind(); idr.Close(); connection.Close(); } catch (Exception ex) { lblMessageCustSerach.Text = ex.Message; lblMessageCustSerach.Visible = true; } finally //Close db Connection if it is open.... { if (connection.State == ConnectionState.Open) connection.Close(); } }

Khargesh Rajput · Answer

yes but DataSet dsAcc = new DataSet(); you have created object here instead you declare dataset globally in viewstate as public DataSet Ds { get { object temp = ViewState[Ds]; return temp == null ? null : temp as DataSet; } set { ViewState[Ds] = value; } }

Azaad Abbas · Answer

Ohso can I write like below instead of dataset = objdal.FillDataSet(CommandType.StoredProcedure sp_getTopic); connection.Open(); command = new SqlCommand(); command.CommandText = sp_Get_CustInfoSerach; command.CommandType = CommandType.StoredProcedure; command.Connection = connection; command.Parameters.AddWithValue(@PageIndex pageIndex); command.Parameters.AddWithValue(@PageSize int.Parse(ddlPaging.SelectedValue)); command.Parameters.Add(@RecordCount SqlDbType.Int 4); command.Parameters[@RecordCount].Direction = ParameterDirection.Output; SqlParameter outParam = command.Parameters.Add(@bal SqlDbType.Float); outParam.Direction = ParameterDirection.Output; SqlDataAdapter daAcc = new SqlDataAdapter(command); DataSet dsAcc = new DataSet(); daAcc.Fill(dsAcc);

Khargesh Rajput · Answer

I have write Ds = objdal.FillDataSet(CommandType.StoredProcedure sp_getTopic); for a example to show to bind dataset you have to write your query/procedure to bind dataset I was using DAL class and methods to fill dataset from database and bind dataset to gridview

Azaad Abbas · Answer

Ds = objdal.FillDataSet(CommandType.StoredProcedure sp_getTopic); /*Here 'objdal' of which object where its declared??*/

Khargesh Rajput · Answer

yes if (!Page.IsPostBack) { //code to bind }

Azaad Abbas · Answer

step 2 bind gridview on postback check /*MEAN BEFORE !iSpOSTbACK CHECK? OR IN SIDE?*/ Ds = objdal.FillDataSet(CommandType.StoredProcedure sp_getTopic); /*WHAT IS objdal?*/

Khargesh Rajput · Answer

step 1 initialize dataset globaaly above page load in viewstate as public DataSet Ds { get { object temp = ViewState[Ds]; return temp == null ? null : temp as DataSet; } set { ViewState[Ds] = value; } } step 2 bind gridview on postback check Ds = objdal.FillDataSet(CommandType.StoredProcedure sp_getTopic); if (Ds.Tables[0].Rows.Count > 0) { grdSearch.DataSource = Ds.Tables[0]; grdSearch.DataBind(); } } step 3 on search buttonclick string strFieldNm; strFieldNm = ddl_Search.Text.Trim(); if (strFieldNm == Category) { strFieldNm = category_name; } if (strFieldNm == Class) { strFieldNm = class_name; } if (txt_Search.Text.Trim().Length > 0) { DataTable dt = new DataTable(); dt = Ds.Tables[0]; dt.DefaultView.RowFilter = Convert([ + strFieldNm + ]'System.String') Like ' + txt_Search.Text.Trim().Replace(' '') + %' ; grdSearch.DataSource = dt; grdSearch.DataBind(); } here i have search by dropdown(by columnname of database you want to search) and textbox for keyword you want to search i have bind dropdown statically as CategoryClass and category_nameclass_name are columnname from dataset I hope It may help you