How to show cheque details in datagridview row based on selected value from bank name combobox

Question

1.00/5 (1 vote)

See more:

I have two tables bankdetails and chequedetails table both tables have bankid.I created foreignkey on bankid column.I inserted some records in both the tables.Now i have bankname combobox,accountno textbox and accounttype combobox.And one datagridview.dridview is populate from the chequedetails table.
Now if i select bankname in the banknamecombobox accountno and account should displaying fine.Now i want based on banknameselectedid show the related row show in the datagridview
which is coming from chequedetails table.
Please help me on this.
Thanks in advance.

What I have tried:

<pre>   private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
            {
            string abc = comboBox1.SelectedValue.ToString();
            if (abc != "[select, select]" && abc != "select")
            {
                SqlConnection con = new SqlConnection(connection);
                con.Open();
                SqlCommand cmd = new SqlCommand("SELECT [bank_Id],
           [bank_Accountno],bank_Accountype FROM bankdetails where 
             bank_Id=@bank_Id",con);
                cmd.Parameters.AddWithValue("@bank_Id", 
                 comboBox1.SelectedValue.ToString());
                SqlDataAdapter sda = new SqlDataAdapter(cmd);
                DataTable dt = new DataTable();
                sda.Fill(dt);
                if (dt.Rows.Count > 0)
                {
                    txtAcntno.Text = dt.Rows[0]["bank_Accountno"].ToString();
                    cmbAcntype.Text = dt.Rows[0]["bank_Accountype"].ToString().Trim();
                    LoadDataGridView();
                }
            }
            else if (comboBox1.SelectedIndex == 0)
            {
                txtAcntno.Text = "";
                cmbAcntype.SelectedIndex = 0;
            }
        }

private void LoadDataGridView()
       {

       SqlConnection con = new SqlConnection(connection);
       SqlCommand cmd = new SqlCommand(" SELECT bank_Id,row_number() over(order by [bank_Id]) as SlNo,[bank_Chqstartno],[bank_Chqendno],case bank_Chqlvscount when 100 then 2 when 50 then 1 when 10 then 0 end as noofcheques ,bank_Chqlvscount,bank_Stat FROM [dbo].bankcheques where bank_Id=@bank_Id order by SlNo desc ", con);
       try
       {
           con.Open();
           SqlDataAdapter da = new SqlDataAdapter();
           da.SelectCommand = cmd;
           DataTable dt = new DataTable();
           da.Fill(dt);
           DataGridViewComboBoxColumn cmb = dgvwChqs.Columns["noofcheques"] as DataGridViewComboBoxColumn;
           cmb.DataSource = dt;
           cmb.DisplayMember = "bank_Chqlvscount";
           cmb.ValueMember = "bank_Id";
           cmb.HeaderText = "No. of Cheques";
           dgvwChqs.DataSource = dt;
           con.Close();
       }
       catch (Exception ex)
       {
           MessageBox.Show(ex.Message);
       }
   }

Posted 11-May-17 0:49am

Member 13153537

Updated 11-May-17 2:24am

v3

Add a Solution

Comments

CHill60 11-May-17 7:45am

Just introduce a WHERE clause into the SQL cmd in LoadDataGridView. You've already shown that you know how to do that. You could pass the selected bank as a parameter to that function if need be.

Member 13153537 11-May-17 8:12am

bankname colum not there in chequedetails table.Only Bankid is there.could you guide me please how to do that.
Thanks in advance.

CHill60 11-May-17 8:18am

According to your selectedindex changed code

cmd.Parameters.AddWithValue("@bank_Id", 
                 comboBox1.SelectedValue.ToString());

you already have the bankid

CHill60 11-May-17 8:19am

If you use the Reply button I will be notified when you respond

Member 13153537 11-May-17 8:54am

When i used this code atleast firsttime i am getting correct and then got an error."Object reference not set to instance of an object".
SqlCommand cmd = new SqlCommand(" SELECT bank_Id,row_number() over(order by [bank_Id]) as SlNo,[bank_Chqstartno],[bank_Chqendno],case bank_Chqlvscount when 100 then 2 when 50 then 1 when 10 then 0 end as noofcheques ,bank_Chqlvscount,bank_Stat FROM [dbo].bankcheques where bank_Id=@bank_Id order by SlNo desc ", con);

cmd.Parameters.AddWithValue("@bank_Id",
comboBox1.SelectedValue.ToString());

Member 13153537 11-May-17 8:25am

Thank you very much.It is working fine for me first time. when i change combobox value second time i am getting "Object reference not set to instance of an object " error.

CHill60 11-May-17 8:55am

You need to debug and find which object is null. We can't see your entire project

Member 13153537 11-May-17 8:57am

ok thank you

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Accepted Answer · 2017-05-11T02:23:00

Solution 1

Reading your question through again I'm guessing that you actually have the bank name as the selectedvalue in the ComboBox and not the bankid.

If you have the bank name and want to get the cheques based on that, then you just have to join to the bank details table ...

SQL

SELECT BC.bank_Id,row_number() over(order by [bank_Id]) as SlNo,[bank_Chqstartno],[bank_Chqendno],
	case bank_Chqlvscount when 100 then 2 when 50 then 1 when 10 then 0 end as noofcheques ,
	bank_Chqlvscount,bank_Stat 
FROM [dbo].bankcheques BC
INNER JOIN [dbo].bankdetails BD ON BC.bank_Id = BD.bank_Id
where bank_name=@bank_name 
order by SlNo desc

Posted 11-May-17 2:23am

CHill60

Comments

Member 13153537 11-May-17 8:46am

After Using the above query.i am getting empty dataset.

Member 13153537 11-May-17 8:47am

After Using the above query.i am getting empty dataset.

CHill60 11-May-17 8:54am

What is the value of the selectedvalue on the combo-box and do you have a bank with that name?

Member 13153537 11-May-17 9:03am

based on the bank_Id. we are passing bank_Name column.

CHill60 11-May-17 9:12am

That doesn't answer my questions! If you already have the bank_id then just search on that

Member 13153537 11-May-17 13:57pm

It is the place where am i the getting the null reference exception. First time it is working fine.But second time when i select different value from the combobox.I am getting that error.How to fix that.
DataGridViewComboBoxColumn cmb = dgvwChqs.Columns["noofcheques"] as DataGridViewComboBoxColumn;
cmb.DataSource = dt;
cmb.DisplayMember = "bank_Chqlvscount";
cmb.ValueMember = "bank_Id";
cmb.HeaderText = "No. of Cheques";
dgvwChqs.DataSource = dt;

CHill60 12-May-17 4:33am

Which line gives the exception?

Member 13153537 11-May-17 23:36pm

For filling the combobox i am used below code.

private void FillBankName()
{

//DataRow dr;
SqlConnection con = new SqlConnection(connection);
con.Open();
SqlCommand cmd = new SqlCommand("select bank_Id,bank_Name from bankdetails", con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();
sda.Fill(dt);
Dictionary<string, string> test = new Dictionary<string, string>();
test.Add("select", "select");

for (int i = 0; i < dt.Rows.Count; i++)
{
test.Add(dt.Rows[i]["bank_Name"].ToString(), dt.Rows[i]["bank_Id"].ToString());
}

comboBox1.DataSource = new BindingSource(test, null);
comboBox1.ValueMember = "Value";
comboBox1.DisplayMember = "Key";
comboBox1.DataBindings.ToString();
con.Close();
}