How to get solution for sqldatasource
-
SELECT [CustCode], [Name], [Addr], [Area] FROM [Customer] WHERE (([CustCode] = @CustCode) OR ([Area] = @Area)) i'm using the above code in a sqldatasource,which i've connected with a gridview.the above query is executing while testing in the tool(sqldatasource).but at the time of running application it is not working.i've to disply details in the gridview when clicking a button. can anyone help me to get the solution. Babu
-
SELECT [CustCode], [Name], [Addr], [Area] FROM [Customer] WHERE (([CustCode] = @CustCode) OR ([Area] = @Area)) i'm using the above code in a sqldatasource,which i've connected with a gridview.the above query is executing while testing in the tool(sqldatasource).but at the time of running application it is not working.i've to disply details in the gridview when clicking a button. can anyone help me to get the solution. Babu
You'll need to show more code than that - post the declaration of the SQL DS and of the grid, so we can see if they tie up ok - my bet would be that you've not bound the grid correctly, or AutogenerateColumns=false and no cols specified? "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox