public DataSet BusinessFillPhysicianDetails(searchPhysican objphysicanSearch) { SqlParameter[] objParameterSearch = new SqlParameter[3]; objParameterSearch[0] = new SqlParameter("@plan", SqlDbType.VarChar, 25); objParameterSearch[0].Value = objphysicanSearch.plan; objParameterSearch[1] = new SqlParameter("@state", SqlDbType.VarChar, 25); objParameterSearch[1].Value = objphysicanSearch.state; objParameterSearch[2] = new SqlParameter("@depart", SqlDbType.VarChar, 25); objParameterSearch[2].Value = objphysicanSearch.depatrment; objDataSetPhysicanSearch = objDataLayer.DataFillPhysicaSearch(objParameterSearch); return(objDataSetPhysicanSearch); }
protected void btnSearch_Click(object sender, EventArgs e) { searchPhysican search = new searchPhysican(); search.state = DropdownlistState.Text; search.plan = DropdownlistPlan.Text; search.depatrment = DropDownDepart.Text; objDatasetOne = objBusinessLayer.BusinessFillPhysicianDetails(search); if (objDatasetOne.Tables[0].Rows.Count == 0) { lblShow.Text = "Record Not Found"; RepeaterPhysican.Visible = false; } else { RepeaterPhysican.DataSource = objDatasetOne; RepeaterPhysican.DataBind(); } }