Oracle full text search with ASP.NET

First you need oracle full text search to be installed.

Then you have to create index on some field in table, this field can be any type: text, number or even file. Oracle text search supports pdf, doc,… and some other file types.

for example we have a table MyTable with following structure

Id number [...]

Oracle and SqlDataSource two way data binding

Often you have to create a simple pages for your website, for example admin pages which allow you edit tables through web. When working with Ms Sql server it’s a very easy task which you can solve with SqlDataSource and DataGrid. But using Oracle it’s difficult to make your page work without exceptions and you [...]

Calling Oracle stored procedures from SQLDataSource

For some simple pages in my application I prefer to use declarative manner of programming. To display some data on the page you can use this lines of code.

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ProviderName="System.Data.OracleClient"
SelectCommand="pac_dwh.Revew_item_info.GetAppPermissionInfoExt"
SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:QueryStringParameter Name="p_line_id"
[...]