[2005] GridView disappears when using

[bomayed]

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 ?

[vbdotnetboy]

where is it "disappearing" from? the designer or the page all together?

[bomayed]

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

[vbdotnetboy]

sounds like you're not binding the data. are you manually creating the column or autogenerating?

[bomayed]

am autogenerating , am just draging the table from sql database and droping it to the page

[bomayed]

I realized that the gridview disappears right after I modify the sqldatasource by selecting (Advanced ) and enabling the options (Generate Insert , Update .. )

[vbdotnetboy]

i realize this may sound stupid but there is data in the table right

[bomayed]

am a bit stupid but not that stupid

of course there is data in the table

[vbdotnetboy]

am a bit stupid but not that stupid

of course there is data in the table

always good to check

anyway could you post the markup so we can see what might be wrong