DataReader reading data from multiple tables
-
Hi, my query is given below. "select dp.detail from procdure p, mentryi m, dtentryp dp where m.master=p.proc and dp.master =m.detail and m.item=481" when i am running the query its giving me the output, that is fine. now using ado.net DataReader, how do i read individual columns from different tables. I am using DataReader b'coz, I am reading a BLOB field from mysql database and converting into .jpg images, that is also working fine, if i am reading from just one table. I need to read specified columns from different tables in the same DataReader. if i am using the instance like "p" for procdure table, it is giving me error and its not identifying the variables associated with the table. Any help would be appreciated.. vijay
-
Hi, my query is given below. "select dp.detail from procdure p, mentryi m, dtentryp dp where m.master=p.proc and dp.master =m.detail and m.item=481" when i am running the query its giving me the output, that is fine. now using ado.net DataReader, how do i read individual columns from different tables. I am using DataReader b'coz, I am reading a BLOB field from mysql database and converting into .jpg images, that is also working fine, if i am reading from just one table. I need to read specified columns from different tables in the same DataReader. if i am using the instance like "p" for procdure table, it is giving me error and its not identifying the variables associated with the table. Any help would be appreciated.. vijay