c#查询参数化例子

来源：互联网发布：知先生风水命理的博客编辑：程序博客网时间：2024/04/29 21:58

--Web.Config 配置

---页面绑定代码:(查询参数化)

String DBConnStr;
   DataSet MyDataSet=new DataSet();
   TextBox1.Text ="'2";
   System.Data.SqlClient.SqlDataAdapter DataAdapter=new System.Data.SqlClient.SqlDataAdapter();
   DBConnStr=System.Configuration.ConfigurationSettings.AppSettings["MessageBoardConn"];
   System.Data.SqlClient.SqlConnection myConnection = new System.Data.SqlClient.SqlConnection(DBConnStr);
   if (myConnection.State!=ConnectionState.Open)
   {
    myConnection.Open();
   }
   System.Data.SqlClient.SqlCommand myCommand = new System.Data.SqlClient.SqlCommand("select   * from TB_B_Zixun where Oid=@id",myConnection);
   myCommand.Parameters.Add("@id",SqlDbType.Int );
   myCommand.Parameters["@id"].Value =2 ; //参数化赋值
   myCommand.ExecuteNonQuery();
   DataAdapter.SelectCommand = myCommand;
   if (MyDataSet!=null)
   {
    DataAdapter.Fill(MyDataSet,"table");
   }
   DataGrid1.DataSource=MyDataSet;
   DataGrid1.DataBind();
   if (myConnection.State == ConnectionState.Open)
   {
    myConnection.Close();
   }

---页面绑定代码:(更新参数化)

   System.Data.SqlClient.SqlCommand myCommand = new System.Data.SqlClient.SqlCommand("update TB_B_Zixun set ParentID=@ParentID where Oid=@id",myConnection);
   myCommand.Parameters.Add("@id",SqlDbType.Int );
   myCommand.Parameters["@id"].Value =56; //参数化赋值

myCommand.Parameters.Add("@ParentID",SqlDbType.Int );
myCommand.Parameters["@ParentID"].Value =2; //参数化赋值

myCommand.ExecuteNonQuery();

   if (myConnection.State == ConnectionState.Open)
   {
    myConnection.Close();
   }