Query Date from SQL Server

Joined
Feb 6, 2009
Messages
3
Reaction score
0
now i used Ajax Calendar Extender to select the date
and show back to textbox name, txtDate.
i show in this format Fri 06 Feb 2009

and then i must use this date to query
data from my database.

i have some problem about date field
in my DB, it keep in this format, 2009-02-06
it has SqlDbType.Date to collect in this field.

how can i use txtDate field in query date from my DB

i use like this:

StringBuilder sb = new StringBuilder();
sb.Append("select Order_ID as OrderID, ");
sb.Append("Order_Date as OrderDate, ");
sb.Append("Order_Time as OrderTime, ");
sb.Append("Order_Status as OrderStatus ");
sb.Append("from tranOrder ");
sb.Append("where (Order_ID = @OrderID) ");
sb.Append("and (Order_Date = @OrderDate) ");

string sqlViewOrder = sb.ToString();
DataTable dtOrderStatus;
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.Text;
com.CommandText = sqlViewOrder;
com.Parameters.Clear();
com.Parameters.Add("@OrderID", SqlDbType.VarChar).Value = Session["orderID"].ToString();

DateTime ordDate = DateTime.Parse(txtDate.Text);
com.Parameters.Add("@OrderDate", SqlDbType.Date).Value = ordDate;

com.Connection = Conn;
SqlDataReader dr;
dr = com.ExecuteReader();

but when i run they told me "String was not recognized as a valid DateTime."

how can i solve this problem?

thanks a lot for every answers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,769
Messages
2,569,582
Members
45,065
Latest member
OrderGreenAcreCBD

Latest Threads

Top