|
thats what i am trying to do is to capture the case of computer crashes.
Thanks
Nancy
|
|
|
|
|
I use a different approach that might work for you. In your code right before you run your select statement (to databind a grid or whatever) call a stored procedure to unlock records.
Here is an example of the proc I use. It unlocks any record locked by the current user or any record locked over 20 minutes. After I unlock the records I populate the grid for my user. The session end event does not get called if the aspnet process gets recycled (which can happen).
<br />
create proc<br />
[dbo].[uspUnLockItems]<br />
(@User varchar(50))<br />
as<br />
<br />
update dbo.workItems<br />
set lockedBy = null,<br />
lockedTime = null<br />
where <br />
lockedBy is not null<br />
and<br />
(<br />
lockedBy = @User<br />
or datediff(minute, lockedTime, getdate()) > 20<br />
)<br />
|
|
|
|
|
thanks very much for your help. One more thing, in this case, means if a user has opened a record for over 20mins,it should redirect to a session time out page. but how do i detect if its been time out in aspxpage?
Thanks
Nacy
|
|
|
|
|
In that case you need a javascrip timer.
Read through the posts here for some examples.
|
|
|
|
|
Hi Friends,
In .NET there are two kind of variables. One is stored in HEAP (objects) .. some are in Stack. Now how these memory is clened. Who takes care of Stack and Heap once the execution is over.
Thanks,
Arindam D Tewary
|
|
|
|
|
The memory allocation in the stack is done when a method is called, and the stack is restored when the method returns.
The heap is managed by the garbage collector. At certain intervals it runs a sweap that removes unused objects.
---
single minded; short sighted; long gone;
|
|
|
|
|
Thanks Guffa.
Thanks,
Arindam D Tewary
|
|
|
|
|
hi! i want to use window form in webform project(asp.net).Is it possible?if so plz send possibilities and suggestions.
Thanq...
Neelima
|
|
|
|
|
right click on ur prj -- select add existing item
add the windows form u want to add....
open csproj file in textpad....
add the following code....
<file
relpath="Form1.cs"
="" subtype="Code" buildaction="Compile">
<file
relpath="Form1.resx"
="" dependentupon="Form1.cs" buildaction="EmbeddedResource">
u can easily identify the place where u hav to add this code....
and change the namespace in windows form to ur webapplication's namespace...
create the instance of ur form in webapplication...use it....
donno whether this procedure is correct or not....
it worked fine with my application....
check it with some other xperienced guys around....
thanks...
mareers.....
sreeram
|
|
|
|
|
right click on ur prj -- select add existing item
add the windows form u want to add....
open csproj file in textpad....
add the following code....
<file
relpath =="" "form1.cs"
subtype="Code"
buildaction="Compile"
="">
<file
relpath =="" "form1.resx"
dependentupon="Form1.cs"
buildaction="EmbeddedResource"
="">
u can easily identify the place where u hav to add this code....
and change the namespace in windows form to ur webapplication's namespace...
create the instance of ur form in webapplication...use it....
donno whether this procedure is correct or not....
it worked fine with my application....
check it with some other xperienced guys around....
thanks...
mareers.....
sreeram
sreeram
|
|
|
|
|
Hi All,
I need to calculate Age from today's date in the specific format:
Today's Date: 08/03/2007
BirthDate: 16/11/2005
Age: 01 yrs 03 months 20 days
It should consider leap year also.
Thanks in advance...
|
|
|
|
|
function HowOld(day,month,year,thisDay,thisMonth,thisYear) {
var yearsold = thisYear - year, monthsold = 0, daysold = 0, string = '';
if (thisMonth >= month) monthsold = thisMonth - month;
else { yearsold--; monthsold = thisMonth + 12 - month; }
if (thisDay >= day)daysold = thisDay - day;
else {
if (monthsold > 0) monthsold--;
else { yearsold--; monthsold+=11; }
daysold = thisDay + 31 - day;
}
if (yearsold < 0) return '';
if ((yearsold == 0) && (monthsold == 0) && (daysold == 0))
return '';
if (yearsold > 0) {
string = yearsold + ' year';
if (yearsold > 1) string += 's';
string += ' ';
}
if (monthsold > 0) {
string += monthsold + ' month';
if (monthsold > 1) string += 's';
string += ' ';
}
if (daysold > 0) {
string += daysold + ' day';
if (daysold > 1) string += 's';
string += ' ';
}
return 'Age - ' + string;
}
and this function shud be called in the following way...
document.write(HowOld(1,1,1900,4,10,1997));
which returns...
Age - 97 years 9 months 3 days
hope this is fine with u....
thnks....
..........mareers..........
|
|
|
|
|
Thanks Mareers for the reply but its not working as its giving 0 yrs..
Please help.
|
|
|
|
|
hiiii,
Below script may be usefull try this out :
<script type="text/javascript">
function CalcAge(date)
{
day = date.substring(0,date.indexOf("/"))
month = date.substring(date.indexOf("/")+1,date.lastIndexOf("/"))
year = date.substring(date.lastIndexOf("/")+1,date.length)
var currentTime = new Date()
var currmonth = currentTime.getMonth() + 1
var currday = currentTime.getDate()
var curryear = currentTime.getFullYear()
tempday = currday - day;
tempmonth = currmonth - month;
tempyear = curryear - year;
if(tempday < 0)
{
if(tempmonth < 0)
{
tempmonth = (currmonth + 11) - month;
tempyear = tempyear - 1;
tempday = calcDays(currday,day,(tempmonth - 1));
}
else
{
tempday = calcDays(currday,day,(currmonth - 1));
tempmonth = tempmonth - 1
}
}
else if(tempmonth < 0)
{
tempmonth = (currmonth + 11) - month;
tempyear = tempyear - 1;
}
var age="";
if(tempyear != 0)
age = tempyear +" year(s) ";
if(tempmonth != 0)
age += tempmonth +" month(s) ";
if(tempday != 0)
age += tempday +" day(s)";
document.write(age)
}
function calcDays(currday,day,currmonth)
{
if(currmonth == 2)
{
return( (currday + 28) - day)
}
else
{
if(tempmonth % 2 == 0)
{
return( (currday + 30) - day)
}
else
{
return( (currday + 31) - day)
}
}
}
</script>
cal the function like this : CalcAge("16/11/2005");
Regards,
Sandeep Kumar.V
|
|
|
|
|
in my form i am using a linkbutton to logout . On click of which i am abondaning the session and redirecting the user to login page.
I AM DOING LIKE THIS
<asp:LinkButton ID="LnkLogout" runat="server" onclick="LinkButton1_Click" >Logout </asp:LinkButton>
ON CODE BEHIND
protected void LinkButton1_Click(object sender, EventArgs e)
{
Session.Abandon();
Response.Redirect("Login.aspx");
}
but instead of going into this side it does some javascripting dopostbackwithoptions() function and does postback on same page and control goes to the first control which is my textbox on the same page; why it is happening so.
-- modified at 3:59 Thursday 8th March, 2007
|
|
|
|
|
Your can not set the session via javascript.
If you would to this kind of implementation then use Cookies And then u can any thing one client side.
Parwej Ahamad
g_parwez@rediffmail.com
|
|
|
|
|
nothing of a sort like session in it .iT IS JUST POSTING BACK ON THE SAME PAGE.
|
|
|
|
|
You can don one thing------
LogoutLinkButton.Attributes.Add("onclick", "window.location.href =('samepage.aspx')")
if u r not save the user information in sessino variable.
if you use the user information in session variable then it's not possible.
in that case use the cookies and then use the above method and remove the user information from the cookies.
-- modified at 4:46 Thursday 8th March, 2007
Parwej Ahamad
g_parwez@rediffmail.com
|
|
|
|
|
The _doPostBackWithOptions is part of the ASP.NET post back method and would normally happen.
Do you have any validation controls on this textbox? It could be the validation is failing, you need to set ValidationGroup on the inputs or you can set CausesValidation on the LinkButton to false.
|
|
|
|
|
Hi,
I am writing a web app in ASP.Net 2.0 and server side C#.
what i am trying to achieve is this:
multiple users work of a gridview and user A selects a row in the gridview to work with,
now when user B selects the same row while user A is still busy with that row, user B must be notified that that specific row is in use by another user.
A notify message or a row lock or anything to prevent user B from working with the same record as User A.
Does anyone have any idea how i could work around this one?
Thanks alot
Kind Regards
GermanD
|
|
|
|
|
Yeah, here is what I do.
First of all, here are two sql procs
<br />
create proc<br />
[dbo].[uspLockItem]<br />
(@workItemId int, @User varchar(50))<br />
as<br />
<br />
update dbo.workItems<br />
set lockedBy = @User,<br />
lockedTime = getdate()<br />
where workItemId = @workItemId<br />
<br />
<br />
<br />
create proc<br />
[dbo].[uspUnLockItems]<br />
(@User varchar(50))<br />
as<br />
<br />
update dbo.workItems<br />
set lockedBy = null,<br />
lockedTime = null<br />
where <br />
lockedBy is not null<br />
and<br />
(<br />
lockedBy = @User<br />
or datediff(minute, lockedTime, getdate()) > 20<br />
)<br />
Lock the first record when the user loads the page to work on it.
Unlock right before you get data for your grid.
On item databound method or whereever you bind your grid
<br />
LinkButton lb = (LinkButton)e.Item.FindControl("lbEdit");<br />
<br />
if (drv["lockedBy"] != DBNull.Value)<br />
{<br />
lb.Enabled = false;<br />
lb.ToolTip = "Policy locked by " + drv["lockedBy"].ToString();<br />
}<br />
|
|
|
|
|
Hi i have One TextBox control,i want to compae the textbox value to a variable which is declared as public in the service side if the textbox value is grater than that serviece side variable the page has to submit when i clik on the button other wize the should not submit to the server Can Any buddy Plz help me out in this ,Plz
Thnks &Regards
Annup
|
|
|
|
|
Compare the value in client side.
For that you can
1. Declare a
2. Assign the server variabl'es value to the above control element using some javascript at the end of the HTML ie once the page is loaded fully..
3. Write a clientside on-click event and check textbox value. You must have onclick="return ValidateTextBoxvalue()" .... if you omitreturn statement any server side button submit the page everytime.
Thanks,
Arindam D Tewary
|
|
|
|
|
I have developed my asp.net 2.0 with vb2005 and sqlserver 2005 on WIndows XP. I have created a virtual directory from IIS mapped to teh website folder.
I want to test this site on a Local Area Network(Workgroup).
I tried something like this from one of the pc on the network by typing in internet explorer
http://192.168.1.5/ASPLearning/Default.aspx
where 192.168.1.5 is teh IP address of the IIS Computer
ASPLearning is the website Name as given in IIS
The page did not display.
Please is there anything i need to do? pls help
t.aransiola
|
|
|
|
|
hi
can any body explain what is the difference between carriage return (\r) or you can say Enter and New Line character(\n)..
both are treated as same..
in .net(c#) if you write a file using stream writer
like this.
StreamWriter writer=new StreamWriter("c:\\test.txt");
writer.Write("Hello\r\n------\r\nHow are You.");
writer.Close();
will print this..
Hello
------
How are You.
or if you use
StreamWriter writer=new StreamWriter("c:\\test.txt");
writer.Write("Hello\r------\rHow are You.");
writer.Close();
then the results will again be same as
Hello
------
How are You.
and finally if you use like this
StreamWriter writer=new StreamWriter("c:\\test.txt");
writer.Write("Hello\n------\nHow are You.");
writer.Close();
then again the result will be same as
Hello
------
How are You.
then what is the difference between \r and \n
please explain
regards
Vishal
Thanks & Regards
Vishal Sharma
vishalsharma556@yahoo.co.in
|
|
|
|