i have 5 methods in classA. each and every methods i have open the sqlconnection and close it, instead of that is there anyway to create a sqlconnection at one time if its opened then no need to create a new connection, if its closed then we have to connect.
View 5 RepliesIs it possible to use a pre-existing ConnectionString in this construction?
myConnection = New SqlConnection("server=localhost;" & "database=pubs;Trusted_Connection=Yes")
Regards -Penn
I have a whole bunch of data access methods where in each one I am doing this
[Code]....
and them moving on with my SqlCommand and SqlDataReader and so on.Is this creating to many instances of an SQLConnection?I was thinking doing this instead. Creating a SqlConnection Manager which would look like this
[Code]....
and then in my database access methods
[Code]....
Is this a good or bad idea and why?Also would this even be neccesary?
i am making a simple cms system
but I have a problem when updating some information
here is the code
[Code]....
and in the page load everything is fine
[Code]....
'SqlConnection' is not defined in the behind code as follows:
Source Error:
[Code]...
Source File: I:WebsitesCMPHostFox BackupDefault.aspx.vb Line: 24
Snippet reads as follows:
[Code]...
can capture return value from a SQL by using SqlConnection SqlCommand
[Code]....
I'm trying to determine whether it is better to declare the connection outside with it's own using statement or to create it inside the sqlcommand itself. This is in regards to a single command interaction with the database (no loops).
[Code]....
Or
[Code]....
I am using "ASP .Net 2.0" with "SQL Server 2005". What is better and preffered approach towards making a sqlconnection to interect with database?
1. To open new connection each time we need to interact with DB and then close the connection
2. Or to make a shared database connection for whole web application.
I know you can point to a OnSelecting event on the aspx page datasource. But I've created my SqlDataSource in the code behind. Is there any way to point to a selecting event in the code behind (I need this to provide the parameters)? Or should I just include all my logic in the Page_Load event (where I keep my SqlConnection)Here's what I have so far:
protected void Page_Load(object sender, EventArgs e)
{
SqlCommand myCommand = new SqlCommand();
[code]...
i have problem white Object datasource. i have a multi-tier Application that include common layer ,DAL Layer,business logic and persantation layerwhen i add a object datasource to my page, it bring me only common layer classes . but i want use bisuiness layer classes what do i do ?
View 1 Replies'i'm working with visual studio 2005 asp.net c#. and i want to bind my website to my database with the "sqlConnection"
how do i get and set details from the database to the website fields with the sqlCommend and ect...
In my ASP.NET application I am using a lot of ObjectDataSource controls. I want to set the following three properties globally for all ObjectDataSource controls:
EnableCaching="true"
I get the above error using this code. What am I missing?
[Code]....
I am using LINQ to SQL files in my class libray since every LINQ to SQL sources file is a seprate file and i have to set database connection string in each class library. Now, i have total 7 class libraires in my project how connection string be passed from web.onfg to LINQ file, so that i don't need to manually change the connection string. lke we did in asp.net 2.0 using connection string property in class file library.
How could we pass the same in LINQ's designer file.
How can I get common columns from two intersecting datatable inside dataset?
View 2 RepliesMy pages work with a SqlDataSource and an Access Database but returns an error when I'm using a SQL Server database.
ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'sid'
[Code]....
I have a solution I'm working on in VS2010 Professional, using ASP.NET 4.0 with the AJAX Toolkit.This has been working fine, but when I started it up today, I got the runtime exception shown above. This exception occurs on any page with a control from the toolkit.Sometimes when I load a page, I get an exception "Could not load file or assembly 'System.Windows, Version=2.0.5.0, Culture=neutral, ublicKeyToken=7cec85d7bea7798e' or one of its dependencies. The system cannot find the file specified." If I then reload the page (without making any changes), I then get the exception shown in the subject line.I tried dragging an AJAX Toolkit control from the toolbox onto a page, and then deleting it, and that worked - once. The next time I tried the page (or any other), I got the exception again. Dragging a control out didn't help this time.
View 5 Replies i would like to know if there's something wrong in this asp.net code:
mydatareader = mycmd.executeReader()
if myDataReader.HasRow then
// Do something
end if
myConnection.Close()
If i avoid to call a "MyDataReader.Close()" does the connection close anyway ? I ask this because i'm assuming that if call a "MyConn.Close" it automatically close the associated datareader... or am i wrong ?
I have th following code:
[Code]....
I got any error from the code, saying 'not all code path return a value', i suspect it is the catch block doesnt return a value. If so, what value should i return?
When i connection on database Microsoft SqlServer 2008 By This code.
Code:
SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["myconnection"].ConnectionString);
SqlCommand cmd = new SqlCommand("select * from [City]", cnn);
cnn.Open();
Code In configration Manager
Code:
<add name="myconnection" connectionString="Data Source=.;Initial Catalog=db;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
found this Sql Exception:
The user instance login flag is not supported on this version of SQL Server. The connection will be closed. what is problem?
I always use SqlConnection() To open a connection then use the connection to interact database. But I have heard somewhere that opening SQLconnection() take a time. and if on different pages of projects I repeatedly Connect database then It will take long access time always. So I want to know that if there is any other methods which don't use the SQLConnection to interact database and increase the response time of database.
View 1 Repliesso i have the function below in a webservice. and it works, but when i try to copy it to aspx page code behind, i get the message in the subject. Can someone tell me if the function below is valid? One of my project uses it and it works.
[Code]....
in my application when i type sqlconnection it is not showing any intellisence, i added the namespace System.Data.Sqlclient not only sqlconnection even i am not getting Page calss can u help me.actually i am sharing this application from my company server.
in our company previously there was .net 2.0 frame work when this project was developed(one year back).
yesterday our company installed 3.0 .net frame work is this any problem for previous project which are developed in 2.0 how can i go through this problem.
Is it possible to hava a Colums in grid like
Binding Grid as:
Date Apple Banana Mango
26-Apr 5Qty 8Qty 7Qty
I want to add Common Header for Apple banana mango above it as FRUIT. is it possible and how
i would like to write a streaming programming which will keep updated or query the database. I would like to use a connection instead of open and close connection on each transaction. But the streaming programming would not end, running at all the time. So, is it any effect if i am using only one connection (within a long period). Such as performance, timeout issue, or others exception.
View 1 Replies