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]....
I have some Class A, which is data-layer in my web-application, and I'm using A's methods to accomplish Db operations. It looks like this.
[code]...
In case when my .aspx page calls 2 methods of class A during the postback, my page throws
"The ConnectionString property has not been initialized" exception for second method call.
I tried to put _sqlcon initialization into constructor, but it still throws exception.
I am trying to setup my page with a drop down which value comes from one SQL query and item list comes from another SQL query to the same database...
what I want to do is:
read 1 line from bugs table. this line includes a projectid which will be the value of the drop down. I also read the projects table for active projects/id and load this as drop down items....
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
conn.Open();
using (SqlCommand bug = new SqlCommand(
"SELECT bugs.id, bugs.projectid, bugs.typeid, bugs.subtypeid, bugs.version, bugs.summary, " +
"users.email AS creator, bugs.createddate, bugs.text, bugs.closeddate, bugs.history " +
"FROM bugs INNER JOIN users ON bugs.creatorid = users.id WHERE (bugs.id = @idd)", conn))
{
bug.Parameters.AddWithValue("idd", Request.QueryString["ID"]);
try
{
SqlDataReader reader = bug.ExecuteReader();
if (reader.Read())
{
String projectid = reader[1].ToString();
// read project name list...
using(conn) using (SqlCommand projects = new SqlCommand("SELECT name, id FROM projects WHERE active=true"))
try
{
SqlDataReader pr = projects.ExecuteReader(); // This line causes the exception... what am I doing wrong?
while (pr.Read()) project.Items.Add(new ListItem(reader[0].ToString(), reader[1].ToString()));
}
catch { }
In some posts I have read on other forums, those with database connection problems (I am thinking about Access) sometimes get the error: 'Connection property has not been initialized' which might translate as 'you have not kick-started your connection'. One reason for that, according to a number of replies I have come across, is that 'you have not set the connection property of the command object' ('you have not told command how to connect').
So would something like this:
Code:
Dim conn As New OleDbConnection
Dim OleDbConnection As New OleDbConnection
Dim cmd As New OleDbCommand
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|myDatabase.mdb;"
conn.Open()
cmd = New OleDbCommand("SELECT strName FROM school WHERE strName=@strName", conn)
cmd.Parameters.AddWithValue("@strName", UserName.Text)
cmd.Connection = conn
cmd.ExecuteNonQuery()
conn.Close()
a) initialise the connection property and b) set the connection property of the command object?
I am getting error ExecuteReader: Connection property has not been initialized. below is the code i am using.
SqlDataReader oReader = new SqlDataReader();
string sSQL = @"
WITH TAB_CTE AS (
SELECT fbominum, fbompart, fparinum, flevel, fsono
FROM sodbom
WHERE fbompart= @fbompart and fsono = @fsono
UNION ALL
SELECT e.fbominum, e.fbompart, e.fparinum, e.flevel, e.fsono
FROM sodbom e
INNER JOIN TAB_CTE ecte ON ecte.fbominum = e.fparinum where e.fsono = @fsono
)
SELECT *
FROM TAB_CTE where fbompart <> @fbompart
";
SqlCommand oCommand = new SqlCommand(sSQL, this._connection);
oCommand.CommandType = System.Data.CommandType.Text;
oCommand.Parameters.Add("@fbompart", ItemSODBOM.fbompart);
oCommand.Parameters.Add("@fsono", ItemSODBOM.SONO);
oReader = oCommand.ExecuteReader();//Here I am getting error
I have been looking through the event viewer on our server and can see quite a few people with this error but I can't replicate this myself but it is causing issues for people viewing our website is there anyway I can "initialize" Command Text property?
UPDATE
So I have this query
datelistquery = "SELECT DISTINCT property_id, ' - Sleeps ' + cast(number_slept as varchar) as combsleeps, number_slept FROM openquery ("+Application("hpbDsrc")+",'SELECT property_id, number_slept FROM web_details WHERE part_full_flag = ''F'' AND location = ''"&Session("TenChosenLocCode")&"'' AND property_id = ''"&Session("passedPropId")&"'' AND pets_yn like ''"&Session("TenPets")&"'' AND number_slept >= ''"&Session("TenAdults")&"'' AND year_week = ''"&Session("TenHolStDateHP1")&"'' AND on_hold = ''NO'' AND booked = ''NO'' ') ORDER BY number_slept, property_id"
So should I put at the start sqlCommand.CommandText(datelistquery) = "Select Distinct...."
protected void Button1_Click(object sender, EventArgs e)
{
SqlCommand cmd;
[code]...
I am getting error that ExecuteReader: Connection property has not been initialized
I am getting above mentioned error when I try to run the following code:
Private strConnString As String = ConfigurationManager.ConnectionStrings("conString").ConnectionString
Private con As New SqlConnection(strConnString)
Private pID As Integer
'FIRST SECTION
Dim query As String = "query"
Dim cmd As New SqlCommand(query)
[Code] .....
The error is coming from the second SQL cmd but if I comment out the first section; the second section runs fine.
I must have made another basic error but I just can't figure out what it is.
I have one intranet based application.I have set windows authentication for it in Web.config as well as from IIS settings. While running my application through the source code, it works fine but while running from directly IIS then its giving me:
"Connection property has not been initialized"
I need to configure a property of a custom control I wrote, specifically before the control calls OnInit. If I assign it as part of the ASPX file, it naturally works, but if I instead move the assignment to different parts of the code-behind, it will throw an error for having an empty and invalid value. The following is what it looks like when functional in the ASPX page.
<MyCustomControls:SingleCascadeLookupMulti FilterString="Seventh" FilterByStatus="true" ControlMode="New" FieldName="Speciality" EnableViewState="true" ID="sclmDocuments" runat="server" TemplateName="SingleCascadeLookupMulti" />
The property in question is FilterString, which is just a simple string. It should be noted as well that the FieldName property (inheritted from the control's base class "BaseFieldControl") would also throw an error if it is not initialized, but if I set FieldName in the code behind's OnInit method, it works correctly. FilterString is not so, it won't actually be assigned. So I know that some methods for certain properties will work for setting the property's value, but it won't always work. I tried placing it in OnPreInit as well, to no avail.
I am taking a dynamic assignment approach because the functionality of this page needs to be replicated for a number of different lists, and the FilterString and FieldName properties will differ in every case. Rather than write half a dozen mostly-identical aspx pages all with the same code behind but differing just in what those two properties are, I figured it would be wiser to use the page's query string and some derived parameters to set those properties dynamically. As such, what methods are available to accomplish this task?
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]...
Is it possible to use a pre-existing ConnectionString in this construction?
myConnection = New SqlConnection("server=localhost;" & "database=pubs;Trusted_Connection=Yes")
Regards -Penn
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.
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.
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>
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
I don't know fix it. My code:
[Code]....
The erros is about objConn.Open() - I think...
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 RepliesI'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)
I wondered what the difference between
'dbo.Property' and 'Property'
would be in an sql query
Traditionally with an Object Data Source, the wired up class will have its public properties available for binding (i.e. Gridview columns, etc.) which works well. But what if one of my wired up business objects has a property that is an object itself; can I drill down to a property on that object property and still use it?
So in additiona to the traditional:MyBusniessObject.OrderID...I want to use:MyBusniessObject.Customer.NameID
Your 1st response might be to just wire up the 'Customer' class, but I need properties both on 'MyBusinessObject'and 'Customer'. I do not think this can be done, as the ODS will not display properties on an object instance property. I have tried manually typing in the drilled down value as well, but that wasn't a success either.
I am storing a custom "Organisation" object as a session variable. One of the properties of the Organisation object is "OrganisationID" (integer). I have a DataSource that requires a parameter value to run, and I want to use a SessionParameter to populate this. In a previous version, I stored the OrganisationID directly as a session variable. In that case, I could easily access it like this:
[Code]....
However, how do I now access the OrganisationID property of an "Organisation" type session variable (called "Organisation")? I have tried this, which does not seem to work: <asp:SessionParameter Name="OrganisationID" SessionField="Organisation.OrganisationID" Type="Int32" />
Am I right in assuming that only after controls on Master page are merged into the control tree for the Page, can controls ( both those in Master page and in a content Page ) be initialized with their declarative values ( values set during design time)? b) If my above assumption is correct, then these controls cannot be initialized with their design-time values during Page.PreInit, since during Page.PreInit event stage we're still able to dynamically set a Master page?! So if that is the case, when are controls initialized with their declarative values? During Init event orâ€
View 1 RepliesI have an ASP.net control that contains a grid (protected member variable). Grid is populated from a function in the control. I have derived a new user control from this control without any control in it. I added additional functionality to populate grid and called base class function to do further operation on the grid. When I run my code, I get the null reference exception on grid object in the base control. I missing something in control inheritance? at what point do inner controls get created?
View 1 Repliespublic class DataClass{Â Â Â public DataClass()Â Â Â {Â Â Â }Â Â Â /// <summary>Â Â Â
/// return rows depend on position   /// if you need 10th to 20th you need to pass start=10 and end=20  Â
/// </summary>Â Â Â /// <param name="start">database start position of one row</param>Â Â Â
/// <param name="next">database end position of one row</param>Â Â Â
/// <returns></returns>Â Â Â public string GetAjaxContent(int start, int end)Â Â Â {Â Â Â Â Â Â Â Â Â Â
[code].....
When I'm trying to develop the unlimited scrolling in datalist i have an error like connection string not initialized I checked and rechecked.