Retriving data from database

Question

I have two database where a JOINT function is called to retrive data. From one of the database i am able to retrive data. In both database i have a felds which is same. Now i'm able to retrive that field from one database but find it hard to retrive the data from the other database. Heres the code: String sQuery = SELECT * FROM License L LicenseGroup LG WHERE L.LicenseGroupID = LG.LicenseGroupID AND L.Name = '+ label1.Text +' AND L.LicenseGroupID = '+ label2.Text +'; SqlCommand cmd = new SqlCommand(sQuery con); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); if( dr.Read() ) { label25.Text = dr[ Name].ToString(); label26.Text = dr[ Name ].ToString(); label27.Text = dr[ Description ].ToString(); label29.Text = dr[ price ].ToString(); label36.Text = dr[ playcount ].ToString();} Label25 Name needs to be retrived from the LicenseGroup table while label26 is retrive from License table. I'm finding it hard to retrive data from LicenseGroup in label25. Does any one knows what amendmend i need to make. Thanks Mac

mrocky · Answer

I never use * in any selects for any reason inside an application. Always specify the fields you want returned and you should have no problem.

mahmud_uk · Answer

No it does not function. I got a funny feeling theres something wrong with my SQL string. Can anyone spot any mistakes. Thanks Mac

developer 0 · Answer

try using License.Name and LicenseGroup.Name. and see if that works.

mahmud_uk · Answer

with the above script LG.Name throws an exception error. The compiler does not recognises the LG.Name attribute.

developer 0 · Answer

Have you tried to put the tablename.filed combo into the index string? i.e. label25.Text = dr[LG.Name].ToString(); label66.Text = dr[L.Name].ToString(); Hope it helped. Phil