dates

[aPerfectCircle]

I'm trying to get data from a sql database , calling a stored procedure that take 2 parameters date1, date2, I declared date1,date2 as string in my c# application, do I have to declare them as date type?, if so whats the data date type in c## ??? thanks in advance ,:)

aPerfectTool

[Christian Graus]

DateTime is the date type in C#.  You can use ToString to store the date as a string, but then you can't do much with it, beyond display it.

[saqib82]

Hi there is no need to declare date1, date2 as datetime data type in c#. just declare them as string. while you are querying the data from the sql database using the stored-procedure, just do some casting to fetch the data from the database. e.g select * from tablename where ( convert(nvarchar, firstdate) = date1 regards

sAqIb "Our scientific power has outrun our spiritual power. We have guided missiles and misguided men." Dr. Martin Luther King Jr.

[aamironline]

I would suggest you to use DateTime because it will be more convanient...

M Aamir Maniar aamirOnline.com

[aPerfectCircle]

Thanks for all the answers, I got my problem fixed by declaring date1, and date2 as DateTime and by changing the data type in the column date from datetime to smalldatetime :cool:

aPerfectTool