I have this code:
SqlConnection connection = new SqlConnection();
connection.ConnectionString = Globals.connectionString;
connection.Open();
string commandText = "SELECT DISTINCT Count(Aver...
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_20762081.html
Zones:
C#Date Answered: 10/09/2003 Grade: B Views: 0
Ok, once again i'm having problems using my database class that i've created with several functions in it that perform various SQL statements. The problem i'm having is essentially knowing when an...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_21268835.htm...
Here is the code that I am using,
Dim sqlcom1 As SqlCommand = New SqlCommand("SELECT * " & _
"FROM TABEL1 " & _
...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_21410166.htm...
2 questions, see >>>>>>>>>> below:
Dim connection As SqlConnection = New SqlConnection("ConnectionString")
Dim command As SqlCommand = New SqlCommand("GetCustomer", connection)
co...
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_21458991.html
Hi,
I have a COM+ code where I have a function whihc returns a SqlDataReader object as a resultm but when I try to call it in my client, this one cannot recognize my object it tells me 'cannot ...
http://www.experts-exchange.com/Programming/Languages/.NET/Q_21469975.html
Zones:
.NETDate Answered: 06/28/2005 Grade: A Views: 0
Hi experts,
I have module responsible for reports generation and distribution
Reports could be in different formats: Excel, PDF, CSV,HTML etc.
Format is defined in database
For each format I ...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_21545640.htm...
Hi,
I am using the SQLDataReader and i use it to get ids from the database.
strSql = "SELECT * From Prog WHERE ProgID = '" + strProgID + "'";
SqlConnection scallprogram = new SqlConnection...
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_21576950.html
Zones:
C#Date Answered: 09/28/2005 Grade: A Views: 0
The following code loops only through the first part. It needs to make a decision based on whether or not data is present at if (dr.HasRows) . I'm certain there in not any data yet the ELSE will n...
http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_21731044.html
Zones:
C#Date Answered: 02/11/2006 Grade: C Views: 0
Is this the correct way to use a sqlDataReader? Also see specific questions marked by <----------
dim c1 as New sqlConnection
dim cm1 as New sqlCommand
dim rdr1 as sqlDataReader
dim d as dou...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_21736272.htm...
I need to connect to a sql server through an asp.net page. I am getting Object reference not set to an instance of an object on line objRdr = objCmd.ExecuteReader(). Please can you tell me what I...
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_21784311.html
