对access执行带参数的sql语句

最新推荐文章于 2023-05-01 23:57:48 发布

卢星

最新推荐文章于 2023-05-01 23:57:48 发布

阅读量975

点赞数 1

文章标签： access sql string cmd

本文链接：https://blog.csdn.net/luyanyao/article/details/2491217

版权

OleDbCommand cmd=new OleDbCommand();
string conn1 = LYY.DBUtility.DbHelperOleDb.connectionString;
OleDbConnection con = new OleDbConnection(conn1);

            cmd.Connection = con;
            string cmdText = "select * from yumingxinxi where yumingid = @Column1";
            cmd.CommandText = cmdText;
            OleDbParameter parameter=new OleDbParameter();
            parameter.Value = 2;
            cmd.Parameters.Add(parameter);
            con.Open();
            OleDbDataReader myReader = cmd.ExecuteReader();
            if (myReader.Read() == true)
            {
                label1.Text = myReader[4].ToString();
            }
            con.Close();