ASP.NET

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

n.podbielski

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

n.podbielski

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

n.podbielski

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

3 tier applications in ASP.NET

2-Dec-12 22:03

Hi, I have something I want to understand regarding the oAuth flow in facebook.

I have a facebook application that I created.

When I reach my application site directly (not through facebook) i.e enter my application site URL in the address bar, I reach my application. Let's say: https://myApp.com/fbApp

On the server side there's the oAuth flow ( sending a request for the "code" parameter and then with the "code" parameter another request for the "user access token").

I wanted to know how does Facebook knows who is the user that is making the request for the "code" parameter. I noticed that when I'm loged-in to facebook and I'm going to my site directly (as described above) I'm getting the "user access token" on the server side.

When the first request to facebook is made for the "code" parameter, is their anything else being transferred behind the scenes so facebook knows to identify the current loged-in user?

The 'client id' parameter which is being passed to get the 'code' parameter is the 'app id' which is general to all users so I don't see a user specific info being passed to facebook.

DeepanjanNag2-Dec-12 10:54

DeepanjanNag

2-Dec-12 10:54

I am a bit confused about when to use connected or disconnected classes when creating an ASP.NET application. Tradition 3-tier apps almost always show that the business layer contains BO (business objects) that are nothing but data containers mapped directly from tables. These classes are coupled with BAL (business application layer) classes. The BO gets exchanged between the BAL and DAL (data access layer).
When can we then use DataTables and DataSets then? Should BO be eliminated in these cases? Is there a need to convert a DataTable to a business object in the business tier?

Re: 3 tier applications in ASP.NET

Deflinek3-Dec-12 2:26

Deflinek

3-Dec-12 2:26

IMHO the answer is that you shouldn't use DataTable and DataSet objects at all.
The reason behind using business objects is that (a least in theory) you are not dependant on database. That allows you test your code without db and also think about your code without database context (using "objects" instead of "rows").

Also without additional work, DataTable objects are not strongly typed so you won't find type mismatch errors until runtime.

You know, Entity Framework and similar tools exist for a reason Smile | :)

--
"My software never has bugs. It just develops random features."

Re: 3 tier applications in ASP.NET

AmitGajjar3-Dec-12 18:16