will QUERY BUILDER in SQLdatasource reads gridview cell value..??
Posted on 2008-10-30
Is it possible .. to get gridview cell value in the querybuilder of sqldatasource control.
My issue is . am using a gridview, in that there r three columns .
where as for name field am using dropdown list,
1.am populating name from db in dropdown list using sqldatasource ctrl . which is too ec . But wat really not happening is . i want to bind dropdown according to id field index value in gridviw.. in otherwords I want to populate by using the gridview cell of 0 value ...is it possible..to in query builder. . ??
For eg ...(this is just for understanding like this...).
select name from table where id= row.Cells(0).Text) ...??
.can v get index value of gridview in querybuilder in sqldatasource ctrl....????
if its not possible y...???Plz suggest ....