grab data where datetime is 30days from now

[flyclassic22]

How do i insert a sql and asp.net datetime functions and date now to come up with a sql statement to select data which are within now and 30days ago?
Any examples???

 

[jmeckley]

DateTime today = DateTime.Today;
DateTime ThrityDaysAgo = DateTime.Today.AddDays(-30);
SqlCommand cmd = new SqlCommand();

cmd.CommandText = "select * from [table] where [field] bewteen @start and @end";
cmd.Parameter.Add(new Parameter("start", SqlDbType.DateTime, ThrityDaysAgo);
cmd.Parameter.Add(new Parameter("end", SqlDbType.DateTime, today);

this still requires a connection string and SqlConnection object, but you get the idea. NOTE: I'm not sure if the new Parameter overload is valid, I'm doing this from memmory.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[flyclassic22]

I've just found out myself after browsing google...
What i did...

DateTime todaydate;
DateTime sixtydaysago;
todaydate = sixtydaysago = DateTime.Today;
sixtydaysago = sixtydaysago.AddDays(-30);

string selectquery = "SELECT [ImagePath], [Description], [Price], [DateRelease], [productID] FROM [CDCatalog] WHERE DateRelease BETWEEN '" + sixtydaysago.ToString() + "' AND '" + todaydate.ToString() + "'";
NewRelease.SelectCommand = selectquery;

And it worked.. haha, it is similar to yours jason.. I get your idea, it seems the same, thank you anyway!!

 

[jbenson001]

Use stored procedures.. with parameters..

 

[jmeckley]

string selectquery = "SELECT [ImagePath], [Description], [Price], [DateRelease], [productID] FROM [CDCatalog] WHERE DateRelease BETWEEN '" + sixtydaysago.ToString() + "' AND '" + todaydate.ToString() + "'";

this is open to SQL injection attacks where as this

string selectquery = "SELECT [ImagePath], [Description], [Price], [DateRelease], [productID] FROM [CDCatalog] WHERE DateRelease BETWEEN @start AND @end";

is not. That is why .Net include Parameter objects.

here is more information about SQL injection attacks Google "sql injection attacks"

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[jbenson001]

Good point about the injection attacks Jason. My suggestion was because of that, but also for performance and maintainability.