Displaying Table Data in Calendar Asp.net C#

Viraj Kawthankar

I want to display "time in,time out & status" columns into Calendar.... This is the Back-Code for calendar:

protected void Calendar1_DayRender(object sender, DayRenderEventArgs e) { DataSet ds = GetData(); //string link = "private DataSet GetData() { SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString); SqlDataAdapter ad = new SqlDataAdapter("CalendarAttendance", myConnection); DataSet ds = new DataSet();     ad.Fill(ds); return ds; }

This is the stored Procedure:"CalendarAttendance" ALTER PROCEDURE [dbo].[CalendarAttendance] @Employeeid int,
@status varchar(5), @transaction_date datetime, @actual_time_in datetime, @actual_time_out datetime

AS BEGIN   SET NOCOUNT ON;   SELECT actual_time_in=@actual_time_in, actual_time_out=@actual_time_out,      status=@status         FROM tblschedule where Employeeid = @Employeeid END

Im getting an error : Procedure or function 'CalendarAttendance' expects parameter '@Employeeid', which was not supplied. I want the Calendar to display time_in,time_out & status according to respective days and of that employee who has logged in. Plz correct the code & Stored Procedure wherever necessary..

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

Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.Sign inCreate an account

ATali tuncer10y agoPosted May 6, 2016, 4:26 AM First thing, you need to make sureyouget desired data from stored procedure, I don't have your database, so you need tofindout. That's why you need to check if your dataset has values in it..You can put a breakpoint.. for examplethis code : foreach (DataRow row in ds.Tables[0].Rows) { LinkButton lb = new LinkButton(); // your code } if you dataset is empty, you won't go inside foreach...but just by looking at the code, I won't know this..that's why you need to check.. 0
VKViraj Kawthankar10y agoPosted May 6, 2016, 3:57 AM @AliTuncer.... U know what i need & I have posted the code & procedure above, could you rectify where i can make changes by just modifying my code where changes are expected, Here's my updated Code : private DataSet GetData() { SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString); SqlDataAdapter da = new SqlDataAdapter("CalendarAttendance", myConnection); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@Employeeid", SqlDbType.Int).Value = 52674; //here you pass employee id DataSet ds = new DataSet(); da.Fill(ds); return ds; } protected void Calendar1_DayRender(object sender, DayRenderEventArgs e) { DataSet ds = GetData(); //string link = "If you wanted to show it for every employee in the table, in that case you wouldn't need to pass employee id.. I guess you keep Employee id in a session, when a user logs in the system.. Don't pass transaction_date as a parameter,it sounds like you don't have a column named transaction_date. 0
VKViraj Kawthankar10y agoPosted May 6, 2016, 1:39 AM Hi @alituncer .... I have lots of employees say 1000 so how do i pass their time_in,time_out & status according to their session: da.SelectCommand.Parameters.Add("@Employeeid", SqlDbType.Int).Value = 52674; So how do i write the code above...Correct it & one more thing im getting this error now: Column 'transaction_date' does not belong to table Table.Now which table it is referring to... I;ve given the connection string ["connectionString"] Which i've passed in web.config: My table's name is tblschedule which has the 3 columns time in,time out & status which i need to display 0
ATali tuncer10y agoPosted May 5, 2016, 8:06 AM for demonstration purpose I passed '1' for employee id, you are still passing 1, are you sure you have record for employeeid=1 in your database? in tblschedule table.. 0
VKViraj Kawthankar10y agoPosted May 5, 2016, 7:25 AM yes... im providing the GetData() method to the data set 'ds' which has the connection string connected to my database through web config : private DataSet GetData() { SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString); SqlDataAdapter da = new SqlDataAdapter("CalendarAttendance", myConnection); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@Employeeid", SqlDbType.Int).Value = 1; //here you pass employee id da.SelectCommand.Parameters.Add("@status", SqlDbType.Int).Value = 1; da.SelectCommand.Parameters.Add("@actual_time_in", SqlDbType.Int).Value = 1; da.SelectCommand.Parameters.Add("@actual_time_out", SqlDbType.Int).Value = 1; da.SelectCommand.Parameters.Add("@transaction_date", SqlDbType.Int).Value = 1; DataSet ds = new DataSet(); da.Fill(ds); return ds; } 0
ATali tuncer10y agoPosted May 5, 2016, 5:45 AM Do you have data in your dataset (ds) ? 0
VKViraj Kawthankar10y agoPosted May 5, 2016, 5:24 AM Hello @ali tuncer , i have passed all parameters as u said : private DataSet GetData() { SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString); SqlDataAdapter da = new SqlDataAdapter("CalendarAttendance", myConnection); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@Employeeid", SqlDbType.Int).Value = 1; //here you pass employee id da.SelectCommand.Parameters.Add("@status", SqlDbType.Int).Value = 1; da.SelectCommand.Parameters.Add("@actual_time_in", SqlDbType.Int).Value = 1; da.SelectCommand.Parameters.Add("@actual_time_out", SqlDbType.Int).Value = 1; da.SelectCommand.Parameters.Add("@transaction_date", SqlDbType.Int).Value = 1; DataSet ds = new DataSet(); da.Fill(ds); return ds; } Also i have passed it in the label of the calendar, but its not showing in the calendar grid: foreach (DataRow row in ds.Tables[0].Rows) { string Transaction_date = Convert.ToDateTime(row["transaction_date"]).ToShortDateString(); if (Transaction_date.Equals(s)) { LinkButton lb = new LinkButton(); lb.Text = "IN:" + row["actual_time_in"] as String + " " + "OUT:" + row["actual_time_out"] as String + " " + "WR_HRS:" + row["status"] as String + "" + " "; e.Cell.Controls.Add(lb); } } All i want is to display these 3 into each cell of the calendar grid of the employee who is logged in : actual_time_in='2015-01-01 09:30:00.000' actual_time_out=' 2015-01-01 15:30:00.000' status='PR' Right Now the calendar doesnt show anything & i want to take the transaction_date field for the date in the calendar 0
ATali tuncer10y agoPosted May 4, 2016, 10:51 AM I think you stored procedure query has to be like this : SELECT actual_time_in actual_time_out,status FROM tblschedule where Employeeid = @Employeeid Then,you need to pass Employeeid as a parameter to stored procedure. SqlDataAdapter da = new SqlDataAdapter("CalendarAttendance",myConnection); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@Employeeid", SqlDbType.Int).Value = 1 //here you pass employee id DataSet ds = new DataSet(); da.Fill(ds); return ds; I don't know where you keep employee id,you need the set it there..I passed 1 in the code above.. 0