ASP.NET

Re: how the data table retains its value with in pagescope

9-Dec-07 19:24

Store it in Session or viewstate. Caching is not a good solution for your scenario.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

jagan1239-Dec-07 19:43

Re: how the data table retains its value with in pagescope

9-Dec-07 19:43

hi sir how r u...wat u said i did that only but i think session takes lot of space if more users acessing the same page .actual my requirement .iam getting the data from database into the datatable in one click event .and i want this data table values in another click event.but because of page post back the datatable does contain any values.how this problem will solve plz help me in this regard.

N a v a n e e t h9-Dec-07 19:50

Re: how the data table retains its value with in pagescope

9-Dec-07 19:50

Have you tried viewstates ? It's scope is only in the page. So no need to worry about server resource utilization.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

jagan1239-Dec-07 19:54

Re: how the data table retains its value with in pagescope

9-Dec-07 19:54

sir...is there is any other alternate wat i mean with out session and viewstate..can't we achive this problem...k if we use view state or session which one is better one sir.

Christian Graus9-Dec-07 19:56

Christian Graus

9-Dec-07 19:56

Viewstate can be tampered with and doesn't persist across pages. Session takes up room on the server. The Session is a concept that is not unique to ASP.NET, viewstate was created to create state within a stateless environment. They both have advantages, at different times.

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Re: how the data table retains its value with in pagescope

jagan1239-Dec-07 20:00

Re: how the data table retains its value with in pagescope

9-Dec-07 20:00

thanks mr.Christian Graus sir for u r value advices..is there is any problem in memory allotments if i use viewstate for the datatable when a largeno users acees the same page

N a v a n e e t h9-Dec-07 20:07

Re: how the data table retains its value with in pagescope

9-Dec-07 20:07

There won't be much problem. But if your datatable is much bigger, viewstate also will be huge. As Christian told, it is easy to tamper, so if you are keeping very sensitive information, go for sessions. If you need to keep the data only in this page and it's not sensitive, use viewstate. If all your users are seeing the same data, then cache your datatable for improved performance.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

jagan1239-Dec-07 20:21

Re: how the data table retains its value with in pagescope

9-Dec-07 20:21

If all your users are seeing the same data, then cache your datatable for improved performance.
will u plz tell wat this sentence means?

N a v a n e e t h9-Dec-07 20:26

Re: how the data table retains its value with in pagescope

9-Dec-07 20:26

You told you have many visitors seeing this page simultaneously. So ti improve performance, you can cache the datatable. But this is applicable if all the users are seeing same data and not user specific data.

Assume you have a website something like CP, and in your page you display all the latest articles. So this information will be same for all the visitors. You cache this data and when another user requests, load it from the cache.

Hope it makes sense.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

jagan1239-Dec-07 20:37

Re: how the data table retains its value with in pagescope

9-Dec-07 20:37

thanks for u valuable suggestions .now my table contains a rows of 150.so will i use viewstate sir..at present iam using seession. u told me this senetence ----
"Assume you have a website something like CP, and in your page you display all the latest articles. So this information will be same for all the visitors. You cache this data and when another user requests, load it from the cache."how could be done this one sir id how i can make a datatable cache...

thanks in advance

N a v a n e e t h9-Dec-07 21:35

display data in list box with multi column

9-Dec-07 21:35

jagadeeshkumar2106 wrote:
how could be done this one sir id how i can make a datatable cache...

if(Cache["SomeName"] != null)
   //Bind data
Else
  //Fetch data
  Cache["SomeName"] = datatable;
  //Bind data

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Piyush Vardhan Singh9-Dec-07 18:42

Piyush Vardhan Singh

9-Dec-07 18:42

I am trying to display data in list box with multi column in asp.net . Can it possible in asp.net
multi column list box . ?

Thanks

Piyush Vardhan Singh

Sun Rays9-Dec-07 18:58

Sun Rays

9-Dec-07 18:58

Hi,
there is one way to do this.

Get query in which you get multi column result.
Then bind dataset to listbox.

Hope it will help you.

Thanks,
Sun Rays

To get something you must have to try once.

My Articles

Piyush Vardhan Singh9-Dec-07 19:32

Piyush Vardhan Singh

9-Dec-07 19:32

thanks for reply
can u give any example

Piyush Vardhan Singh

Sun Rays9-Dec-07 19:41

Sun Rays

9-Dec-07 19:41

Hi,
you can write query like.

SELECT column1 + '-' + column2 AS MyColumn FROM tableName

Now after getting value in dataset. Bind dataset to listbox.

myList.DataSource = datset // which you get from above query<br />
myList.DataTextField = "MyColumn";<br />
myList.DataBind();<br />

Thanks,
Sun Rays

To get something you must have to try once.

My Articles

Michael Sync9-Dec-07 19:00

Michael Sync

9-Dec-07 19:00

Why don't you use GridView or something?

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

N a v a n e e t h9-Dec-07 19:37