Printable View
I have a gridview and sqldatasource connected to each other
When I try to modify the SqlDataSource by changing it from ( specify columns from a table or view ) to ( specify a custom SQL statement) , the gridview disappears!
can someone explain to me why and how to fix it ?
where is it "disappearing" from? the designer or the page all together?
Not in the designer , when I run the project and I go to that gridview I see nothing , only the ( Select, Delete ) option without any data
sounds like you're not binding the data. are you manually creating the column or autogenerating?
am autogenerating , am just draging the table from sql database and droping it to the page
I realized that the gridview disappears right after I modify the sqldatasource by selecting (Advanced ) and enabling the options (Generate Insert , Update .. )
i realize this may sound stupid but there is data in the table right
am a bit stupid but not that stupid :)
of course there is data in the table
Quote:
Originally Posted by bomayed
always good to check ;)
anyway could you post the markup so we can see what might be wrong