当我在组合框中没有选择任何内容时，如何清除datagridview行 [英] How to clear the datagridview rows when I selected nothing in the combobox

问题描述

我有Bankname组合框，accountno文本框，accounttype组合框和一个datagridview。

现在我从combobox accountno和accounttype中选择bankname，显示各自的字段并显示相关数据在datagridview.After选择bankname combobox accountno和accounttype清除罚款后没有。但datagriddata没有清除。我在谷歌搜索并尝试了不同的方法得到无法清除列表错误。请任何人可以帮助我。

提前感谢。



我尝试过：

I have Bankname combobox,and accountno textbox,accounttype combobox and one datagridview.
Now i select bankname from combobox accountno and accounttype showing respective fields and showing the related data in datagridview.After selecting nothing from bankname combobox accountno and accounttype clearing fine.but datagriddata is not clearing.I have searched in google and tried different ways getting Cannot clear the list error.Please Anybody could help me please.
thanks in advance.

What I have tried:

<blockquote class="quote"><div class="op">Quote:</div>  
    private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            DataTable dt = new DataTable();
            string abc = cmbbankname.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", cmbbankname.SelectedValue.ToString());
                SqlDataAdapter sda = new SqlDataAdapter(cmd);
                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 (cmbbankname.SelectedIndex == 0)
            {
                txtAcntno.Text = "";
                cmbAcntype.SelectedIndex = 0;
                dgvwChqs.Rows.Clear();


            }
        }




         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_Chqlvscount,[bank_Chqendno],bank_Stat FROM 
   [dbo].bankcheques where bank_Id=@bank_Id order by SlNo desc ", con);
            cmd.Parameters.AddWithValue("@bank_Id", cmbbankname.SelectedValue.ToString());
            try
            {
                con.Open();
                SqlDataAdapter da = new SqlDataAdapter();
                da.SelectCommand = cmd;
                DataTable dt = new DataTable();
                da.Fill(dt);
                dgvwChqs.DataSource = dt;
                con.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        </blockquote>

推荐答案

if (abc != "[select, select]" && abc != "select")
{
 datagridview.DataSource = null;
}

这篇关于当我在组合框中没有选择任何内容时，如何清除datagridview行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！