Save LoggedIn Time from GridView CheckBox selection using C# in ASP.Net

Question

Hello in visual studio aspnet I created a gridview to make it as an attendance sheet it has a column  AttendanceCon contains checkboxes in its fields and the another column  LogInDateTime for date and time I want when the checkbox checked the currently date and time will display in the corresponding column And all the information of the gridview columns will be saved in the MyAQL database Can anyone help me to know how to do that

AnandM · Accepted Answer

Hi yaraI have created a sample which full fill your requirementHTMLltdivgt    ltaspGridView ID34gvAttendance34 runat34server34 AutoGenerateColumns34false34gt        ltColumnsgt            ltaspBoundField DataField34Id34 HeaderText34Id34 gt            ltaspBoundField DataField34Name34 HeaderText34Name34 gt            ltaspTemplateField HeaderText34Attendance34gt                ltItemTemplategt                    ltaspCheckBox ID34chkAttendance34 OnCheckedChanged34LoggedIn34 AutoPostBack34true34                        runat34server34 gt                ltItemTemplategt            ltaspTemplateFieldgt            ltaspTemplateField HeaderText34LoggedInTime34gt                ltItemTemplategt                    ltaspLabel ID34lblLoggedInDateTime34 runat34server34 gt                ltItemTemplategt            ltasp

dharmendr · Answer

Hi yaraI have changed your code and html Refer the below codeHTMLltpgtltpgtltbr gtltbr gtltaspGridView ID34GridView134 runat34server34 align34center34 BackColor34White34 BorderColor34CCCCCC34    BorderStyle34None34 BorderWidth341px34 CellPadding34434 AutoGenerateColumns34False34    DataSourceID34ObjectDataSource134 DataKeyNames34AttendanceID34 ShowFooter34True34    Style34marginleft 172px margintop 33px34gt    ltColumnsgt        ltaspTemplateFieldgt            ltFooterTemplategt                ltaspLinkButton ValidationGroup34INSERT34 OnClick34lbInsertClick34 ID34lbInsert34 runat34server34                    ForeColor3400006634gtInsertltaspLinkButtongt            ltFooterTemplategt        ltaspTemplateFieldgt        ltaspCommandField ShowDeleteButton34True34 ShowEditButton34Tru

dharmendr · Answer

Remove the checked property from both the checkbox or cast both to boolean valueIf remove then remove below codeCheckedlt BindAttendanceCon gtCheckedlt BindLeavingCon gtIf casting then cast like belowCheckedlt ConvertToBooleanEvalAttendanceCon gtCheckedlt ConvertToBooleanEvalLeavingCon gtBut make sure if you are casting then you have to pass 1 or 0 or true or false

Save LoggedIn Time from GridView CheckBox selection using C# in ASP.Net

Company

Explore

Follow us

Contact Us