|
try this one:
\d\d?/\d\d?/\d{4}
|
|
|
|
|
Even if you use a reg expression I would suggest using System.DateTime.TryParse.
You don't want to save something like "2/30/07".
|
|
|
|
|
how i can sotre oleboject in sql oracle mysql which data type i have to use in each technology
|
|
|
|
|
nikhil1234 wrote: i want to store oleobject
What do you mean by "oleobject"? Is this just binary data?
nikhil1234 wrote: sql mysql oracle which data type i ahve to use for each
In SQL Server binary data can be stored in an image column in SQL Sever 2000 or a varbinary(max) column in SQL Server 2005.
MySQL and Oracle may have their own binary or blob (Binary Large OBject) types.
|
|
|
|
|
Hi
I am looking to control database concurrency by inserting a row in database containing session(userid), it checked against the table to see if the record is display only or editable. My problem is what if the app/computer shut down and the app not close properly, the record will be logged in the table.
What i need is something that would fire an action to remove the row whenever there is a close down of the app. I could use session_end but it just fire the action when session end, but what i want is when application end.
Please help.. Very urgent!!
Thanks
Nancy
|
|
|
|
|
I take it your using a Global.asax file for the Session_End? You can also define an Application_End method. However if the app doesn't close properly (eg the computer crashes) my guess is this isn't called.
|
|
|
|
|
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.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
