Wednesday, 26 June 2013

Extracting the Records from database based on datetime column


  DateTime WorksheetUploadedDate = ateTime.Now.ToLocalTime().AddMinutes(749).AddSeconds(23);
        string UploadedDate = WorksheetUploadedDate.ToString();
        string[] ExtractDatePart = UploadedDate.Split(' ');
        string[] ExtractDiffPart = ExtractDatePart[0].Split('/');
        SqlConnection con = new SqlConnection(AppConfiguration.ConnectionString);
        con.Open();
        string Value = ExtractDiffPart[1] + "/" + ExtractDiffPart[0] + "/" + ExtractDiffPart[2];
        SqlCommand cmd = new SqlCommand("SP_RetrieveTodaysWorksheetUpdation", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@UploadDate", SqlDbType.VarChar).Value = Value;
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        con.Close();
        DataTable dt = new DataTable();
        da.Fill(dt);


Procedure
----------------------
ALTER Procedure [jupsoft].[SP_RetrieveTodaysWorksheetUpdation]
(@UploadDate varchar(max))
as
begin
select SchoolId,ForClass,Section from tablename WHERE CONVERT(varchar,UploadedDate,101)=@UploadDate group by  SchoolId,ForClass,Section
end

No comments:

Post a Comment