When using stored procedure in sqldatasource of asp.net, none of databound items refreshes automatically??

Question

Why is this the case? I was using simple text queries and it worked well. When I turned those queries in stored procedures, it does the job, but listviews and gridviews dont update/refresh automaticly.

Help please.

Answer 1

ok. I will try to put it other way.

i have a listbox which is databounded to sql database table via sqldatasource i also add items to sql database table on the same page, via that sqldatasource. What I want is to see the results in the listbox immediately after i add row to table While i was using sql text queries i did not have to use databind() method, but now i have sql stored procedure instead, and a must databind() every time. Can someone explain why?

Example:

1.

sqldatasource1.insertquery = "insert into table a values (1,2,3)" - with this it automaticly databinds

2.

sqldatasource1.insertquery = "blabla" - with this it doesn't //blabla - is the name of stored procedure which does the same as example 1

Why is this?

Thanks