Which Data source to use? 2

[whateveragain]

FormA has a gridview and a SQLDataSource control which refers to a dynamic table which was created in the screen prior to FormA. On FormA there is a button that leads to FormB, which allows restrictions to the table displayed in FormA. Currently I drop the table and try to recreate it, then re-call FormA, but the table will not re-create. It keeps displaying the previous table in FormA. The columns are the same, just the records change. What is the best way to do this? What am I doing wrong?

 

[jbenson001]

What am I doing wrong?

You are using the datasource controls.

Write the data access code yourself, in reusable code, that you can call from each page.

 

[whateveragain]

How do I write this line when the table name is dynamic?

com.CommandText = "Select * From @tmpselcond";

 

[seaport]

Store the data in a datatable object, and transfer that object between pages.

 

[jmeckley]

the command text can be whatever you want, so you could create and load the temp table, and then select from it

create table @temp (
  .....
);
insert into @temp
select ....

select * from @temp

Jason Meckley
Programmer

faq855-7190
faq732-7259