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
(@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