querystring or temp table - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

ASP.NET

querystring or temp table

Author

Topic

programer
Posting Yak Master

221 Posts

Posted - 2010-10-25 : 19:54:39

Hi,

According to what my needs it is better to use temp table or querystring?

Click data in DbGrid and redirected to another Web site with ID data.

ID I need, the need for ID data stored in the table.

I thought even the temp table, which would temporarily stored ID and you would then find all the WHERE clause.

What is the best solution for this?

Regards

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-10-25 : 21:15:46

I don't understand your question exactly, but querystring is almost always going to be the worst option -- especially if you need your app to be somewhat secure.

Query strings can be modified by the end user and are ripe bait for hackers

programer
Posting Yak Master

221 Posts

Posted - 2010-10-26 : 06:24:03

You are understood the question.
What option would you suggest instead of querystring(session,itc)?

quote:
Originally posted by russell

I don't understand your question exactly, but querystring is almost always going to be the worst option -- especially if you need your app to be somewhat secure.

Query strings can be modified by the end user and are ripe bait for hackers

Sachin.Nand

2937 Posts

Posted - 2010-10-26 : 14:55:10

Go for querystring but make sure you encrypt the querystring values before you pass it

PBUH

programer
Posting Yak Master

221 Posts

Posted - 2010-10-26 : 16:58:39

ali pa session option?