query working on Sql Server but not on dotnet during binding the datagridview

Question

3.00/5 (1 vote)

See more:

select P.productid,  P.displayname, P.skuno, P.haslicense,P.isevalversion,O.oemname from productmast P Inner join userpermission U on P.productid=U.productid join oemmast O on P.oemid=O.oemid

This query is running on the Sql Server Management Studio but when i am using it to bind the GridView then its not working . Its showing error regarding oemid not exist

Posted 10-Oct-11 2:02am

Vimalrashamra

Updated 10-Oct-11 2:08am

sravani.v

v2

Add a Solution

Comments

sachin10d 10-Oct-11 8:10am

can you show datagridview binding code

P.Salini 10-Oct-11 8:12am

can you show your binding code

hitech_s 10-Oct-11 8:16am

try replace join with innerjoin

could you plz provide your .aspx code of gridview

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Muralikrishna8811 · Answer 1 · 2011-10-10T03:54:00

Solution 2

Hi,

try this query once

SQL

select P.productid,  P.displayname, P.skuno, P.haslicense,P.isevalversion,O.oemname,P.oemid from productmast P Inner join userpermission U on P.productid=U.productid join oemmast O on P.oemid=O.oemid

Here you've to retrieve P.oemid also in first join then only you can compare in second join

All the Best

Posted 10-Oct-11 3:54am

Muralikrishna8811

Comments

Vimalrashamra 11-Oct-11 1:00am

Its also giving the same problem

Muralikrishna8811 11-Oct-11 4:15am

try like
select *
from productmast as P,userpermission as U,oemast as O
where conditions

query working on Sql Server but not on dotnet during binding the datagridview

1 solution

Solution 2

Add your solution here

Preview 0

query working on Sql Server but not on dotnet during binding the datagridview

1 solution

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us