kindly tell me how to display the records in a gridview by writing code in the .cs page or send me a link which have the description related to this a reply from you will be deeply appreciated

thanks for the link i am studying i could not open the project as i have to install vs2005 in my system i will check that as soon as possible once again thanks for the link it is so usefull for a fresher like me

i have not started writing code for grid view i did was using the datasource for retreiving values the sql query is as follows SELECT DISTINCT LeaveMaster.LeaveType, LeaveAllotted.NoOfDays FROM LeaveMaster INNER JOIN LeaveAllotted ON LeaveMaster.LeaveTypeID = LeaveAllotted.LeaveTypeID INNER JOIN EmpCategType ON LeaveAllotted.EmpCategID = EmpCategType.EmpCategID INNER JOIN GeneralInfo ON EmpCategType.EmpCategID = GeneralInfo.EmpCategID INNER JOIN GenderMaster ON LeaveAllotted.GenderID = GenderMaster.GenderID AND GeneralInfo.GenderID = GenderMaster.GenderID the problem because there are both male and females staffs in my GeneralInfo table its showing both leaves for both the employees infact it should should male leave to males and female leaves to female

is it possible to display the records in a grid view with the help of writing the codes in the aspx.cs page if yes kindly give some links where i can refer to the reason is because its not showing the records that i want so i want it to be displayed so i thought of writing the query in .cs page and display manually without the use of datasource.

modified on Saturday, June 6, 2009 1:59 AM

Thank you smcnulty i forgot to do that now its working once again thankyou very much

i have to display leave allotted record of a single employee in gridview but because i have stored three records of permanent employee in generalinfo table its displaying three times my query is as follows SELECT LeaveMaster.LeaveType, LeaveAllotted.NoOfDays FROM LeaveMaster INNER JOIN LeaveAllotted ON LeaveMaster.LeaveTypeID = LeaveAllotted.LeaveTypeID INNER JOIN EmpCategType ON LeaveAllotted.EmpCategID = EmpCategType.EmpCategID INNER JOIN GeneralInfo ON EmpCategType.EmpCategID = GeneralInfo.EmpCategID what should i do to rectify this problem a help from somebody will be deeply appreciated.

i am trying to display the leave allotted for a permanent employee but since in the table there are three permanent employees records its showing the type of leave three times what should i do

[Message Deleted]

i want to display an error with the help of message box i wrote mbox("Enter the empty fields"); its showing an error mbox doesnt exist in this context what should i do am i missing any directive somebody help. thanks in advance

i used

timespan diff=calendar1.selecteddate.substract(calendar2.selecteddate);

and now its working thank you for your valuable suggestion i will do the same.

modified on Tuesday, June 2, 2009 6:06 AM

thank you for the valuable reply, i am new to asp.net. please give me some suggestions so that i can improve.

thank you for replying its showing an error "Error 3 Cannot implicitly convert type 'System.TimeSpan' to 'string'" what should i do.

how can i find the difference between two calendar dates to calculate number of days and display it in a label.

it is showing an error like "'System.Web.UI.WebControls.Calendar' does not contain a definition for 'Date' and no extension method 'Date' accepting a first argument of type 'System.Web.UI.WebControls.Calendar' could be found (are you missing a using directive or an assembly reference?)"

i want to display the next month in the calendar but because i have written the code like "calendar1.visible =false" in the "Calendar1_SelectionChanged1" method i am unable to perform the above mentioned operation. how can i display the next month

thank you the mistake was enabling the auto post back

for the database to connect you may have used windows or sql authentication if it is sql authentication connect with the help of the computername and password ie.administrator username and password in the connection string. i think that will do.

I am facing an output error. I am using a drop downlist which contains two items called "half day" and "full day" and two calendar controls. What i am in need is when i select the "full day" first it should show calendar1, after selecting the date in calendar1 it should display the next calendar control. then when i select the "half day". it should display only calendar1 and once clicking the date in the calendar1 the same should not be visible. Anyone kindly help me...

modified on Saturday, May 30, 2009 6:40 AM