MikeSmithDev

Do you mean you are doing "....mypage.aspx?pageName=null"? This will return a string not null. Also, including a user generated input (txtboxUserEmail.Text) into your SQL statement is a big security issue. You should sanitize your input and use a paramerized query.

Can you post the rendered HTML for those links? It sounds like either you are overriding the click with javascript, or you are changing the NavigateUrl values from the code behind.

If you are trying to put values into tableB, then you probably want to do an UPDATE statement, like UPDATE tableB SET itemName = a.itemName FROM tableB B INNER JOIN tableA A ON B.id = A.id

Kind of an odd query... are you trying to do something like SELECT test1 = CASE WHEN db2.col_1 < 5 THEN db2.col_1 ELSE '' END, test2 = CASE WHEN db2.col_1 > 5 THEN db2.col_1 ELSE '' END FROM db1 INNER JOIN db2 ON db1.col_2 = db2.col_2

Try using `connectionString="Data Source=|DataDirectory|\Database1.mdf`