How to write the code for search criteria in asp.net????

Question

I'm new to asp.netcan any one help me how to write the search criteria in asp.net....please check the below links because I want to write a code like this. so can any body help me out? https://career4.successfactors.com/career?company=Mindtree...In this page after clicking on button it should be redirect to next page with details like https://career4.successfactors.com/career?company=Mindtree&career_ns=job_listing_summary&navBarLevel=JOB_SEARCH&_s.crb=kpstbNLArk2XYgsXDE%2f0rlswGrc%3d can any one help me how to write the code for search criteria for each textbox and dropdown?

birju gohel · Answer

Store PROCEDURE In Sql Side Create //////////////////////////////////////////////// ALTER PROCEDURE [dbo].[DailyReportGrid_Criteria] @Criteria varchar(max) AS declare @Condition as varchar(max) SET @Condition ='' BEGIN SET @Condition =' With a as ( select Count(ClientMaster.ClientId) as ClientEntryClientMaster.DataEnterDate COUNT(FolloupMaster.intclientfolloupid)as FollowEntryDataEnterDateFolloupMaster Count(LeadMaster.intLeadId) as LeadEntryLeadMaster.dtleadDate COUNT(QuotationMasterNew.QuotationId) as QuotationEntryQuotationMasterNew.SubmitDate COUNT(InvoiceMasterNew.InvoiceId) as InvoiceEntryInvoiceMasterNew.InvoiceDate COUNT(PaymentMaster.PaymentId) as PaymentEntryPaymentMaster.PaymentDueDate from ClientMaster FolloupMaster LeadMaster QuotationMasterNew InvoiceMasterNew PaymentMaster ) select EmployeeMaster.intEmployeeID (EmployeeMaster.strFirstName + '' '' + isnull(EmployeeMaster.strMiddleName '''') + '' '' + EmployeeMaster.strLastName) as FullName a.ClientEntrya.FollowEntrya.LeadEntrya.QuotationEntrya.InvoiceEntrya.PaymentEntry ClientMaster.DataEnterDateFolloupMaster.dtFollowDateLeadMaster.dtleadDateQuotationMasterNew.SubmitDateInvoiceMasterNew.InvoiceDatePaymentMaster.PaymentDueDate --a.DataEnterDatea.dtFollowDatea.dtleadDatea.SubmitDatea.InvoiceDatea.PaymentDueDate from aEmployeeMasterClientMasterFolloupMasterLeadMasterQuotationMasterNewInvoiceMasterNewPaymentMaster ' + '' + @Criteria + '' print @Condition exec(@Condition) END ////////////////////////////////////////////// Cs Code In Button Click Event To Write Code ............................. //////////////////////////////////////////// string SearchCriteria =  WHERE 1=1 ; if (Session[Role].Equals(Admin)) { if (ddlEmployee.SelectedIndex != 0 && ddlEmployee.SelectedIndex != -1) { SearchCriteria = SearchCriteria +  AND EmployeeMaster.intEmployeeId= + Convert.ToInt16(ddlEmployee.SelectedValue) + ; } } else if (Session[Role].Equals(Operator)) { SearchCriteria = SearchCriteria +  AND EmployeeMaster.intEmployeeId= + Convert.ToInt16(ddlEmployee.SelectedValue) + ; } //if (ddlEmployee.SelectedIndex != 0) //{ // SearchCriteria = SearchCriteria +  AND EmployeeMaster.intEmployeeID= + Convert.ToInt16(ddlEmployee.SelectedValue) + ; //} if (ddlCompanyName.SelectedIndex != 0) { SearchCriteria = SearchCriteria +  AND InvoiceMAsterNew.CompanyId= + Convert.ToInt16(ddlCompanyName.SelectedValue) + ; } if (txtTodate.Text != ) { SearchCriteria = SearchCriteria +  AND InvoiceMAsterNew.InvoiceDate>=' + txtTodate.Text.ToString() + '; } if (txtFromdate.Text != ) { SearchCriteria = SearchCriteria +  AND InvoiceMAsterNew.InvoiceDate } Session[criteria] = SearchCriteria.ToString(); Session[criteria] = Session[criteria].ToString().Replace('' '); Response.Redirect(InvoiceSummaryReportResult.aspx); ////////////////////////////////////

birju gohel · Answer

http://birjugohel.blogspot.in/2013/08/search-criteria-sql-query.html?view=flipcard