having an impossible time getting asp.net 4.0 to work in any fashion at all. In fact, I completely wiped my server,reinstalled with Server 2008 R2 Standard (running on a VMWare ESXi box, not that it should matter),and cannot even get a test .aspx page to work.
[code]...
The code is from one of our vb pages, but im not concerned about that, im just concerned with the 3 update statements, need to know if there is anyway to write a procedure or query to execute the same logic, but against the entire database table instead of on a per record basis as it is now. Reason being is that we made some updates to the code below to begin capturing a new field when a record is inserted. Well we have 119,000 +/- records in the table that currently DONT have data in the new field. So since the logic below is working the way we want and expect it to work per record, just wanted to see if it can be changed to run against all the records and update them accordingly.
if valueTwo = "13" or valueTwo = "14" then
strSqual = "update trans set trans_response_date='" & TransDate & "' " & strTechSQL & " where (trans_response_date is null or trans_response_date='') and sys_id='"&strSystemID&"' and (trans_type_name='11' or trans_type_name='12') "
getStaticRecordSet(strSqual)
[code]...
We have a need to update all the existing records in the table so that the new field is updated. Can anyone tell me if there is anyway to setup the above update statements to be executed as a global update? And by that i mean, i want to be able to run the update statement and have logic built into it so that it gets the appropriate data to use for each individual record.. i dont want to accidently update every single record with the same data.. that would be a big mess to clean up. There are 2 tables that need to be updated one time, then with the changed made to the page code, those fields would be populate each time a new record is inserted.
So the first table currently has 1177 records that need to be updated. Once that table is updated, then the next table can be updated, this table has 116,635 records that need to be updated with a value from the first table. Then every single record 119,970 has to have its new field populated with the information from the first table.
I have a page on which there is a parent organisation followed by a list of child organisations. To view the data of these child organisations, there is a GO button for each child organisation. I set the ID of the child organisation in a cookie on the click of the GO button. When I come back to the home page, I delete the cookie.
My problem is that in IE 8 the first time the GO button works fine. But when I come back to the home page and click on the GO button of the same child organisation, the ID is not set in the cookie.
This problem does not occur in Firefox at all.
This is the code in JavaScript where I set the cookie and then call my page.
function GetOrganisation(id, path) {
$.get('<%=Url.Action("SetOrganisationID", "AdminSettings") %>', { 'Organisationid': id }, function (data) {
if (data.Success) {
$.get('<%=Url.Action("GetOrganisationDetails", "AdminSettings") %>', { 'Organisationid': id });
[Code]....
I have a link containing ID & name on the URL, based on the ID & name i returned image data from DB via asp.net method. The link is not loading the image first time when the link is clicked, when you refresh again the image comes back.
View 1 Replies[Code]....
FadeIn does not work after the first time
In the login control, the "Remember me next time" checkbox does not appear to work.
If I check it when logging in, when I log in the next time, even a minute later, I go to the login page again.
It seems the cookie is not being written to the client. Can't find it anywhere.
My web.config contains:
[Code]....
I'm wondering building a website like StackOverFlow (approximately the same features using ASP.NET ) How much Work-power and time does it take in your opinion . My boss has asked me to estimate for work-power , time , cost and suitable technologies .
View 6 RepliesWhenever I add an entry to the Hosts file on Windows, it takes a long time for the change to take place? I have tested using Firefox and IE and it seems to take around 5 minutes on both of them before the new IP/Domain entry on Hosts is recognised.
Is there anything I can do to overcome this? Perhaps "refreshing" the cache in some way? ipconfig /flushdns doesn't work.
I cannot use asyncFileUpload as it has too many restrictions which doesn't meet our requirement.
I'm able to add a updatepanel trigger to force the Button1 to perform a postback. after the file uploaded, I need to use a timer to do different tasks and return messages back to client with the timer. That is all fine.
However, when one upload is finished. I try to do it again. The FileUpload1.HasFile is "false". I don't know why. if I remove the timer, at the second time, the HasFile is "true". I think there must be something in the timer and disable the Button1's postback.
page:
[Code]....
Code:
[Code]....
I have a simple GridView with AutoGenerateColumns,Edit and DeleteButton = true
It's data source is a DataTable dynamically generated.
Since i don't want to use object data source, i just catched Delete event and deleted rows from datatable and made a new databind. It works.
I tried to use also AutoGenerateEdit button, but when i click on Edit command field, nothing happes. So i decided to handle by myself edit events, and changed datagrid in this way:
<asp:GridView runat="server" ID="dettaglioprodotti" BackColor="White" BorderColor="#DEDFDE"
I have a gridview 'gvTemplates' that loads from the Page_Load method. It is using a stored procedure and this works fine. Then I do a search function on that gridview and that works fine. So when I click the search cancel button, which calls the same exact code that loads the gridview from Page_Load, I get the dreaded 'Input string was not in the correct format'.How can the exact same code and stored proc work fine the first time but fail the second?Gridview:
[Code]....
I have page
Page contains an accordion control and tab container controls
[Code]....
[Code]....
The whole thing is in a form, and it doesnt postback when this button is clicked. Im no good with javascript, but i got a feeling thats not the problem.
I have a .net 3.5 app that uses forms authentication. I recently decided to utilize the built-in "Remember me next time" on the login screen. I thought it would be a very simple thing (it is a 'built-in' feature afterall). Unfortunately it did not work on the first try. I then spend many hours browsing the Net and reading many posts about problems associated with the feature. My environment is as follows:
client machine: XP SP3, IE8
server: Windows Server 2008, IIS7, application .net 3.5
The relevant sections in the Web.config in the root of the app directory:
[Code]....
My web application has hosted on the canada server but my all clients are indians.So, as I am using System.datetime.Now to store all the dates in application.Obviously, it is displaying the canadian time instead of india time.How can i do it?Is there not any gloabl settings that we can do in our web.config file so that it indicates to the server at run time which time zone to execute..?Or any other suitable alternate?
View 3 Repliesi have to listen my mail server for every 30 min. i have a distribution list and i want to count number of email comes for that distribution list and no of replies goes from the outlook for every 30 minutes. also i need to get the time difference between the replied time with arrived time of the mail. so show me some sample code
View 3 RepliesAnyone know how to format a TIME COLUMN in SQL 08 to regular time and not military time? VB.net
View 2 RepliesI'm using Telerik's RadScheduler Control with WebService Binding.
I've used RadScheduler with Server Side Binding which has an event called "OnTimeSlotCreated" which fires every time when a particular time slot creates so that i can access the time slot and get the control (HtmlTableCell Control) to modify it according to the requirement.
But now i'm binding it from client side through WebService which has no such "onClientTimeSlotCreated" event, also these time slots are not having any identity at client side to access.
how to suppress the "AM" in the gridview (template Bind("RideTimeMin", "{0:t}")? Don't tell me to use military time because the function is not "time on a clock"; it's how much time is allowed for a task (in this case the min/max hours & minutes that horses have to complete a 20 mile trail; e.g. 05:00, 05:27, etc). I'm currently accomplishing this in the "ondatabound" function by "..RTmin.Replace("AM","")". I have looked and looked at all the websites that talk about datetime formatting but have yet to find a way to do it upfront in the gridview bind statement.
View 6 RepliesI have created a crystal following your article which url is
[URL]
It is working fine on local machine but when i upload it on the server it is not working. Crystal Report is showing but data is not showing in the crystal report.
I am working on a multi-language web site. It is half English and half Portuguese. I have created forms that have portuguese values in it. These forms work perfectly on my desktop. I'm using Cassini as the development server. When I move them over to IIS, they are not loading properly. The text comes up all weird looking. I am declaring the culture in the page attribute: Culture="pt-BR"
View 4 Repliesi'm trying to make this work for several days but it just doesn't work.
this is my code:
aspx page:
[Code]....
webservice:
[Code]....
this was downloaded from this website.
the problem is that the page loads fine but no autocomplete occurs.
In my asp.net application I user Microsoft Membership to manage site access security and find the time saved into LastLoginDate is ahead of local time (Eastern Time Zone) 3 hours. What is wrong with it and how to ajust it to local time by application system only such as changing some properties od application?
View 2 RepliesI need to do to the following:
Find if the current time falls within hourly ranges and display the start hour and end hour of that range in labels.
Examples:
If the current time is 8:46am, label startTime would return "8am" and label endTime would return "9am"
If the current time is 10:01pm, label startTime returns "10pm" and label endTime returns "11pm"
If the current time is 12:59am, label startTime returns "12am" and label endTime returns "1am"
I have been working with the C# TimeRange class but not getting what I need.
select distinct tbl.emp_code, b.EmplName, convert(varchar, tbl.punched_date,101) as Punched_date,
(select convert(varchar(8),itbl.PUNCHED_TIME, 114)+', '
from Trn_Capture_Data_New itbl
where itbl.EMP_CODE=tbl.emp_code and itbl.PUNCHED_DATE=tbl.punched_date and itbl.EMP_CODE='4'
and tbl.punched_date >= '03/27/2013' and tbl.punched_date <= '03/28/2013'
for xml path('')) Punched_Time
[Code] ....
I have the above query and that gives me result
Emp_code EmplName Punched_date Punched_Time
4 XXX 3/27/2013 14:22:00, 09:44:00, 10:38:00, 11:01:00, 16:12:00, 18:25:00,
4 XXX 3/28/2013 13:14:00, 09:49:00, 18:02:00,
Now i need to Bind it to gridview, the gridview columns should be
Date,IN,OUT,IN,OUT
In punched time the first one should be IN and second OUT. A employee would have punched several time a day. Based on that I should take maximum punches and bring that of columns as IN and OUT in gridvew dynamically. How to achieve this?