Search a product table by date

  • Thread starter Thread starter Karl Jensen
  • Start date Start date
K

Karl Jensen

Hi guru ,
i'm new to dotnet and database programming. I'm having problem searching a
sql server database table base on a date entry. Can anyone help me with
this, including the a proper t-sql sample code?

Thanks in advance!


Karl
 
Hi Karl.

Below is a C# sample:
DataTable dt = new DataTable();

SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Orders WHERE
(RequiredDate = @RequiredDate)", sqlConnection1); // sqlConnection1 is a
valid Sql server connection

da.SelectCommand.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@RequiredDate",
System.Data.SqlDbType.DateTime, 8, "RequiredDate"));

da.SelectCommand.Parameters["@RequiredDate"].Value = DateTime.Now;

sqlDataAdapter1.Fill(dt);



It selects from Northwind's Orders date using RequiredDate as parameter.

HTH
 
Back
Top