ASP.NET

AmitGajjar3-Dec-12 18:11

3-Dec-12 18:11

Basically Viewstate maintain all this information about current page of the grid. check if it is not disabled for you. another way is, you can also store page number in the session and update only when next,previous ,first, last button click or grid is refresh.

hope this will help you.

Thanks
-Amit Gajjar (MinterProject)

rakeshs3123-Dec-12 21:28

rakeshs312

3-Dec-12 21:28

thanks

n.podbielski4-Dec-12 8:38

4-Dec-12 8:38

Never ever do that. I did twice and 2 diffrent apps and it was always mistake to store anything in session besides some user data valid to user not for some page. For example in one grid there was date filter. Stored in session and empty this caused app to crash in that particular page.

No more Mister Nice Guy... >: |

AmitGajjar4-Dec-12 15:20

4-Dec-12 15:20

As i said that, session is not preferable. but it is an alternative. from each and every scenario we need to check if page number is updated correctly.

Thanks
-Amit Gajjar (MinterProject)

n.podbielski4-Dec-12 20:29

4-Dec-12 20:29

Why not control state? It suppose to work even with view state disabled. Or hidden field? In that way page will be set to one in case of page refresh as user would expect.

No more Mister Nice Guy... >: |

AmitGajjar4-Dec-12 20:46

4-Dec-12 20:46

Disable the viewstate and change the grid page. it will not work.

Thanks
-Amit Gajjar (MinterProject)

n.podbielski4-Dec-12 20:59

4-Dec-12 20:59

So why even bother to use something else then view state?

No more Mister Nice Guy... >: |

AmitGajjar4-Dec-12 21:19

4-Dec-12 21:19

That's what i said in my answer. if it is disabled, then paging will not work.

Thanks
-Amit Gajjar (MinterProject)

n.podbielski4-Dec-12 23:45

4-Dec-12 23:45

Ok. So this discusion is pointless.
Take care Smile | :)

No more Mister Nice Guy... >: |

CommDev8-Dec-12 23:15

CommDev

8-Dec-12 23:15

Hi,

I think you can try to record the page index (a hidden controls or others), and in your click event, the gridview should turn to that page first.

Comm100 - Leading Live Chat Software Provider

modified 28-May-14 1:49am.

SQL query in c#

AnirbanM 23-Dec-12 2:31

AnirbanM 2

3-Dec-12 2:31

I'm having one web application where within loop I'm running one simple sql query (SQL Server 2008).

Select SNo, NoOfDays, [Month], [Year], [Days], [Holiday] From DaysMonth Where rtrim(Period)='Input' order by ToDate

Based on this query, populating one gridview and then creating records in a new table with other user input.
Now, out of 100 times it's running, 95-98 times it's giving accurate results, however, to my astonishment, sometimes sorting 'Order by' not working and producing abnormal sorting behavior. Like instead of 1st January to 31 January, it's returning 10th Jan-31st Jan then 1st Jan to 9th Jan (just for example). I got puzzled, because I can't do anything to change code, as it's working fine most of the time. Can you suggest some reason behind it which is beyond the code. As the data entry is huge, and it's multi-user environment, getting very difficult to monitor which one query going wrong. In that case, if I delete entries from new table, second time, it's giving perfect result. Please help me and thanks in advance to all.

Richard MacCutchan3-Dec-12 2:36

Richard MacCutchan

3-Dec-12 2:36

You already posted this in the C# forum, which is also not the correct place. This is a Database query and belongs in that forum.

One of these days I'm going to think of a really clever signature.

AnirbanM 23-Dec-12 2:47

AnirbanM 2

3-Dec-12 2:47

Richard, I already deleted this question from C# forum. As you are suggesting, I think this is not related to SQL Server and it's muti-user web environment state management related problem. Anyway, if you think so, can I keep this question under this category and create a new thread in Database forum? Thanks for your suggestion.

Richard MacCutchan3-Dec-12 2:50

Richard MacCutchan

3-Dec-12 2:50

Even if it was related to SQL Server, it has nothing to do with either C# or ASP.NET. It's pure SQL and you need to give some more information about the field you are using to sort on: i.e. its type and value.

One of these days I'm going to think of a really clever signature.

AnirbanM 23-Dec-12 2:56

AnirbanM 2

3-Dec-12 2:56

okay agreed. So I'll delete it from here and create under SQL. However, just to answer your query, 'ToDate' field is a 'Date' type field, not DateTime type. User input Period is a varchar type field, input value like 'January,2012'. Thanks

state management

Member 80319152-Dec-12 23:12

Member 8031915

2-Dec-12 23:12

I have 100 text boxes in my webpage and i want transfer values from one page to another pages in asp.net without using session variable, because i do not want to use 100 session variables, is there is any techniques in asp.net and C#. which make its easier.

ThetaClear2-Dec-12 23:19

2-Dec-12 23:19

You don't have to use session variables. (session object)
one way is to just give a name for each textbox field ( use only pure HTML tags) and prefix or use a suffix to each name. when you submit the page to the server you can just iterate through the values in the Form collection and then use Server.Ttransfer.

Member 80319152-Dec-12 23:26

Member 8031915

2-Dec-12 23:26

suppose i have 100 text box in page and i am transfer value one page to another using session variable but problem is
that i m using so 100 session variable for this but i want i m use only one how can it possible please tell

ThetaClear2-Dec-12 23:37

2-Dec-12 23:37

In the previous post you mention that you don't want to use session variable and now you are saying that you do want to use session variable but only one. Please explain yourself more clearly.
You can use only one session variable if you, lets say, set a List or Dictionary in a session variable with all the values.

Member 80319152-Dec-12 23:48

Member 8031915

2-Dec-12 23:48

in my last technical interview they asked me "if i have 100 text boxes any i want to send data from one page to another page, how could you send data from one page to another" and i told them that i'll use session object, then they told me that it means we have to use 100 session object. so there is any technique in which we can use session object just like as array.

ThetaClear3-Dec-12 0:02

3-Dec-12 0:02

See my first reply. It don't use any session object there.
If you have 10 input tag of type text with name attributes: txt1, txt2, txt3...
After you submit the page to the server you use Request.Form[txt1], Request.Form[txt2]....
No session object.

AmitGajjar3-Dec-12 18:15

General understanding how facebook knows who is the user who is making a request for the 'code' parameter

3-Dec-12 18:15

If you want to transfer all the values using postback then you can use Page.PreviousPage method to get the previous page controls and it's information.

Please check MSDN Article[^]

Thanks
-Amit Gajjar (MinterProject)

ThetaClear2-Dec-12 22:03