Visual C#通用模塊開發：后臺管理員模塊[2]

關鍵字：c#objCommand.CommandText += " AND USERS.NICKNAME LIKE @NICKNAME";
            // 設置Sql語句參數類型
            objCommand.Parameters.Add("USERNAME", SqlDbType.VarChar);
            objCommand.Parameters.Add("NICKNAME", SqlDbType.VarChar);
            // Sql語句參數賦值
            objCommand.Parameters["USERNAME"].Value = "%" + tbxUserName.Text.Trim() + "%";
            objCommand.Parameters["NICKNAME"].Value = "%" + tbxNickName.Text.Trim() + "%";
            //這里使用DataAdapter和DataSet獲取數據
    DataSet objDataset = new DataSet();
            SqlDataAdapter objAdapter = new SqlDataAdapter(objCommand);
            try
            {
                // 打開數據庫連接
                if (objConnection.State == ConnectionState.Closed)
                {
                     objConnection.Open();
                }

原文轉自：http://www.kjueaiud.com