//连接Oracle数据库的连接字符串

         string connectionString = @"Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)

                                     (HOST=localhost) (PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=TestDB)));

                                     User Id=developer; Password=developer";

 　　　　　

         /// <summary>

         /// 制作商品查询页面 条件：根据商品名称模糊查询

         /// </summary>

         /// <returns></returns>

         public ActionResult product(string ProName)

         {

             /*法一、直接使用like模糊查询

              string sql = "select * from product where chvProName like '%' || upper(:ProName) || '%'";

             */

             //法二、使用concat函数查询

             string sql = "select * from product where chvProName like concat(concat('%', upper(:ProName)), '%')";

             ViewBag.name = ProName;

          //使用OracleHelper辅助类

             DataSet ds = OracleHelper.ExecuteDataset(connectionString, CommandType.Text, sql,

                 new OracleParameter(":ProName", OracleType.NVarChar) { Value = ProName});

             return View(ds.Tables[0]);

         }

//连接Oracle数据库的连接字符串
string connectionString = @"Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)  
　　　　　　　　　　　　　　　 (HOST=localhost) (PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=TestDB))); 
　　　　　　　　　　　　　　　　User Id=developer; Password=developer";
protected void Button1_Click(object sender, EventArgs e)

        {

            string proName = this.txtProName.Text.Trim();

            /*法一、直接使用like模糊查询

              string sql = "select * from product where chvProName like '%'|| upper(:proName) ||'%'";

            */

            //法二、使用concat函数查询

            string sql = "select * from product where chvProName like concat(concat('%', upper(:proName)), '%')";

            OracleConnection connection = new OracleConnection(connectionString);

            OracleCommand cmd = new OracleCommand(sql, connection);

            cmd.Parameters.Add(new OracleParameter(":proName", proName) { OracleType = OracleType.NVarChar });

            OracleDataAdapter adapter = new OracleDataAdapter(cmd);

            DataSet ds = new DataSet();

            adapter.Fill(ds);

            this.GvPro.DataSource = ds.Tables[0].DefaultView;

            this.GvPro.DataBind();

        }