textBox输入时下边有提示信息

最新推荐文章于 2024-09-27 11:31:35 发布

sunzhengdsgl

最新推荐文章于 2024-09-27 11:31:35 发布

阅读量661

点赞数

分类专栏： C# 文章标签： textbox string object sql cmd

本文链接：https://blog.csdn.net/sunzhengdsgl/article/details/6288569

版权

C# 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

        private void textBox1_TextChanged(object sender, EventArgs e)
        {
            string SQl = "select soldto from region where soldto like '%"+textBox1 .Text .ToString ().Trim ()+"%'";
           // string SQl = "select soldto from region where soldto like '" + textBox1.Text.ToString().Trim() + "%'";
            DataTable dt = ReadTable(SQl);
            if (dt.Rows.Count > 0)
            {
                this.listBox1.Visible = true;
                this.listBox1.Items.Clear();
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    this.listBox1.Items.Add(dt.Rows [i][0].ToString ().Trim ());
                }
            }
        }

        public DataTable ReadTable(String strSql)
        {
            string strConn = " Data Source=IP;Initial Catalog=dbname;User ID=sa;Password=pwd"; 　　
            DataTable dt = new DataTable();
            SqlConnection Conn = new SqlConnection(strConn);
            Conn.Open();
            SqlDataAdapter Cmd = new SqlDataAdapter(strSql, Conn);
            Cmd.Fill(dt);
            Conn.Close();
            return dt;
        }

        private void listBox1_SelectedValueChanged(object sender, EventArgs e)
        {
            if (this.listBox1.SelectedItems.Count > 0)
            {
                this.textBox1.Text = this.listBox1.SelectedItem.ToString();
            }
        }