Show Multiple Data to Datagridview using C#

Question

I want to show multiple data based on value I input to textboxes. I have data such as :

WSID   CasA   CasB 
1234   200    100   
5678   300    200
0987   400    300
6543   500    400

If I input in CasA textbox = 200 and CasB textbox = 200, WSID 1234 and 5678 will be shown. I got some problem, if I input value like above, it just show WSID of CasB. Can anyone help me ?

string lokasinectar = LokasiNectar.Text;
string koneksinectar = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + lokasinectar + ";Extended Properties='Excel 12.0 xml;HDR=YES;IMEX=1';";

int thresholdcasa;
Int32.TryParse(CasA.Text, out thresholdcasa);

int thresholdcasb;
Int32.TryParse(CasB.Text, out thresholdcasb);

OleDbConnection kon = new OleDbConnection(koneksinectar);
DataTable dt = new DataTable();

OleDbDataAdapter adapter = new OleDbDataAdapter("select [WSID], [CasA], [CasB] from [Sheet1$]", kon);
DataSet coba = new DataSet();
adapter.Fill(coba);

var table = coba.Tables[0];
var view = new DataView(table);

if (CasAChk.Checked)
{
    if (CasA.Text.Length > 0)
    {

        view.RowFilter = string.Format("[CasA] = '{0}'", thresholdcasa);
    }
}
else if (CasBChk.Checked)
{
    if (CasB.Text.Length > 0)
    {
        view.RowFilter = string.Format("[CasB] ='{0}'", thresholdcasb);
    }  
}

ViewNectarGV.DataSource = view;

When is your code running? Is it during an event e.g. after checking a check box? — jambonick
– jambonick, Commented Nov 28, 2016 at 10:12

Community · Accepted Answer · 2017-05-23 11:45:58Z

1

You are building your RowFilter in an if... else if statement, hence only one code block or the other can be executed. You need to build a dynamic filter which appends all columns you wish to filter by, joined by an OR. Largely borrowed from this answer, try the following:

int temp = 0;
StringBuilder sb = new StringBuilder();

if (CasAChk.Checked && Int32.TryParse(CasA.Text, out temp))
{
    sb.Append(string.Format("[CasA] = '{0}'", temp));
}

if (CasBChk.Checked && Int32.TryParse(CasB.Text, out temp))
{
    if (sb.Length > 0)
    {
        sb.Append(" OR ");
    }

    sb.Append(string.Format("[CasB] = '{0}'", temp));
}

view.RowFilter = sb.ToString();

ViewNectarGV.DataSource = view;

edited May 23, 2017 at 11:45

CommunityBot

11 silver badge

answered Nov 28, 2016 at 16:24

OhBeWise

5,4745 gold badges36 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Alfonsus Dhani Over a year ago

Ahh thanks so much ! It works ! :) I want to ask you once again. How can I set their each column color ? For example for CasA, I want to color its output column as red, and yellow for output of CasB @OhBeWise

OhBeWise Over a year ago

After setting the DataSource, you can set yourDataGridView.Columns[desiredColumnIndex].DefaultCellStyle.ForeColor or .BackColor to your preferred color.

Alfonsus Dhani Over a year ago

Mmm. I mean, for example when the desired result is shown, its column will be blue and another will be white. So, when 200 of CasA is shown, its color of column will be change and the color of 300, 400, amd 500 will not change. Can you help me ?

OhBeWise Over a year ago

If I understand you correctly, you want to color just the cells that were matched in the filter?

Alfonsus Dhani Over a year ago

Yes I do. Can you help me ?

|

Collectives™ on Stack Overflow

Show Multiple Data to Datagridview using C#

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related