datatable is not loading

aditya immadi

10y788.NET

Hai all i tried this for showing records which has date after today..in mvc

}

public ActionResult ActiveRecords()

{

var dateAndTime = DateTime.Now;

var ydate = dateAndTime.Date;

DataTable dt = _obj.activeR(ydate);

return View();

}

and in my Dal.cs

internal DataTable activeR(DateTime ydate)

{

SqlConnection con = new SqlConnection(s);

SqlCommand cmd = new SqlCommand("sb_calender", con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add("@EndDate", ydate);

SqlDataAdapter sda = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();

sda.Fill(dt);---table is not loading here

return dt;

}

finaly my stored procedure is

alter proc sb_calender

@EndDate date

begin

select * from tb_calender WHERE @EndDate > CONVERT(DATETIME,CONVERT(NVARCHAR(10),GETDATE(),121))

end

is this the correct way to do this

or anything else....if yes please help me ..

TIA

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vincent Maverick Durano10y ago
Open SQL Server Management Studio and try to run your SQL query using the date you passed in your WHERE clause. That will verify if your stored procedure will return any data or not.
+1
Vinay Singh10y ago
Hi
Try this way
SqlConnection con = new SqlConnection(s);
SqlCommand cmd = new SqlCommand("exec sb_calender'"+ydate+""', con);
cmd.CommandType = CommandType.StoredProcedure;

SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
return dt;
0