在gridview中搜索数据时出错 [英] got error when serching data in gridview

问题描述

private void Eaddmember_Load(object sender, EventArgs e)
        {
            this.member_CreditTableAdapter.Fill(this.creditDebitDataset.Member_Credit);
            dgvinstallment.Columns[0].HeaderText = "Member No.";
            dgvinstallment.Columns[1].HeaderText = "Credit";
            dgvinstallment.Columns[2].HeaderText = "Paid Date";
            dgvinstallment.Columns[3].HeaderText = "Debit";
            dgvinstallment.Columns[4].HeaderText = "Username";
            dgvinstallment.Columns[5].HeaderText = "Description";
        }

这是页面加载事件

this is page load event

BindingSource bs = new BindingSource();
bs.DataSource = dgvinstallment.DataSource;
bs.Filter = "["+ dgvinstallment.Columns[0].HeaderText.ToString() +"]"+ " LIKE '%" + txtmemberno.Text.ToString() +"%'";
dgvinstallment.DataSource = bs;

这是搜索按钮点击事件



现在我收到错误

找不到列[会员编号]。



i使用我自己的标题文本。

i没有使用数据库标题文本。

this is search button click event

now i got error
Cannot find column [Member No.].

i used my own header text.
i didnt use database header text.

推荐答案

bs.Filter = "[Member_No] LIKE '%" + txtmemberno.Text.ToString() +"%'";

i得到解决方案



Member_No 是数据库中的矿表列名

i got solution

Member_No is mine table column name in database

这篇关于在gridview中搜索数据时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！