I have created a small querry and for some reason my container (datalist) is not reconizing the company name
This is also the first time that i have created a querry with two select statements in the sproc... Does it make a difference if there is two select statements in a querry?? When populating a datalist? Not sure if i need to seperate the two statements some kind of way.. Is this ok to use with datalist? Erik..
ALTER PROCEDURE Get_Information_For_Datalist_Global_ @.IDProduct AS INT, @.IDCompany AS INT AS
SELECT Product.ProductName, Product.ProductID,Product.ProductImage, Product.ProductDescription, SprocsTable.* FROM Product INNER JOIN SprocsTable ON Product.ProductID = SprocsTable.ProductID WHERE Product.ProductID = @.IDProduct
SELECT Company.CompanyID, Company.CompanyName FROM COMPANY WHERE COMPANY.COMPANYID = @.IDCompany
|
No comments:
Post a Comment