public partial class LanLord_Information : Form
    {
        string selectitem = null;
        public LanLord_Information()
        {
            InitializeComponent();
        }
        private void UpdateDataGrid(string sqlStr)
        {
            //Declare and populate the data table
            DataTable dt = new DataTable();
            string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                "Data Source = ADP_Database.mdb";
            OleDbDataAdapter da = new OleDbDataAdapter(sqlStr, connStr);
            da.Fill(dt);
            da.Dispose();
            if (dt.Rows.Count == 0)
                MessageBox.Show("ERROR");
            else
               dgDisplay.DataSource = dt;
        }

        private void btnSearch_Click(object sender, EventArgs e)
        {
            string sqlStr = "SELECT '"+selectitem+"' FROM LandLord WHERE LandLordID = '" + txtlandlordID.Text + "'";
            UpdateDataGrid(sqlStr);

        }
        public void Getstring(string message)
        {
            selectitem += message;
        }
        private void chkLandLordID_CheckedChanged(object sender, EventArgs e)
        {
            Getstring(chkLandLordID.Text);
        }
        private void chkGender_CheckedChanged(object sender, EventArgs e)
        {
            Getstring(chkGender.Text);
        }

小弟想 用一個method 把 N 個check 左的checkbox 的text 串埋一起

在用這個 串起來的 text 做 database search 中要show 的條件

不知道我的想法可不可行呢?

上面是我做的 因為小弟是C# 新手 不太會

我現在的做法中 selectitem 被當做是一個字串show出來

有沒有人可以幫幫我 >.<

public void Getstring(string message)
        {
            selectitem += message;
        }

 string sqlStr = "SELECT '"+selectitem+"' FROM LandLord WHERE LandLordID = '" + txtlandlordID.Text + "'";

 selectitem有这个列吗？？？