|
Hi,
I have created a class in my business layer, that contains several functions that fetch data from database. For opening and closing connection i have used the constructor and destructor of the above class. The code segment below depicts that. But i have got an error when the application runs. It fires in the destructor, from the line
sqlcon.Close();<br />
The Error Message is...
Invalid operation exception was unhandled.
Internal .net Framework Data Provider Error 1
what could be the reason?
<br />
public DLNuERPMain()<br />
{<br />
sqlcon.ConnectionString = strConnNuERPv2;<br />
if (sqlcon.State.ToString() == "Closed")<br />
{<br />
sqlcon.Open();<br />
}<br />
}<br />
~DLNuERPMain()<br />
{<br />
if (sqlcon.State.ToString() == "Open")<br />
{<br />
sqlcon.Close();<br />
}<br />
}<br />
awaiting for your valuable Suggestions........
Thanking you in advance
Sebastian
|
|
|
|
|
You should explicitly close the SqlDataReader when you are done using it, before finalization. If you do that and are still running into problems, post back again with a new error message and call stack (if they have changed).
For Details look at MSDN:
SqlDataReader Close Method[^]
Regards,
Satips. ![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
|
Hi,
Thank you very much......
Best Regards
Sebastian
|
|
|
|
|
Glad to Help always.
Regards,
Satips.
|
|
|
|
|
My aspx page is trying to connect to a remote server with SQL Server 2000 installed on it, the ip of the server is 172.16.3.111 and the same is the instance of SQL Server, sql server is running in SQL Server Authentication mode, user id is "test" and password is "test123", name of database is myDB,the connection string which I am providing is as follows:
data source=172.16.3.111\172.16.3.111;user id=test;password=test123;initial catalog=myDB;"
But I am getting the following exception:
SQL Server does not exist or access denied.
even if I try the following connection string:
"data source=172.16.3.111;user id=test;password=test123;initial catalog=myDB;"
than also I get the same exception
Can u please tell whats the problem,is the connection string correct,the DBA has also registered me "test" as a user on the SQL server.One thing which I want to mention is that through enterprise manager I can connect and use sql server without any problems,also please note that in VS.NET when I try connecting using server explorer and test the connection than I connect successfully, than why is problem occuring in connecting throug aspx page.
|
|
|
|
|
|
anystudent wrote: data source=172.16.3.111\172.16.3.111;user id=test;password=test123;initial catalog=myDB;"
The problem might be because of the 2 ip addresses provided. And also check the colon which you have provided in the Syntax.
Regards,
Satips.
|
|
|
|
|
Hi,
I have exported my data in gridview to excel sheet but i have a problem to format the excel cell through my code. my gridview data has line break in some of the column
, when exported to excel, it will occupy few rows instead, I need to format the data such that each order will occupy one row for easy data auditing.
I'm using this code to export the data:
string filename = System.Configuration.ConfigurationManager.AppSettings["ExcelFilename"];
string style = " .style0 {vertical-align:top;} ";
// all roles exported turn off paging and rebind the grid before sending it to export
this.GridView1.AllowPaging = false;
this.GridView1.DataSource = (DataView)Session["OrderList"];
this.GridView1.DataBind();
DisableControls(GridView1);
Response.Clear();
Response.AddHeader("content-disposition", string.Format("attachment;filename={0}.xls", filename));
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
StringWriter stringWrite = new StringWriter();
HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
this.GridView1.RenderControl(htmlWrite);
//style is added dynamically
Response.Write(style);
Response.Write(stringWrite.ToString());
Response.End();
|
|
|
|
|
I am trying to set up Database to use ASP.Net Memebership as below. There would be two DB one is SBCentral and SB.
SBCentral will be used for memebership purpose/and all app meta data where SB database will be used for all other application activites. I already compiled and created a new db as "SBCentral" by using aspnet_regsql. Now when i am trying to test this through web admin tool (website-->Asp.net configuration) i am getting error as
Provider Management
Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider
<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="SB"
connectionString="Data Source=81080EA37F\SQLEXPRESS;Initial Catalog=SB;User ID=sa;Password=abc" providerName="System.oledb.SqlClient" />
<add name="SBCentral"
connectionString="Data Source=81080EA37F\SQLEXPRESS;Initial Catalog=SBCentral;User ID=sa;Password=abc" providerName="System.oledb.SqlClient" />
</connectionStrings>
<system.web>
<membership>
<providers>
<add connectionStringName="SBCentral" name="CustomProvider"
type="System.Web.Security.SqlMembershipProvider" />
</providers>
</membership>
Any help?
Amit
|
|
|
|
|
I chnaged the custom provider name to AspNetSqlMembershipProvider from name CustomPrvoider and now it is not throwing error.
But a new problem, evertime when i try to create user, it creates in ASPNETDB.MDF file instead of SBCentral...
I also changed my CentralDb to ASPNetDB.....But no luck....
So please guys help me....
|
|
|
|
|
I am planning to use the new feature of ASP.Net 2.0 in my one of new website and i am doing analysis to see capablities of these new features.
I have a quick query and it would be nice if you can show me some direction.
I am planning to implement memebership API for creating user, validating user, etc... but i don't want to use SQL Express Database (whiich comes with ASP.net) because of security reason. I am planning to use SQL 2005. So what i need to do....Do i need to create same tables in my SQL 2005 database (same name, same columns etc...) or i can have custom tables.
Amit
|
|
|
|
|
I need to combine columns from 3 different tables (ofcourse from a single database)in to a single DataSet...and also I need to add a Column along with the same Dataset ...So,kindly tell me how to do this..??
And also i am planning to create a crystal report for this newly created DataSet.
I need ur suggestions and help.
Kindly help me ...Pls!!
My project deadline is 27th July..With in that i need to generate 6 different reports with 6 different logics..So,kindly help this poor fresher...!!
Happy Programming!!!
|
|
|
|
|
SrividhyaS wrote: My project deadline is 27th July
You have plenty of time to look up DataSet.Merge() and DataTable.Merge() then.
only two letters away from being an asset
|
|
|
|
|
Can you tell us the tables and columns? I'm sure you can accomplish this with SQL instead of DataSet.Merge. What kind of column are you trying to add in addition to the other data?
- S
50 cups of coffee and you know it's on!
|
|
|
|
|
Hi,
You can try with following short ways.
1. Try combine required fields of different table to get single datatable.
2. Create different datatable and merge all with one dataset.
Rams.
Be simple and Be sample.
|
|
|
|
|
may be she should buy u choklats if she passes her exam 
|
|
|
|
|
Hello to every One,
i'm using one textbox1 and button1 where i'm checking the input text to be "yes" for that i'm able to use server side validation but i want to make the same using client side validation..
Suggest me.....
Thank You..
|
|
|
|
|
Use a requirefield validator control and specify the client script
only two letters away from being an asset
|
|
|
|
|
hello hemant,
just use the Javascript,it is best for the client side validation
Hemant Garg wrote: i'm checking the input text to be "yes"
write the function and check ,
function ChkInput()
{
if (document.GetElementById("TextboxName").value == "yes")
{
alert("Exist")
return false;
}
}
and call that function on click event of button
hope it helps,
koolprasad2003
If the message is useful for U then please Rate This message...
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
hi, I'd like to create an ad that moves across my web page then stops a while at the center of the page?? Like the ads that sometimes appear on Yahoo..Can I do that using javascript or ajax...how?? is there any code or any reference for that??
-- modified at 9:50 Sunday 1st July, 2007
|
|
|
|
|
|
I have been trying to read textfile from client side and get the data inside the file add into the
table but I have this error all the time
Anybody who know how to resolve this problem please help me.
I am just new in ASP .NET and this is the first webApplication of mine.
Thank you million for helps,
===============================================================================================
Server Error in '/' Application.
--------------------------------------------------------------------------------
Could not find a part of the path 'C:\Documents and Settings\aim\Desktop\DataFile.txt'.
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.IO.DirectoryNotFoundException: Could not find a part of the path 'C:\Documents and Settings\aim\Desktop\DataFile.txt'.
Source Error:
Line 36:
Line 37: // fileInfo = Server.MapPath("TextFiles//mydata.txt"); //Testing
Line 38: fs = new FileStream(fileInfo, FileMode.Open, FileAccess.Read);
Line 39: sr = new StreamReader(fs);
Line 40:
Source File: d:\webhost\471463016\Table2.aspx Line: 38
===============================================================================================
junior boy
|
|
|
|
|
You can't open a file on the client computer from the server. The user has to upload the file to the server for the server to access the file data.
---
single minded; short sighted; long gone;
|
|
|
|
|
what exactly you want to do...
As i belive you are trying to read a file from your virtual dir.
Provide correct relative path. because system is trying to pull the file from Desktop. I think there is no such file on the desktop.
Ravi Kant Srivastava
(System Analyst)
HandsOn Technology & Engineering
Gurgaon
(India)
e-mail:ravikant@hte.co.in
|
|
|
|
|
Now I know I need to upload the text file [data file] to the server.
Anybody know what article explain how to upload text file?
Thank you very much again.
junior boy
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
