Data Controls :: Mark Attendance Of Students (Present Or Absent) In Database Using GridView
Mar 18, 2013
In my website there is 1 module in which i m fetching data(Student name, Roll no.) of students from the student master table into gridview... and in that gridview there is 1 checkbox column...
I want that when i will check the checkbox of those students who are present...dat checked students and name should be get entered into another table in database where there wil be present written in front of checked students and absent written in front of unchecked students.....
I tried a lot but I am not getting it.....
From the above table(student info) i wil fetch data in gridview and will mark attendance in the gridview
In the above sample gridview in the student name column the name of the students is fetched from student info table, when I will check the checkbox and select the date and click on the button the students who are checked will be stored with a status present and those who are unchecked are stored as absent in another table
The following is the table(example) is where the data is to be stored in the same manner. It means that total two tables are there in the database.
From 1 table i fetch data of students info in gridview and in another table i wil save the attendance marked in gridview....
View 1 Replies
Similar Messages:
Jun 15, 2010
with the code to present data in a gridview but without binding it to a database.
View 3 Replies
Jan 19, 2011
I have gridview that contain:
Fname|Born
aa |03/05
bb |19/01
cc |03/08
dd |19/01
if today is: `19/01/2011` how to mark in red color the 2 rows that Satisfies the condition ?
in C# asp.net
View 2 Replies
Mar 8, 2011
I am developing web application using asp.net. Here i need to access two databases in which one is present on other server. I am able to connect to database present in same server but not with database present in other server.
I am using MS-access. I dont know the changes to be done and syntax for database connection.
View 3 Replies
Dec 16, 2010
I have a Gridview in the markup and I add an ObjectDataSource to the mark up which will be the gridviews data source. Is this a redundant way of binding controls? I believe using this method is good for small sites with little customisation etc. but, for large sites (multi lingual, hundreds of pages etc) I have been taught to create the controls in the mark up or code behind, then bind the controls on PreRender in the code behind. My new boss thinks this method is old school and the current way of using an objectdatasource in the mark up is the best way to do it.
View 10 Replies
Jun 21, 2010
iam using asp.net2.0 with c#, with backend sql server2000
in my client system i have to create dynamically procedure and return the result
but when iam using in my local system the code is working fine but at client system it it not working
[Code]....
View 5 Replies
Feb 27, 2010
I have a gridview which is present inside a repeater. I have been successful in displaying the data inside the grid view. Now I want to fetch data from the gridview. But i have not been able to fetch the data from the grid view.
View 5 Replies
Aug 10, 2012
I have Link Button to Export to excel in Master page. Since I have placed it in master page I can see Export link button in every page. I need to disable link button where gridview is not present in a page.
I thing using Enabled property we can do. How to proceed. Is there any other way to do it.
<asp:LinkButton ID="LinkButtonExport" Text="Export to Excel" runat="server" OnClick="LinkButtonExport_Click" />
View 1 Replies
Jan 7, 2011
http://www.eggheadcafe.com/community/aspnet/7/10057105/attendance-sheet.aspx
View 11 Replies
Jan 9, 2010
I trying to solve this: I have a gridview where are real estates (houses, flats ...) and I need to "freeze" (not to show it) some of them just for a while ... I have an administration website, where is another gridview with edit/ delete ...It doesn't have to be checkboxes ... but I have an idea to put new column to the main page and makes it invisible ... every ordinary row will have empty entry in this column, but the one a need to freeze will have phrase "freeze" in it after the checkbox will be checked ... that I can do ... but I need help with SELECTCOMMAND of the main page gridview ... HOW TO PUT INTO a SELECTCOMMAND THAT I WANT TO SHOW WHAT I NEED TO SHOW EXCEPT OF THOSE WITH PHRASE FREEZE IN THE HIDDEN COLUMN ?this is my select command:
[Code]....
View 3 Replies
May 7, 2015
I have a GridView, that contains 3 Textboxes. Say Textbox1, Textbox2 & Textbox3
Now how do I subtract the value of Textbox1 & Textbox2 & show the result in Textbox3?How to do this in JavaScript?
View 1 Replies
Jan 3, 2010
i am making a webform for university students to register projects.there is a dropdown list which will ask how many students have participated, suppose student select 3 students, now my question is how can i restrict user to enter only one students data,i want he/she should fill all three students data than the submit button should enabled.
View 5 Replies
Mar 12, 2012
How can generate employee attendance Reports in table bu sql server database 2005 and vb.net 2005 i'm not using crystal reports
View 1 Replies
Jun 3, 2010
I'am developing a attendance software of employees with visual studio 2005 and sql server 2005, in which i have to display the attendance in a gridview withname and date as follows,
NAME (Date)1 2 3 4 5 6 7 8 9 10 .... ... 31
RAM P A P P P A
P- Present
A- Absent
View 5 Replies
Jan 26, 2010
I am currently trying to implement a small class attendance system, where the student names are taken from a database, stored in a List<Student>, and bound to a Repeater control. Each row of the Repeater contains two columns: The first is the student's name, and the remaining column contains a RadioButtonList with three ListItems (Present, Absent, Sick).Now, once the user presses "Submit", I want to be able to store their attendance status based on the user selection. However, after submission, the SelectedIndex is always 0, no matter what option is selected.
View 8 Replies
Mar 15, 2013
How can i but alternate Image if No image retrieve in image Control ?
View 1 Replies
Apr 22, 2010
[Code]....
than i want present data like this
[Code]....
[Code]....
but data doesn't appear on webPage ?? what's wrong with this code ??
View 5 Replies
Aug 10, 2010
I am using Visual Studio 2005 version, DOTNET Framework 2.0, Technologies C#.NET and ASP.NET and Operating System WindowsXP.In my excel sheet i have two columns of data. Using Gridview i am retrieving data from excel sheet and presenting data. While i am writing RowDeleting event i am getting error primary key not exist.Below code i am using in my program: Default.aspx
View 2 Replies
Dec 15, 2010
On this page: http://vucsyd.dk/kursus/web/TilmeldingEksamenTest.aspxe.g. student number: 10629 kan mark rows and make choices in dropdownlistsBy next visit i i would like the page to show earlier choises. Do i have to change everything or is there an easy option?Site code:
[Code]....
Stored procedure:
[Code]....
View 1 Replies
Jul 11, 2010
I am generating my service code by reading wsdl and client proxy as well using wsdl.exe.
I did it successfully but when I create request object and try to verify with schema it gives me error root element is not found.
I use same schema which I have used in my wsdl document and using xsd.exe I generate my objects.
I found There is XmlRootElement is absent when I mention it no my parent type it works fine.
Problem is Why it's not generating when I used wsdl.exe to generate code.
View 3 Replies
Apr 14, 2010
UI markup to create the table shown below, which I have mocked up quickly to visualise what I need to do. The data is in the form of custom objects; a SelectedSession object which has a List (Of Students) sorted by AcademicYear, TeachingSet, then name.
So the question is how do I create that table from my custom object?
<table class="style1">
<tr class="academicYear">
<td colspan="3">
[Code]....
View 4 Replies
Jan 19, 2011
i have gridview that contain:
Fname|Born
aa |03/05
bb |19/01
cc |03/08
dd |19/01
if today is: 19/01/2011 how to mark in red color the 2 rows that Satisfies the condition ?
View 3 Replies
Oct 8, 2010
Im using agrid view which does not using sql datasource and im trying ro Update it this is the Code:
public partial class senior_MarksApproval : PageDataAccess
{
protected void Page_Load(object sender, EventArgs e)
{
Title = "View Marks Approval Requests";
if (IsPostBack)
{
DataTable Ds = DA.getSemester();
lblsem.Text = Ds.Rows[0]["SemID"].ToString();
BindGrid();
}
}
void BindGrid()
{
DataTable DT = DA.GetMarksReqApproval(Convert.ToInt32(DropDownList1.SelectedValue), Convert.ToString(DropDownList2.SelectedValue));
GridView1.DataSource = DT;
GridView1.DataBind();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
String CID = GridView1.DataKeys[e.RowIndex][0].ToString();
String STDNo = GridView1.DataKeys[e.RowIndex][1].ToString();
String Mark = ((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text;
DA.EditMarks(CID, STDNo, Convert.ToInt32(Mark), DateTime.Now.ToString());
GridView1.EditIndex = -1;
BindGrid();
}
I want To update Mark and i convert it to template Field ,When I press Update I get the Old value not the Newest One of The Mark and nothing were Updated Except The Date Value in each DataBase and Grid
View 8 Replies
Apr 29, 2012
public partial class _Default : System.Web.UI.Page
{
SqlConnection sqlconPubs;
//SqlDataReader sdasearch;
SqlDataAdapter sqldaSearch;
DataSet dsetSearch;
DataTable dtableSearch;
[Code] ....
View 1 Replies
Jun 18, 2010
my requirement is : am having a excel sheet with some values listed i want to pass each value present in any(specified) column to a text box present on a remote page (a site other than mine) as a input and capture the result displayed on the page and then store the input and reuslt side by side in db this should repeat till the end of the input values in the excel sheet.
View 2 Replies