Add a condition

Question

I want to add a condition: dgvrow.Cells["CibtcaNO"].Value.ToString() != "" . How? Please help me.    private void btnAdjusted_Click(object sender, EventArgs e) { con = new OleDbConnection(conString); if (comboBoxEnterSuspenseAccount.Text != "")   { var query = "SELECT * FROM LalData " + " WHERE " + "SuspenseAccount = @suspenceAccount1 " + "AND " + "(PaymentDate BETWEEN @firstDate AND @lastDate)"; con.Open(); OleDbCommand cmd = new OleDbCommand(query, con); cmd.Parameters.AddWithValue("@suspenceAccount1 ", DbType.String).Value = comboBoxEnterSuspenseAccount.Text.ToString(); cmd.Parameters.AddWithValue("@firstDate ", DbType.Date).Value = dtpFirstDate.Value.ToShortDateString(); cmd.Parameters.AddWithValue("@lastDate ", DbType.Date).Value = dtpLastDate.Value.ToShortDateString(); adapter = new OleDbDataAdapter(cmd); adapter.Fill(dt); dataGridView1.DataSource = dt; dataGridView1.CurrentCell = dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[0]; con.Close(); } }

Manas Mohapatra · Accepted Answer

In your code snippet where do you want to add " dgvrow.Cells["CibtcaNO"].Value.ToString() != ""  "   Please describe more

Manas Mohapatra · Answer

You can use OnRowDataBound property to add condition. follow below links that may help you:   https://www.aspsnippets.com/Articles/Using-RowDataBound-event-in-ASPNet-GridView-with-example.aspx   http://www.c-sharpcorner.com/UploadFile/1e050f/rowdatabound-event-in-gridview-in-Asp-Net/

Shovan Saha · Answer

if ((comboBoxEnterSuspenseAccount.Text != "") && ( dgvrow.Cells["CibtcaNO"].Value.ToString() != "" )){} Combo box will empty. dtpfirstDate and dtplastDate will be selected the dvg will show those data that CibtcaNo cell is empty. Please help me sir.