|
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.
|
|
|
|
|
This is messy. What if the text entered cannot be converted ? This code is fragile and not production quality, on many levels.
I need to see the code that throws that error, in order to comment on it.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
DateTime? StatusDate,CompletionDate;
if (txtStatusDate.Text != "")
{
StatusDate = obj.ConvertStringToDate(txtStatusDate.Text);
}
else
{
StatusDate = null;
}
i am get error in below code
public Boolean InsertTask(string oprtype, object StatusDate)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlcommand = "DailyReport";
DbCommand dbcommand = db.GetStoredProcCommand(sqlcommand);
db.AddInParameter(dbcommand, "@oprtype", System.Data.DbType.String, oprtype);
if (StatusDate != null)
{
db.AddInParameter(dbcommand, "@StatusDate", System.Data.DbType.DateTime, StatusDate);
}
else
{
db.AddInParameter(dbcommand, "@StatusDate", System.Data.DbType.DateTime, DBNull.Value);
}
db.ExecuteNonQuery(dbcommand);
return true;
}
with regards
rahul
|
|
|
|
|
rahul.gharat wrote: object StatusDate)
Why are you still passing this as an object ? In any case, if this is passing DBNull.Value, and the procedure fails, then your database doesn't support null. That's really about it. Have you tried running the proc directly against the database ? What does the proc look like ?
I can't help but feel that if you made this code typesafe, it might well work. You're not passing a datetime, you're passing an INullable<DateTime> and I can't help but wonder if that makes a difference, when all you tell the compiler is that it's an object.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
good morning every one,
i generated a website application using asp.net with c#.net.i want to deploy that website but i donot know how to deploy the website,plz tell me how to deploy the website by a step by step procedure.
thanks in advance.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
