将sql语句执行结果填充至textBox

最新推荐文章于 2021-07-25 00:26:51 发布

雷朝栋

最新推荐文章于 2021-07-25 00:26:51 发布

阅读量1k

点赞数 2

本文链接：https://blog.csdn.net/weixin_45137949/article/details/103380285

版权

        private void button2_Click(object sender, EventArgs e)
        {
            string kmbm = "1";
            string fzhsmc = "1";
            string je = "1";
            string sql1 = "SELECT count(xsz.xz_bqdfje) FROM xsz WHERE instr(xsz.xz_kmbm, '" + kmbm + "')= 1 and xsz.xz_bqdfje != ''  and xsz.xz_bqdfje > " + je + " AND xsz.xz_bqdfje != ''  AND instr(xsz.xz_fzhsmc,'" + fzhsmc + "')> 0";
            using (SQLiteConnection conntion1 = new SQLiteConnection(ConnString))
            {
                conntion1.Open();//打开数据库连接
                SQLiteCommand cmd = new SQLiteCommand();
                cmd.Connection = conntion1;
                cmd.CommandText = sql1;
                SQLiteDataReader sre = cmd.ExecuteReader();//开始读取数据
                sre.Read();//读取数据
                textBox1.Text = sre[0].ToString();//“0”需要填充的值所在的行
            }

        }

        private void textBox1_TextChanged(object sender, EventArgs e)
        {

        }