|
1 - here[^] you go
George_George wrote: what is SQL Server session? Do you mean SQL Server connection? Smile
NO. Session can be kept on SQL server database. Usefull for applications hosted on webfarms.
|
|
|
|
|
Thanks Navaneeth,
I like the link you recommended. I have a further question, it is useful to use SQL server or use ASP.Net state process if I only have one web server (not a server farm)? I am not sure whether SQL server or use ASP.Net state process are solutions specifically for multiple server (server farm) environment?
regards,
George
|
|
|
|
|
Hi,
I need to post my application 's link to orkut (scrapbook or profile) by getting orkut username & password from the user & post my application's link in his orkut scrapbook or profile.
Note:
In this following link
http://www.quibblo.com/quiz/3b_qEvo/Have-you-finished-your-Holiday-gift-shopping-yet
To the right side of the page you can see YOUR QUIZ TITLE WILL GO HERE ,below that option are there to post the current link to orkut,...i need to implement that functionality ... ie i need to post my application link to orkut)
Please help me with regard to the problem.
|
|
|
|
|
prabhuch85 wrote: I need to post my application 's link to orkut (scrapbook or profile) by getting orkut username & password from the user & post my application's link in his orkut scrapbook or profile.
I don't think you will able to do it unless orkut provides you some web services.
|
|
|
|
|
Hi i wanna to implement rating system for my web page
with same user can vate only onece
|
|
|
|
|
use some database to track the user whether he voted or not corresponding to the specific item.
You can also save the IPaddress to prevent more than one post from the same IP.
Cheers!!
Brij
|
|
|
|
|
|
There's no reasonable way of doing this without expecting people to log into your site before they are allowed to vote.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
AJAX toolkit comes with a rating control. Try that
|
|
|
|
|
My web server is not my country, so server's time and my country time is
different.
So code runs on server,
for example when I run DateTime.Now() function
it returns server time but I want to get my local time.
Is there a way to do that?
Every Successful Person Have A Painful Story
|
|
|
|
|
Yes, You need to learn about CulterInfo Class .
Read This[^]
|
|
|
|
|
Perhaps you can convert a DateTime to UTC using the DateTime.ToUniversalTime method
Parwej Ahamad
|
|
|
|
|
You asked this the other day and you were given at least one useful answer. Instead of trying it, or asking about it, you just post the same question again. Did you try what was suggested ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
i want to store null in database in field having datetime datatype
but i am not able to do it
i tried this
convert.toDateTime(null)
i am get this error
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
with regards
rahul
|
|
|
|
|
OK - this means that your DB will only accept a date. You should change the DB so it will take null, or you should sanitise your input. Either way, Convert.ToDateTime(null) is a nonsense. You should pass in DbNull.Value, or null, whichever works, to store null.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
my DB takes null
i have tried what u said but it doesn't works
with regards
rahul
|
|
|
|
|
Do you mean what I said here, or in the other thread you started as a different user ?
If your DB takes null, then you won't get an error if you insert null. But Convert.ToDAteTime(null) is a nonsense, that won't work.
What did you try, and what happened ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
DateTime? arivalDate = null;
DateTime? departDate = null;
fun(arivalDate,departDate)
public void fun(object Date_Start,object Date_End)
{
if (Date_Start == null)
{ cmd.Parameters.AddWithValue("@Date_Start",System.Data.SqlTypes.SqlDateTime.Null);
}
else
{
cmd.Parameters.AddWithValue("@Date_Start", Date_Start);
}
if(Date_End == null )
{
cmd.Parameters.AddWithValue("@Date_End", System.Data.SqlTypes.SqlDateTime.Null);
}
else
{
cmd.Parameters.AddWithValue("@Date_End", Date_End);
}
}
|
|
|
|
|
amit sahu20 wrote: public void fun(object Date_Start,object Date_End)
This is ridiculous. Why pass an object and not a DateTime? ? Then you can use .HasValue, and generally write nice code.
Have you set a breakpoint to see which code executes ? Have you tried DbNull.Value ? I wonder if SqlDateTime is a type for SQL Server only ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
i did what u said
if (Date_Start == null){
cmd.Parameters.AddWithValue("@Date_Start",System.Data.SqlTypes.SqlDateTime.Null);
}
but i am geting error
System.Data.SqlClient.SqlException: Error converting data type nvarchar to datetime
with regards
rahul
|
|
|
|
|
i am doing this
DateTime CompletionDate;
if (txtCompletionDate.Text != "")
{
CompletionDate = Convert.ToDateTime(txtCompletionDate.Text);
}
else
{
CompletionDate = null;
}
and passing this CompletionDate to Store procedure
but i am getting error
cannot convert null to datetime
with regards
rahul
|
|
|
|
|
use it before pass to DB
if (CompletionDate == null)
{ cmd.Parameters.AddWithValue("@CompletionDate",System.Data.SqlTypes.SqlDateTime.Null);
}
else
{
cmd.Parameters.AddWithValue("@CompletionDate", CompletionDate);
}
and also in DB "CompletionDate" field shulid allow null
|
|
|
|
|
Oh, you were answering, not asking. The code you posted is still messy, even if SqlDateTime.Null works.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
in DB completiondate allows null
but it still gives same error
with regards
rahul
|
|
|
|
|
How do you know it allows null ? In any case, your error is not that null is not allowed, but that the date object is broken. I think you need to make your code typesafe, walk through with the debugger and see what date is passed in. You also need to fix your code where it is prone to breaking.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
