I have a query with a where clause that looks like:
WHERE field IN ( 1, 2, 3 )
Is possible to parametrize this so it looks something like:
WHERE field in ( :list )?
How do you create the :list parameter, assuming it's a list of ints, that could be anywhere from 1 to 10 ints?ASP.net, webforms if that makes a difference.
I have a WebTest that simply opens a login page, inputs a userid/password and logs in.I need this test to user a list of ten userid/password combinations.
I've already recorded this event and the Form Post Parameters display a userText and pwText entry. I assume I do something with those to accomplish that. I just don't know what.
We have a site that is runnig II7 64 bit with the oracle .net 64 bit provider, when I try and open this in web developer 2010 express (I'm running windows 7 pro 64bit) it says it can't load the oracle dll as its an incorrect format. I got the impress that web developer 2010 was 64bit capable.
Ofcourse this is extremly annoying as I don't get any syntax formatting for the project or intellisense.
We have a row of aspx code that lists employees and hours worked and total hours. The text is quite simple and uses ajax to update the entries when the user selects a control for employees or enters hours worked on a particular project.
Currently, we have "hard coded" these lines of code. It works fine, but is quite tedious to change when requested. The difference between row1 and row2 is minimal. Just some control name differences such as
dlEmployees1 and ddlNrOfHoursWorkedRow1Col1, ddlNrOfHoursWorkedRow1Col2, ddlNrOfHoursWorkedRow1Col3, ..., lblTotalHoursRow1
on one row, and then
dlEmployees2 and ddlNrOfHoursWorkedRow2Col1, ddlNrOfHoursWorkedRow2Col2, ddlNrOfHoursWorkedRow2Col3, ..., lblTotalHoursRow2
on the next row. Etc.
Our first goal is to re-write one of these lines into something like an array that can be similar to dlEmployees[j], ddlNrOfHoursWorkedRow[j]Col1 and lblTotalHoursRow[j]
so we can add and reference the different drop down boxes in the c# code.Below is the actual code for 2 lines (sorry for the long post).
==================== code follows for 2 sample lines =====================
<!-- Drop Down Lists for Employee Names (1st Employee Row) (Row Nr 7 of Table) -->
[code]....
I'm getting ready to do a new project and I want to use MVC and WCF, though the backend database is Oracle. Everything I'm seeing is using it against SQL 05 or 08 (mostly 08). So my question is,can I use MVC and WCF to go against an Oracle data?
View 2 RepliesI am new to ASP.NET and Oracle. I was looking for a book that will provide step by step guide to develop asp.net applications with oracle database.
View 3 RepliesI'd like to know if there are any good EF providers for Oracle out there, and more specifically what experiences people have had with them. We're looking for a provider that is either free or paid for, but I'm struggling a bit with finding any real opinions on what the different frameworks are like to work with in a production environment.
EDIT,I should clarify that we are using Oracle 11g.
I am working on NHibernate with oracle in ASP.Net. Now i am trying TDD(Test Driven Development). Can you tell me the best way to develop the TDD for NHibernate with oracle?I am using MbUnit with microdesk but it is not better approach for oracle but SQL server.
View 1 RepliesOne customer is asking me if it is possible to access an Oracle database from his .NET website using VPN. I googled around and didn't find much on this subject.
View 4 RepliesI would like to connect oracle via ODBC. I downloaded the dll and add as reference.
Here is the sample code:
Dim cn As OdbcConnectioncn = New OdbcConnection("PROVIDER=MSDAORA; DATA SOURCE=aaa; USER ID=aaa; PW=aaa;")
But getting this error "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
how we can use oracle 10g in asp.net 3.5 using toad
View 1 Replieshow to create model using oracle 10g
View 5 RepliesAs the title says I have a Win 7 64 bit dev machine, Win 2K3 32 bit production box and I run against Oracle 10g which Oracle clients do I need to run? Do I need to run the Oracle 32 and 64 bit clients? And if so what versions?
View 1 RepliesI need to find a way to connect to the remote Oracle server without a DSN. There are some practical problem for accessing the server using a DSN. I need a way to connect to Oracle server like I connect to SQL Server etc. For example, in SQL server, I can connect directly with server using Servername (IP adress) + Username + Password + DB Name. Any way to connect to the Oracle server like in SQL Server we do ??
View 6 RepliesIn my project, I have a database in SQL which was working fine. But now I have to make the application support oracle db too.
Some limitations I found out was that in Oracle, there is no bit field and the table name cannot be greater than 30 char. Is there any other limitation that I need to keep in mind.
I have an Asp.net web application targeting .Net2.0 and my databse is oracle, I used SqlDataSource Control to communicate with oracle database its working fine on my development server, but on my production Oracle is 64 bit so im getting an error like
"<asp:ControlParameter doesnot have a property DbType="Int32"> "
i tried with Int64 also but still im getting the same error
following is the markup of sqldatasource i used
<
asp:SqlDataSource
ID="sdsEmployees"
runat="server"
ConnectionString="User Id=user;pwd=user1;server=prod" ProviderName="System.Data.OracleClient"
SelectCommand="GetEmployeeInfo" SelectCommandType="StoredProcedure"
OnSelecting="sdsEmployees_OnSelecting">
<SelectParameters> <asp:ControlParameter
ControlID="txtNumber"
DbType="Int32"
/> </SelectParameters> </asp:SqlDataSource>
How do I connect to an Oracle 11g database using asp.net3.5? what is the name space and how to write connection string in web.config file?
View 1 Repliestried to use linq to oracle 10g express but it throws an error as I can make no errors because I throw
View 1 Replieshave a sp in oracle which has 3 input parameters and 3 output parameters( 1 ref cursor, i number, 1 varchar2)
Command.CommandText = sp name;
Command.CommandType =
CommandType.StoredProcedure;
i am doing cmd.ExecuteNonQuery();I am able to get the number and varchar2 values from output parameters. But i am unable to get output from Ref Cursor. (How can i get this...)If i use dataadaptor then i am getting the datatable in the dataset(but i am not getting the other two parameters(where will get the other two??)...
Is required to install Oracle client software to connect Oracle DB?
As following code will generate exception, prompt:"System.Data.OracleClient requires Oracle client software version 8.1.7 or greater."
using System.Data.OracleClient;
string dataSource ="(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=addr)(PORT=pt))(CONNECT_DATA=(SERVICE_NAME=svc)))";
string connectionString=string.Format("Data Source={0};User Id={1};Password={2};",dataSource,"id","pwd");
using (OracleConnection connection=new OracleConnection(connectionString))
{
connection.Open();
}
Let me start with the fact that I am fairly new to ASP.net. I have a very well estabilished Oracle database. I am working on an ASP page that will connect to the database and return the data. Nothing special there. I start having problems when trying to establish the security. All users that will be defined in my ASP page already have an Oracle login. This login has quite a lot of security already built into it. For instance a user can only see orders that would belong to their company, and inside that they may only be able to see products that they have access to. All of this secuirty is built in another application, and applied to our Oracle tables. I was thinking that maybe I could just ask them for their login information to Oracle, then validate that the account is active. Store that info in a session variable (I think that is right term), then when they request data login using their information. I have read a couple of posts that say this is not the way you should do it, and that every user should have their own ASP login and 1 generic login to go to Oracle. Can anyone give me pro's and con's of doing it either way. Also if the best way is to get the users into ASP, then what is the best way to make sure the 2 systems stay inline with as little manual effort as possible. For instance a person may move withing a company. How do I keep from having to change that secuirty in the Oracle side and the ASP side?
View 13 RepliesCan I use oracle 9i or 11g database with Entity Framework?
View 1 RepliesWe have been really tired lately dealing with all bugs that comes out of ODP.Net and the lag time to bring out any new product out. I am looking for ado.net provider for oracle and looking for the following:
1. Entity Framework
2. Linq
3. Good support (in case we run into issues)
4. Quick response to open issues
5. Quick updates and new releases
I looked at datadirect and dotConnect by DevArt...But I am not sure if any one is better than other.
I m working on A Ware house management Software.
I have used oracle in back end. I have goodsmaster table, sales return table, sales table, invoice table,etc
So i have to update qty on stock when i enter any entry in my sales return page of asp.net from goods master table..
i have a SQL Query. It works fine in Sql server. let me know how to make it work in Oracle.
You can run below code in Sql server and check. It will work fine. But in Oracle,( I am using TOAD for Oracle )it is giving some errors.
Code]....