Web Forms :: Make A Connection From Aspx Page To Oracle
Feb 21, 2010I want to setup a DB connection from aspx page and not from aspx.vb.
View 1 RepliesI want to setup a DB connection from aspx page and not from aspx.vb.
View 1 RepliesI am new in Asp.net with Oracle and not build proper connection in it.
View 2 RepliesI'm following this link [URL] to create a website and configure membership. I'm at the Configuring Membership section and try to use ASP.NET Configuration's Security tab. It has options for connecting to SQL server only. How can I configure it to connect to Oracle database? I want to create webparts and the instructions say it needs SQL server Express. I have VS2010 which comes with SQL Server 2008. I think that is even better. All my applications are using Oracle database.
View 7 RepliesI am new to .net, and I am having a problem that, I am having a couple of web pages which are accessed be two types of roles manager and users, my requirement is that any one with user rights should have only read only rights for a particular update.aspx page how can I do this
View 2 Repliesi had aspx page control for transferring the application datas to another web page. k when i click the transfer button. the Current page will be inactive. and the User only once time they can transfer the page otherwise disabled.
View 3 RepliesWhen I load my page I populate my repeater with the following code.
Dim conn As Data.SqlClient.SqlConnection
Dim Comm As Data.SqlClient.SqlCommand
Dim reader As Data.SqlClient.SqlDataReader
[code]...
need to setup a OLEB DB connection from aspx page and not from aspx.vb file.
View 4 Repliesi have created a custom aspx page whithin my sharepoint site with a sql server connection to a database on that server to select data when i view the page it works but when another user tries to view it it gives the following error :Server Error in '/' Application. Login failed for user 'GRINCORGuguK'.Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'GRINCORGuguK'.Source Error: The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:Add a "Debug=true" directive at the top of the file that generated the error. Example:
<%@ Page Language="C#" Debug="true" %>
or:2) Add the following section to the configuration file of your application:Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario. tack Trace:
[SqlException (0x80131904): Login failed for user 'GRINCORGuguK'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +248
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +245
[code]...
1)How to make Default.aspx page a Secure socket layer page?
2)How much code does this take?
3 Is it easy ? i have no idea how this works
Page (Picture.aspx) using a repeater displays the image --->
http://postimage.org/image/iyl7rv1g/After click on link Delete opens a new page (DeletePicture.aspx) andimages in the database set to passive stateand this page(DeletePicture) closes.How to make the images on page (Picture.aspx) refresh
and passive image is not visible.
I have a master page which includes a search textbox and a button which posts back to another page. The controls are defined as follows:
<asp:TextBox
ID="SearchTextBox"
runat="server"
style="margin-left:
0px"
Width="170px" />
<cc1:TextBoxWatermarkExtender
ID="SearchTextBox_TextBoxWatermarkExtender"
runat="server"
Enabled="True"
TargetControlID="SearchTextBox"
WatermarkCssClass="watermark"
WatermarkText="Search Name" />
<asp:Button
ID="SearchButton"
runat="server"
Text="Search"
PostBackUrl="~/SearchPage.aspx"/>
The problem is that for any other TextBox on the page which is using this MasterPage, for example the login page, if you type your user name and password and hit Enter, The page is redirected to the SearchPage. If you click on login buttton everything works fine. How do I make sure hitting enter on the page in any other text box does not post back to SearchPage.aspx?
I am currently working on the connection between ASP.NET and Oracle. I tried to search over the net and know there are many ways. Is there any 'normal practice' on which method to be used? Or it depends?
In the Web.Config
[code]...
we are facing a big problem while running our website on the production server. We decided to start using the connection pool. we added these statments to AppSettings section at the configuration file to provide the connection information to the DataAccess Layer class to access our Oracle Database.
<appSettings>
<add key="ConnectionString" value="Data Source=server;User ID=*******; Password=********; Validate Connection=true; Max Pool Size=200; Min Pool Size=10;Connection Lifetime=120; Connection Timeout=60; Incr
[code]...
I want to make ASPX page with textboxes and dropdown to insert the data into the database and Gridview to display all the data. I wnat some good designs, how can I make the page more attractive with just textboxes,dropdown ,buttons and gridview.
Do somebody have good aspx page, paste just the design here.
We have been getting this Oracle connection pool exception a lot recently for our ASP.NET website. This is the detailed exception message:
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
This is our connection string
User ID=user1;password=password1;DATA SOURCE=Datasource1
how to set max pool size to 1 so that I can debug it on my local?
what is the recommended pool size for a website with 10,000 users?
I am connecting to Oracle database from .net using OLEDB.
My Connection string :
[Code]....
I am using above ConnectionString to communicate with database. To make it work, I have to store password (don't want to do that) in session and use it every time I need to talk to db.
1) Is there any other connection string without username and password with oledb?
2) I use "Integrated Security" for MSSQL. How can I use the same with OLEDB - Oracle database?
string sConnectionString = "Provider=OraOLEDB.Oracle;"
I've created a C# function which extracts data from an mssql database, formats it to a json string and returns that. Now I need to make a call from my javascript (jQuery) slider through an aspx page that is related to the C# code file. I have actually never done anything like this before, from what I could tell by googling I need to use xmlHttpRequest, but how exactly do I make the function get hold of this string? It would be awesome if someone had some example code that shows how this works.
View 2 RepliesI am starting a new project where I have to use oracle and asp.net. Oracle 11 enterprise edition. Problem is oracle database reside in linux server and application server is in windows. My question is1. Is there any problem connecting oracle from asp.net?
View 1 RepliesI am developing logging application with asp.net & vb.net & OracleAt present I'm using this mechanism to write logs
Method1 Connect (
Try{
Conn.open ()
[code]...
How to make a reference to public const string from aspx page with c#
In VB its <% = MY_DATA%>
I want to make a deployment package for my asp.net 3.5 application. Actually i have to send this to my client who would run this application on his intranet. I tried setup n deployment package type project and it created .msi file.while installing this it create all the files which are lying in the project application. But i want to send all the files in complied format only not directly code files.
How could i convert the aspx.cs files into nonreadable complied files..
I build my website in jquery manner. On document-complete I request data from server (by page method) and put it into html by jquery template. So, I wonder, would this HTML be visible to Search engines crawlers? And if not, how to make it visible? Is there a common solution? Or is it a great disadvantage if jquery?
View 3 Repliesi 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]....
How to connect to different data providers(Say Oracle and SQL Server) using single connection string?
View 1 Replies