Greetings:
I'm trying to determine the best way to handle security & performance issues with C++ applications which connect to a SQL 7.0 database. Using a 'Data Source' to connect to a database...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_11591818.html
Zones:
MS SQL ServerDate Answered: 10/23/2000 Rating: 8.0 Views: 0
How do I list the tables in a database from an sqlconnection once the connection is opened.
In VB6 you would use rs=cn.openschema
I dont want to have to use the information_schema.tables view...
http://www.experts-exchange.com/Programming/Languages/.NET/Q_20334506.html
Zones:
.NETDate Answered: 11/01/2002 Rating: 8.4 Views: 0
In an .ASMX file you can have multiple WebMethods. In all the examples Ive seen, they set the SQLConnection in each webmethod.
Dim cnn As New SqlConnection("Server=BC1300;uid=sa;pwd=gohome;dat...
http://www.experts-exchange.com/Programming/Languages/.NET/Q_20339008.html
Zones:
.NETDate Answered: 08/23/2002 Rating: 8.2 Views: 0
I've run into a little problem with an application I'm working on. I'm trying to set values of application variables from within an object. The class definition seems fine, but at runtime I'm tol...
http://www.experts-exchange.com/Programming/Languages/.NET/Q_20371208.html
Zones:
.NETDate Answered: 10/10/2002 Rating: 9.2 Views: 0
Hello there, can someone figure out why (da.Fill) is not recognised by the compiler. Where have i gone wrong.
private void Form2_Load(object sender, System.EventArgs e)
{
SqlConnection d...
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_21067727.html
Zones:
C#Date Answered: 07/27/2004 Rating: 5.6 Views: 0
i am building a data access layer in vb.net
what is the best way to manage connections to the sql database.
Should i have a "connection class" that i instanciate that returns me a live connec...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_21130116.htm...
Hello,
I put a public SqlConnection GetConnection() method inside my Global.asax. I was wondering if any of you had any hesitations about this, whether or not it is good practice, and why?
...
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_21207643.html
Hello,
i tried to connect to a MySQL Database(v 3.23.52-nt) using the following code:
SqlConnection myConnection = new SqlConnection(""
+ "DATA SOURCE=SERVER NAME(local);"
+ "Database=studi...
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_21276599.html
Zones:
C#Date Answered: 01/17/2005 Rating: 7.4 Views: 0
I am completely clueless on how to use SQLConnect. I am working with a win32 app (no MFC) and I am trying to connect to a Access DB called <data.mdb> and access a table called <Glass types> and sp...
http://www.experts-exchange.com/Programming/Languages/CPP/Q_21281911.html
Zones:
C++Date Answered: 01/20/2005 Rating: 7.4 Views: 0
I'm trying to connect to MySql with ASP.NET. I'm new to both, but fluent in ASP and SQL.
This is my code:
Dim conCal As SqlConnection
Dim daCal As SqlDataAdapter
conCal = New SqlConnection("...
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_21292825.html
