首页 > 数据库技术 > 详细

C# SQL占位符

时间:2014-03-27 10:07:13      阅读:753      评论:0      收藏:0      [点我收藏+]
bubuko.com,布布扣
            string connString = ConfigurationManager.AppSettings["SqlConn"].ToString();
            var conn=new SqlConnection(connString);
           
            //var cmd = new SqlCommand("SELECT alliance,ballid FROM talliance with(nolock) WHERE type=8 AND alliance like ‘%‘+@alliance;");
            var cmd = new SqlCommand("SELECT alliance,ballid FROM talliance WHERE type=8 AND alliance like ‘‘+  @alliance +‘%‘;");
            cmd.Parameters.Add(new SqlParameter("@alliance", SqlDbType.NVarChar, 1000));
            //cmd.Parameters[0].Value = "||ATP Sydney international match";
            cmd.Parameters[0].Value = "ATP 悉尼國際賽||";
            cmd.Connection = conn;
            conn.Open();
            var dr =  cmd.ExecuteReader();
            while (dr.Read())
            {
                Console.WriteLine("alliance:"+dr[0].ToString() +"---"+"ballid:"+dr[1].ToString());
            }
            dr.Dispose();
            conn.Close();
            Console.ReadKey();
bubuko.com,布布扣

C# SQL占位符,布布扣,bubuko.com

C# SQL占位符

原文:http://www.cnblogs.com/dennys/p/3624760.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!