DataSource Controls :: Use Webconfig Connectionstring In Reportviewer?

Jan 13, 2010

In my project i use in webconfig

<appSettings> add
key="ConnectionString"
value="server=192.168.0.1;database=database;uid=usr;pwd=;"/>
</appSettings>

Use this key on .vb page -

Public constr As
String = ConfigurationSettings.AppSettings("ConnectionString")
dim cnn As new SqlConnection(constr)

Now i need to create conditional report where user select parameters from Dropdownlist and based on that Report is generate on web page. I tried so much with the help of

http://www.aspfree.com/c/a/ASP.NET/Binding-Data-to-the-ReportViewer-Control-Dynamically-in-ASPNET-20/1/ article but noluck. The data is display when i select the SELECT query from wizard while add dataset, but i want to do it dynamically coz webserver is located somewher else. Configuration is MSSQL server 2000, W2K3, VS 2005 Professional.

I did a Crystalreport projects with vb6 with ado but i really dont know how to exactly dynamically generate conditional report in Reportviewer.

View 2 Replies


Similar Messages:

DataSource Controls :: Set ConnectionString From Code?

Sep 13, 2010

I have 2 connection strings in my web.config file, and I would like to select which one to use, from code.Currently I have this:

asp:SqlDataSource
ID="SqlDataSourceDelegateServices"
runat="server"

[code]...

View 3 Replies

DataSource Controls :: Use ConnectionString In New SQLConnection?

May 22, 2010

Is it possible to use a pre-existing ConnectionString in this construction?

myConnection = New SqlConnection("server=localhost;" & "database=pubs;Trusted_Connection=Yes")

Regards -Penn

View 3 Replies

DataSource Controls :: The ConnectionString Property Has Not Been Initialized?

May 26, 2010

i am trying to call a SP from SQL Server in asp.net app, but it keep crashing every time it hit

'cmd.Connection.Open();' ,,, it give me this message

"The ConnectionString property has not been initialized "

[Code]....

[Code]....

View 2 Replies

DataSource Controls :: Create ConnectionString Using SQL DataReader

Sep 11, 2010

why this first connection works but the second doesn't?

[Code]....

I'm trying to use <asp:FileUpload> to upload images and as far as I know you have to use <asp:SqlDataSource> to do it but I need to create the connections string using entries stored in a database.

View 2 Replies

DataSource Controls :: Set Up Connectionstring At Runtime From Web.config - MySQL?

Jul 7, 2010

I want to setup the connectionstring of the SqlDatasource of a dropdown list at runtime, eg. Page Load event. I have install MySQl ODBC driver, System DSN name as "MySQL_Employee" If I have an entry in Web.config:

<connectionStrings>
<add name="mysqlConnection" connectionString="DSN=MySQL_Employee;UID=john;description=connection to employee database;server=empServer;database=employee;port=3306;" providerName="System.Data.Odbc"/>
</connectionStrings>

View 1 Replies

DataSource Controls :: ConnectionString - Login Failed For User

Mar 12, 2010

my web-app working well locally, but since i uploaded it and my DB, i keep receiving this Error :

Login failed for user 'XXXXX'.

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 'XXXX'.

Source Error:

[Code]....

Stack Trace:

[Code]....

