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, 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.
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.
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?
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
"My software never has bugs. It just develops random features."
I have a gridview with a checkbox column, i select a checkbox in a row and click edit button after that, edit button click_event i wrote this:
but it has error, and i cant access to "WorkTimeID"
my codebehind is :
I want to create two textboxes in a table row , each time on click of asp.net button control.But i am unable to do so. I searched for it.It deals with page life cycle. but confused with which can do the job like preinit or load event? if possible give me some sample code.