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.
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.
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
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.
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.
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
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.
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.
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.