If .. Else on Button Click !!

Question

Hi There I have attached code for button click and now need to put the conditon where on if user does not select any filter then should give entire record what i have for select statement. i.e. i am not selecting the listbox values and directly clicking on button then must to give all records of query vise versa works for listbox filter even. Pls help here !!

Arunraj Apparsamy · Answer

Comment these lines string ListValue1 = LL1.Text; string ListValue2 = LL2.Text; string ListValue3 = LL3.Text; string ListValue4 = LL4.Text; string ListValue5 = LL5.Text; string ListValue6 = LL6.Text; //string dbQuery = select * from TBL_ERP_DAILY_INV_BATCH_REPORT where type = ' + ListValue1 + ' OR [SUPPLIER NUM] = ' + ListValue2 + '; //string dbQuery = select * from TBL_ERP_DAILY_INV_BATCH_REPORT where type = ' + ListValue1 + ' OR [SUPPLIER NUM] = ' + ListValue2 + ' OR [PO NUMBER] = ' + ListValue3 + ' OR [OPERTAING_UNIT] = ' + ListValue4 + ' OR [SUPPLIER] = ' + ListValue5 + ' OR [INVOICE NUM] = ' + ListValue6 + '; and use following code instead of that: string dbQuery = select * from TBL_ERP_DAILY_INV_BATCH_REPORT; string[] str = new string[] { {typeLL1.Text} {SUPPLIER NUMLL2.Text} {PO NUMBERLL3.Text} {OPERTAING_UNITLL4.Text} {SUPPLIERLL5.Text} {INVOICE NUMLL6.Text} } StringBuilder stb = new StringBuilder(); for(int i=0;i { if(str[i][1]!= && stb.length == 0) stb.Append(+str[i][0]+='+str[i][0]+'); else stb.Append( or +str[i][0]+='+str[i][0]+'); } if(stb.length>0) { dbQuery +=  where  + stb.ToString(); }

Tiger Singh · Answer

Hi Madhu Thanks for your input. can you please help me in writting the expected code. protected void Button1_Click(object sender EventArgs e) { string connectionString =Data Source=csfsb-sql02;Initial Catalog=xxx_PROD;Integrated Security=True;; SqlConnection connection = new SqlConnection(connectionString); string ListValue1 = LL1.Text; string ListValue2 = LL2.Text; string ListValue3 = LL3.Text; string ListValue4 = LL4.Text; string ListValue5 = LL5.Text; string ListValue6 = LL6.Text; //string dbQuery = select * from TBL_ERP_DAILY_INV_BATCH_REPORT where type = ' + ListValue1 + ' OR [SUPPLIER NUM] = ' + ListValue2 + '; string dbQuery = select * from TBL_ERP_DAILY_INV_BATCH_REPORT where type = ' + ListValue1 + ' OR [SUPPLIER NUM] = ' + ListValue2 + ' OR [PO NUMBER] = ' + ListValue3 + ' OR [OPERTAING_UNIT] = ' + ListValue4 + ' OR [SUPPLIER] = ' + ListValue5 + ' OR [INVOICE NUM] = ' + ListValue6 + '; //if ((dbQuery != null)) //{ // then should run the query with list boxes filter like above //} //else //{ / should run the entire select statement with out any filter; //} //bBtnClicked = true; try { SqlCommand sqlCmd = new SqlCommand(dbQuery connection); connection.Open(); SqlDataAdapter sda = new SqlDataAdapter(sqlCmd); DataSet dataset = new DataSet(); sda.Fill(dataset); connection.Close(); Gridview1.DataSource = dataset; Gridview1.DataBind(); ExportToExcel(dataset.Tables[0] DailyBatch + DateTime.Now.ToShortDateString()); //Response.Write(LL1.SelectedValue.ToString()); //ExportExcel(dataset); } catch { throw; } } } }

Midhun T P · Answer

Hi Actually you can generate dynamic query based on the values of listbox. On looking on your code I can see you have tried the same. But commented out. So what is the issue you faced while making query based on If conditions?

Tiger Singh · Answer

Hi Tapan Thanks for the input but I have couple of list boxes with OR condition and looking for the code which can else the not selected then run the complete sql script. in case If you get time pls have a look at the code.

Tapan Patel · Answer

Well I haven't looked at your code yet but you can start with something like this if it helps at all. if (listBox1.SelectedItems.Count>0) { //logic to perform in case of filters are selected Debug.WriteLine( selected ); } else { //else otherwise Debug.WriteLine( not selected ); }