Database

TA_Customer
------------
Customer_ID  CustomerID  LastName  FirstName
155603       101         Jones     Bob
155611       101         Jones     Jane
155612       101         Jones     Willy

TA_CustomerRelationships
-------------------------
CustomerID  Customer_ID1   Customer_ID2  RelationshipID
101         155603         155611        2
101         155603         155612        3

TA_CustomerRelationshipsLU
---------------------------
RelationshipID   Description
1                Husband
2                Wife
3                Son
4                Daughter
5                Father
6                Mother
7                Grandfather
8                Grandmother
9                Uncle
10               Aunt
11               Nephew
12               Niece
13               Cousin

SELECT TA_Customer.Customer_ID,
       TA_Customer.FirstName,
       TA_Customer.LastCompanyName,
       TA_CustomerRelationshipsLU.Description
FROM   TA_CustomerRelationships INNER JOIN TA_CustomerRelationshipsLU ON
       TA_CustomerRelationships.RelationshipID =
       TA_CustomerRelationshipsLU.RelationshipID CROSS JOIN
       TA_Customer
WHERE  (TA_Customer.CustomerID = '101') AND (TA_CustomerRelationships.CustomerID = '101') AND
(TA_Customer.Customer_ID <> 155603)

155611	Jane	Jones	Wife
155612	Willy	Jones	Son

<br />
Select TA_Customer.Customer_ID, TA_Customer.FirstName, <br />
	TA_Customer.LastName, TA_CustomerRelationshipsLU.[Description]<br />
FROM TA_Customer<br />
INNER JOIN (<br />
--Gives you the Relationships for the individual<br />
Select Customer_ID2, RelationshipID<br />
from TA_CustomerRelationships<br />
WHERE Customer_ID1 = 155603<br />
AND CustomerID = 101<br />
) b <br />
ON TA_Customer.Customer_ID = b.Customer_ID2<br />
INNER JOIN TA_CustomerRelationshipsLU<br />
ON b.RelationshipID = TA_CustomerRelationshipsLU.RelationshipID<br />

--Gives you the Relationships for the individual<br />
Select Customer_ID2, RelationshipID<br />
from TA_CustomerRelationships<br />
WHERE Customer_ID1 = 155603<br />
AND CustomerID = 101

1. You've created a SqlConnection object, but never opened it;
2. You've created a SqlCommand object, but never executed it;
3. You haven't added any code to output the results of the query;

TEST

//remove the SqlCommand Construction and what follows and use this
DataTable dt = new DataTable();
new System.Data.SqlClient.SqlDataAdapter(strSQL,objConnection).Fill(dt);
dgNameList.DataSource = dt;
dgNameList.DataBind();

SELECT * FROM auth_user WHERE user='Test' AND pass='Test'

SELECT * FROM auth_users WHERE user='Test' and pass='Test'

and then

pkid = auth_id; // Copy the id from the above result

SELECT * FROM members WHERE pkid = auth_id

SELECT A.PKID, A.USER, A.PASS, A.WHATEVERELSE, B.WHATEVER FROM auth_user A, members B WHERE A.user='Test' AND A.pass='Test' AND B.PKID = A.PKID