Problem in Datagrid with sqldatasource
-
Hi all, i'm using a datagrid with a sqldatasource.in that i'm using where clause with 2 parameters student ID and name.but the select statement is not working when there is both ID and name is present.But its working and display the data with the ID only.Can any one give me the solutions for this? Babu
-
Hi all, i'm using a datagrid with a sqldatasource.in that i'm using where clause with 2 parameters student ID and name.but the select statement is not working when there is both ID and name is present.But its working and display the data with the ID only.Can any one give me the solutions for this? Babu
-
select [StudentID],[Name],[Percentage] from tblstudent WHERE (StudentID = @StudentID AND Name=@Name AND Percentage=@Percentage) this was the statement in the sqldatasource tool. Babu
-
select [StudentID],[Name],[Percentage] from tblstudent WHERE (StudentID = @StudentID AND Name=@Name AND Percentage=@Percentage) this was the statement in the sqldatasource tool. Babu
-
Hi, Do you have any record in the database which is satisfying all the conditions here because your query is correct. Best Regards, Apurva Kaushal
hi, i've applied this query for another table too.that is for customers.even for that it was not working. can you give me the sql statement using OR Condition.will it work. Actually in sqldatasource there is no need to write coding manually.just in configuration mode we can create with the option "Where" button. Babu
-
hi, i've applied this query for another table too.that is for customers.even for that it was not working. can you give me the sql statement using OR Condition.will it work. Actually in sqldatasource there is no need to write coding manually.just in configuration mode we can create with the option "Where" button. Babu
Hi, If you are using and condition then all the conditions has to be satisfied then only you will be able to get the result. So according to your query is you are having a record which is having all the StudentID, Name and Percentage which you have passed that will be fetched. For OR condition just replace and with or. Hope this will help you. Best Regards, Apurva Kaushal
-
Hi, If you are using and condition then all the conditions has to be satisfied then only you will be able to get the result. So according to your query is you are having a record which is having all the StudentID, Name and Percentage which you have passed that will be fetched. For OR condition just replace and with or. Hope this will help you. Best Regards, Apurva Kaushal
SELECT [CustCode], [Name], [Addr], [OrdType], [Area], [Lob] FROM [Customer] WHERE (([CustCode] = @CustCode) OR ([Country] = @Country)) i was using dis query for another table access.but its not working. Babu
-
SELECT [CustCode], [Name], [Addr], [OrdType], [Area], [Lob] FROM [Customer] WHERE (([CustCode] = @CustCode) OR ([Country] = @Country)) i was using dis query for another table access.but its not working. Babu