[SqlException (0x80131904): Login failed for user 'XXXXX'.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846887 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +35 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +144 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +342 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +221 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +31 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +433 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +499 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117 System.Data.SqlClient.SqlConnection.Open() +122 news.dg_bind() +95 news.Page_Load(Object sender, EventArgs e) +5 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +50 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

Version Information: Microsoft .NET Framework Version:2.0.50727.3603; ASP.NET Version:2.0.50727.3082

I checked my Username , Password and its Permissions for thousands time, and everything seems to be alright. I developed the Website by ASP.Net / C# (VS2008) and SQLServer2008 and I guess the problem is with ConnectionString, below you can find my ConnectionString:

Server=(local)SQLEXPRESS;User ID=myusername;password=mypass;Database=mydb;Persist Security Info=True

View 5 Replies

DataSource Controls :: Encrypted Connectionstring And Store At Web.config File?

Jan 19, 2011

I encrypted my connectionstring and store at web.config file. Then I bind Gridview with sqldatasource control, cannot bind because of sqldatasource don't know the(encrypted) connectionstring.

View 5 Replies

DataSource Controls :: Setting A Typed DataSet (xsd) Connectionstring Dynamically?

May 25, 2010

I'm trying to set up a simple content management system for two different sites, which are both stored on the same server (my own, not hosting, if it matters:)).

Both sites are basically the same, built upon a similar (but seperate) xsd (Typed DataSet) file, and read data from different databases using the tableadapters in the xsds.

Obviously, i have the same xsd setup in my management system application that need to hook up to the relevant database (after user authentication) and use the tableadapters to access the data and allow the forms in the management system to modify the data.

When i had a single site, the connection string was stored in the web.config file and after logging in to the management system, all forms could access the database.

Now i have two site and i need to setup the connection string in the xsd dynamically after user validation based on the relevant site to edit.

My question is, how do i set the xsd's connection string dynamically (after user logs in, the function returns the specific connectionstring and stores it in a Session variable)

View 3 Replies

How To Change The Datasource In The Reportviewer

Feb 24, 2010

There are several reports in the reportserver which are using a single dataSource. I am now using the asp.net reportviewer to view the reports on the report server. I now would like to change the datasource in the reportviewer so that depending on the passed in datasource, then the reports point to the correct datasource.

View 5 Replies

SQL Reporting :: Dynamically Setting Reportviewer Datasource

Aug 2, 2010

I have a vb.net web site. Currently it is generating reports via ReportViewer. The datasouce for the all reports is set at the deploying of the report.

ReportViewer is configured in the aspx page
<rsweb:ReportViewer ID="myReportViewer" runat="server" ShowParameterPrompts="true"
ZoomMode="Percent" Height="1100px" Width="1000px" BorderWidth="1">
</rsweb:ReportViewer>

I am setting up the ReportViewer using the following code.

Dim _cred As New ReportServerCredentials(Session("_ApplUser"), Session("_ApplPswd"), Session("_ApplDom"))
'Set the processing mode for the ReportViewer to Remote
myReportViewer.ZoomPercent = 100
myReportViewer.Width = Unit.Percentage(100)
myReportViewer.Height = Unit.Percentage(100)
myReportViewer.ProcessingMode = ProcessingMode.Remote
Dim _SrvRpt As ServerReport
_SrvRpt = myReportViewer.ServerReport
_SrvRpt.ReportServerCredentials = _cred
'Set the report server URL and report path
_SrvRpt.ReportServerUrl = New Uri(Session("_RSConn"))
_SrvRpt.ReportPath = Session("_RSFold") + _rr.Report_Path
myReportViewer.ServerReport.Refresh()
lblTitle.Text = _rr.Report_Title
myReportViewer.ServerReport.Refresh()
myReportViewer.Visible = True

What I want to do is dynamically set the datasource for a report at runtime. That is, I have 2 datasources already configured in my Report Manager. I want to have the vb.net pick which datasource based on a enviornment variable. So, if Env 1, then use Datasource 1 in the Report Manager. Of Env 2 then use Datasource 2 in the Report Manager. I have seen what looks like software for doing this Locally but no for Remote.

View 5 Replies

Crystal Reports Reportviewer - Set Datasource Dynamically Not Working?

Mar 25, 2010

I'm running CR XI, and accessing .RPT files through a ReportViewer in my ASP.NET pages. I've already got the following code, which is supposed to set the Report Datasource dynamically.

rptSP = New ReportDocument
Dim rptPath As String = Request.QueryString("report")
rptSP.Load(rptPath.ToString, 0)
Dim SConn As New System.Data.SqlClient.SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings("MyConnectionString").ConnectionString)
rptSP.DataSourceConnections(SConn.DataSource, SConn.InitialCatalog).SetConnection(SConn.DataSource, SConn.InitialCatalog, SConn.UserID, SConn.Password)
Dim myConnectionInfo As ConnectionInfo = New ConnectionInfo
myConnectionInfo.ServerName = SConn.DataSource
myConnectionInfo.DatabaseName = SConn.InitialCatalog
myConnectionInfo.UserID = SConn.UserID
myConnectionInfo.Password = SConn.Password

'Two new methods to loop through all objects and tables contained in the requested report and set
'login credentials for each object and table.
SetDBLogonForReport(myConnectionInfo, rptSP)
SetDBLogonForSubreports(myConnectionInfo, rptSP)
Me.CrystalReportViewer1.ReportSource = rptSP

But when I go into each .RPT file, and open up the Database Expert section, there is obviously still servernames hardcoded in there, and the code listed above doesn't seem to be able to change the servernames that are hardcoded there.

I say this because I have training and production environments. When the .RPT file is hardcoded with my production server, and I open it on my training server with the code above (and the web.config has the training server in the connection string), I get the ol:

Object reference not set to an instance of an object.

And then if I go into the .RPT file, and change over the datasource to the training server, and try to open it again, it works fine. Why doesn't the code above overwrite the .RPT files datasource?

How can I avoid having to open up each .RPT and change the datasource when migrating reports from server to server? Is there a setting in the .RPT file I'm missing or something?

View 2 Replies

Forms Data Controls :: Set Dynamic ConnectionString In Gridview?

May 23, 2010

I am using vs 2005, I have below connection string in web.config.

[Code]....

View 1 Replies

Forms Data Controls :: Creating A SQL Connectionstring For The Web Config And Textsearches?

Jul 24, 2010

am having problems creating this;1. How to create a add a connectionstring to my web config fileThis is the connection string I have entered

Datasource=.SQLWEXPRESS; attachDb filename=c:inetpubwwwrootdevelopment_ecommerceApp dataextratime.mdf;integrated security=true; user instance true

I have tried to enter this as well

<connectionStrings>
<add name="development_Ecommerce" connectionString="Data Source=smbc-652263fbfaSQLEXPRESS;Inital Catalogue=extratime; Integrated Security=True" providerName="System.Data.SqlClient"/>

[code]...

View 3 Replies

SQL Reporting :: Can A ReportViewer Control Have Sqldatasource Control As Datasource

Dec 16, 2010

I have a Reportviewer with Objectdatasource as default datasource.

However I want the report to have a datasource with parameter depending on the label.text value so sqldatasource is ideal for this. However I dunno how to set the reportviewer datasource as sqldatasource control.

View 2 Replies

Obtaining Information From The Webconfig?

Jul 6, 2010

I have certain information in my webconfig such as the name of the database i am connecting to. However, I would like a situation where my aspx is able to obtain that information as well and display it in a label. Hence, how do I go about doing that.

View 3 Replies

Webconfig Is Same For Multiple Users Or Different?

Apr 19, 2010

Does Webconfig in asp.net is same for Multiple Users or diffrent?

View 2 Replies

Security :: Authentication Mode On Webconfig?

Oct 19, 2010

I have an ASP.net website running with the authentication mode on the web.config file is Windows. The webpages at the root do not need to have login & password form.

Now I created a subfolder called 'reports' and would like to implement a few web pages with the login & password authentication form.

Question, do I need to create another web.config file in the 'reports' folder and update the authentication mode="Forms"?

View 2 Replies

Security :: Alphanumeric Required But Webconfig Set To 0?

May 27, 2010

I specified to have a user creation wizard that accepts a password with NO alphanumeric characters:

<add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="watermeConnectionString" enablePasswordRetrieval="false" enablePasswordReset="true"
requiresQuestionAndAnswer="false" applicationName="/" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="5" passwordAttemptWindow="10" passwordStrengthRegularExpression="(?=.{6,})[a-z]+[^a-z]+|[^a-z]+[a-z]+"
minRequiredNonalphanumericCharacters="0"/>

still, I do get the error that I have to provide at least one alphanumeric character.I do so and the error is still the same.why? is my regex wrong? I also took out the "confirm password" step. is that ok?

[Code]....

View 1 Replies

Web Forms :: Set Pooling / False In Webconfig?

Mar 5, 2010

I'm not having much fun with connection pooling. The website I've written does dip into the SQL server all the time and quite a lot of times per page. Every time I nip into the SQL Server to get or set something I open a connection...

comGeneral.Connection.Open()

... do or get what I need and then close it. From what I've read any of the following should close the connection and return "one connection" (?) to the pool (top one, only if reading)....

rdrGeneral = comGeneral.ExecuteReader(Data.CommandBehavior.CloseConnection)
comGeneral.Connection.Dispose()
comGeneral.Connection.Close()

... but that's not really working for me and I keep hitting the default max 100 open pools. So I've been doing all 3 of the above (again, top one, only if reading). But alas, still the stupid thing (Yes, I am aware I'm the stupid one) keeps hitting the max.

My new plan is to set pooling to false (pooling = false ?) across the entire website and take the performance hit which wont be terrible because I don't really do anything too demanding. Trouble is I don't know how, other than setting Pooling = False, but where exactly in the webconfig would this bit of code go?

View 7 Replies

Configuration :: Integrating Webconfig From Working App Into Another App?

Aug 22, 2010

I have a website application which performs a function which I need to integrate into my main website application. Right now I'm getting errors as I copy and paste the parts of the web.config file from the working app into my main app. When I just paste in the assemblies, I get 2 errors. I'm just going to just paste both of them here and if you think you integrate them, I'd really appreciate it if you would paste it here in the thread.

[Code]....

And here is the one I'm trying to integrate into the one above:

[Code]....

View 1 Replies

Security :: Encypting Webconfig Before Deployment?

Mar 12, 2010

Hows does one encypt and decypt: appsettings, machinekey, connectionstring?

View 5 Replies

Encrypt Connection String In Webconfig?

Mar 5, 2010

How to encrypt connection string in web config.

View 5 Replies

Security :: Webconfig - Website Not Working On Production Env

Oct 19, 2010

I have created the asp.net application and Hosted on Different Server(i.e Test,Development). its is an Intranet Application But When I tried to Host on Production the WebApplication dont work when I check the "Integerated Authentication" and when I check the "anonymous Access" i get null value for the HttpContext.Current.User.Identity.Name.ToString() returns null. and User.Identity.IsAuthenticated also return false. what changes do I have to make in IIS and Webconfig of my application so that it can run on ProductionSERVER

View 2 Replies

Calling Connection String From Webconfig File?

Jun 9, 2010

I'm using Visual Studio 2008 and SQL Server 2008 Developer to create a website.

I'm trying to test a connectino to a local database in my computer.

What I did is create a connection string in the webconfig file like this:

[Code]....

Then I want to call that connection string like this in the default.aspx.cs file I write the following code:

[Code]....

I'm not getting any error or warning in any of the code but when I run the page I throws me an error telling me:

The connectionstring property has not been initialized.

If I run with debug on it shows this:

[Code]....

Line 22 in red.

I don't know what I'm doing wrong since VIsual Studio does not tell me there is an error, it just seems like it cannot make the connection.

View 4 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved