I'm trying to join 2 unrelated tables to display some of their data in a gridview. I get an error, saying "A field or property with the name 'PaidServer' was not found on the selected datasource". ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22980254.html
How can I get a row count of a table and display the number of rows in a label? Here is my sql code, but I can't figure out how to get the value to put it in a lable. Where I have label1=Row_Count,...
http://www.experts-exchange.com/Programming/Languages/.NET/Q_23025234.html
Hi All,
I lead a team of developers, most of which are self-taught with knowledge very specific to the industry in which we work (Insurance & Finance). We build internal enterprise apps for use ...
http://www.experts-exchange.com/Microsoft/Development/.NET/Q_23222376.html
How to command in sql select? OR Any proper sql command with hashtable/arraylist
eq:
SELECT id FROM xtable WHERE id NOT IN (hashtable)
OR
SELECT id FROM xtable WHERE id NOT IN (arraylist)
...
http://www.experts-exchange.com/Programming/Languages/.NET/Q_23646447.html
Zones:
.NETDate Answered: 08/15/2008 Grade: C Views: 9
I'm using Visual Studio 2003 and SQL Server 2005. I need to use .NET Framework 1.1.4322 to debug in 2003, but when I make the change in IIS the application can't connect to the SQL Server. I get th...
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Studio_.NET_2005/Q_22521...
I'm having trouble making a db connection to another server on SQLExpress. Since SQL2000 was installed first, it uses port 1045 - I know this works in my asp so I know it's correct, just the format...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2367...
Hello
I have SQL database with two tables: Team(#TeamID, *Name) and Match(#ID, *Home(int), *Guest(int), *Date(datetime),..).
So I connected this two tables, Home to TeamID and Guest by TeamID...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23702101.html
Zones:
SQL SyntaxDate Answered: 09/04/2008 Grade: A Views: 16
This question is pretty much straightforward:
In MSSQL2005 this works like a charm:
select :CountResultParam = count(*) from MyTable where iID = :iIDparam
It stores the value in my paramete...
http://www.experts-exchange.com/Database/Interbase_Firebird/Q_23717299.html
I am using the "Oracle.DataAccess" class library with VB.NET. The code executes SQL statements that apply updates to a database. I have found an unusual issue where I receive the error "ORA-0103...
http://www.experts-exchange.com/Database/Oracle/Q_23322020.html
Zones:
Oracle,
.NETDate Answered: 04/17/2008 Grade: C Views: 27
Duplicates problem
I have a parent table equipment and child table items
They have one to many relationship that is an equipment can have more than one items
Due to some data entry problems th...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23121372.html
