What changes to the function below are needed to achieve those requirements:- If you pass the same date, then 1 will be returned as the number of days- Return '5' when passing 18.10.2010 to 22.10.2010 (Mo-Fr.)- Return '0.5' when passing same date with (n) hours difference e.g. from 18.10.2010 08:00:00 and 18.10.10 12:00:00 (maybe I should ask start a new threand for this last one)
[Code]....
I am using a grid form to diplay data... the insert form is completely a separate form. In the insert form a text box called "FormPercentageTextBox" is getting a calculated result using javavascript based on some field ( field1,field2) values (val1, val2).
the problem i have is: when i edit the form and i want to update any value..i want the new calculation result showing on the edited "FormPercentageTextBox" field. I need to have this calculation reflected/
i need trigger function for update. if a change value of a column in one table. The value of different column from the second table should update the value in the third table.
View 18 RepliesAs far as I can see there are only client events on this container, and I need to update a gridview when the user changes tabs.
View 2 RepliesI have below sql statement wich don't work. It don't come up with an error but votepercentage is 0 and when I calculate it manually it should come up with
Dog = 5/9*100 = 55,55
Cat: 4/9*100 = 44,44
in votepercentage
My code:
[Code]....
The result for above code:
Dog 5 0
Cat 4 0
I triple checked that questionAnswersCount is 9 Anyone who can tell me what is wrong with this line:
(CASE WHEN pa.answersCount = 0 THEN 0 ELSE Convert(decimal, ((pa.answersCount/pq.questionAnswersCount) * 100)) END) as votepercentage
is there a function for adding days to a date value within a stored procedure?If I had a field with a start date and a field for duration which would be how many days the even lasts....like if I wanted something like this:TableName.StartDate, DateAdd(TableName.StartDate, TableName.Duration) as EndDate, etc
View 4 Repliesmy requirement is like i want to insert data to table after caliculation like table name salaryhike columns salaryinput,20%hike, 25%hike and 30%hike salaryinput column details to be input by the user and hike is to be caliculated and inserted with 20%hike, 25%hike and 30%hike are columns of same table.
View 4 Repliesc#/vb webapp. I'm working on a very old app with a ton of pages. I want to add a function to every page's PreRender. If this application was designed properly from the start, it would use a MasterPage, or would at least inherit all pages from a BasePage other than System.Web.UI.Page.The goal is that every aspx page's PreRender should trigger a call to FooFunction(). I'd like to have this done all in one page, to avoid opening every single .aspx file and changing it's inheritence / pasting FooFunction() / some other time waster.Is there a way to do this in .net? Can you point me in the direction of any design/discussion articles?
View 5 RepliesI have the following function that works great. The screen Dims until the response is returned to the user. However, because the process could be quite long, I have been asked if I can place a progress bar in the middle of the screen whilst it's dimmed to give the user an idea of how long the process is going to take and so that they dont think the browser has hung.
Can anybody suggest a good Progress bar plug in with an idea of how to implement into my existing function. I'm using VS2010.
[Code]....
I am using Ajax CalendarExtender , the calendar work well. I want to hilight and tooltips holiday that I define on calendar. I found some similar post , but failed to work. Below is my code.
<asp:TextBox ID="TextBox2" runat="server"
style="color: #333333"></asp:TextBox>
<cc1:TextBoxWatermarkExtender ID="TextBox2_TextBoxWatermarkExtender"
runat="server" Enabled="True" TargetControlID="TextBox2"
WatermarkText="--Select Here--">
</cc1:TextBoxWatermarkExtender>
<cc1:CalendarExtender ID="TextBox2_CalendarExtender" Format="yyyy-MM-dd" runat="server"
Enabled="True" TargetControlID="TextBox2">
</cc1:CalendarExtender>
Code Example:
$(document).ready(function() {
txtchangefunction();
});
function txtchangefunction(
$(".textCssClass").change(function () {
....});
or $(".textCssClass").bind('change', function())
both work for Chrome etc. but not IE8. no console error comes out.
I am looking to create a simple windows program that would allow users to calculate their holiday entitlement based on a few simple rules (length of service, job grade, % full-time). Users would use drop-down lists to select their relevant fields, and the holiday entitlement would be calculated from the values given. For example, someone at job grade '1' with 2 years of service gets 25 days a year, whilst someone else on job grade '1' with 4 years service gets 28 days. Is this sort of program possible in Visual Studio 2008?
View 5 Repliescan we change the language of an existing project or of any windows form or any web form such as from visual basic to c sharp
View 7 RepliesJust want to have normal and Large Text for vision impaired users.
does anyone have any decent ideas about how to do this ?
I am working on Vs2005 and asp.net 2.0. I have a solution with 4 projects (business object, components, data access, webclient)When I change any existing method or property in Business object or data access, it is not reflecting in the application. I have deleted the existing references to the project and added them after the new build. I always get errors like "method not found or No overload method "It seems like old verion of dll is still there in the reference.
View 7 Replies<asp:LinkButton CssClass="button" ID="btnApply" runat="server" OnClick="btnApply_Click()" OnClientClick="Apply1('btnApply')" >
hi ihave this functin in .vb file
Protected Sub btnApply_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnApply.Click
end sub
and javascript function also in aspx
function ApplySummerization(id)
{
alert("hai");
}
is asp.net compiler change the name of public methods that declares in "web control"?
View 1 RepliesI have a small database, with a very small number of users. The passwords were stored as clear as the database was so small and held no sensitive data. The database is now to be expanded and passwords are required to be encrypted. I can change the Password Format in the web.config, but is there a way to change the existing passwords from clear to encrypted?
View 1 RepliesI Getting A Problem In DataGrid's ItemDataBound Event. I Am Calling A JavaScript Function In DataGrid's ItemDataBound Which Retrun The CellIndex And RowIndex Number On Which UserClick After That I Am Re-Binding The DataGrid With jQuery Function After That ItemDataBound Event Not Working. I Want To Call The Same Function Again. Is Their Any Method To Call A Server-Side Function On ItemDataBound Event Except Client-Side Function..
View 4 RepliesThis has got to be easy, but has got me stumped.How do I change an element on screen several times in one function?I want to change a label to read something like "starting..." at the beginning of my function, then go away and do some stuff and then change the label to "finished" at the end.
errorMessage.Text = "Three...";
System.Threading.Thread.Sleep(1000);
errorMessage.Text = "Two...";
System.Threading.Thread.Sleep(1000);
errorMessage.Text = "One...";
System.Threading.Thread.Sleep(1000);
errorMessage.Text = "Go!";
System.Threading.Thread.Sleep(1000);
I have two sql tables.
- (Fields:PersonID, FirstName, LastName, Role, Department)
and
- (fields: PersonID, Unit).
I want to merge those with a single table ( Fields:PersonID, FirstName, LastName, Role, Department, Unit). How can I query to accomplish this so that same personID data go to same row ? ANY QUERY ?? (I have an idea : both export to excel and merge into a single excel file and import to SQL table but due to very long data it was truncated last time when importing so I don't want to reimport again.)
I have following issue: I have a datatable with a column which I would like to encrypt. This table has about 10.000 rows, and this particular column is storing 14 digit keys. Is there any way to encrypt all those keys in this particular column (just to make them useless if someone steals by db)?
View 6 RepliesI am writing my first AJAX enabled page. Basically I am trying to expand out the lines of a Purchase Order (PO) using our company database. What I want to do is have a button that will that will call on a javascript to update a div field with a table for the PO lines of that PO and at the same time change the function that is called by the button to a function that will collapse the list. How would i do this?
I have tried the line in javascript:
document.getElementById('Button ID').onclick=CollapsePOLines(POID)
However it doesnt seem to change the onclick event for that button, it doesnt throw an error though.
I need change htmleditor height in javascript function in pageload.
View 2 RepliesI have an application in Asp.net and using sql server to store user information. There is a table named dbo.member which stores user information - fname, lastname, email, phone etc. We use LDAP for authentication. The entire application works on this member table. There is a unique userid(not password) associated with each member. I installed default aspnet_membership, aspnet_role tables by running aspnet_regsql.exe utility. Now with increasing number of applications, handling members' information is becoming nightmare. I hope Membership providers will solve this problem but I have doubts.
How can I integrate existing member table with default aspnet_membership table? Or should I integrate since it is very limited? Same is the case with aspnet_Profile - it is very limited and I have stored all profile information into member table. We store more information and we want to query all that information for a user. Should I create my own provider that will use dbo.Member table instead of dbo.Membership table and also with Profile provider?