I have a treeview in asp.net 3.5 page. Treeview structure is like this.
Class-
Section-
Student Name-
I need to create a loop to get all the studnet name where checkbox has been checked. I need to insert a row in db for each studnet which has been checked. How can we create a loop for this treeview?
I develop one concept, i want to query how to compare marks/reports all student in a class, compare subjects, previous marks/reports. another concept in my page i display charts in this charts i put a dropdownlist in this ddl pie, line, bar charts are their but i selected any one that chart type visible
View 1 RepliesI'm having arraylist to add student info but i have to create unique id per record below is my class.Student
objStudent=new Student(123,"Nj");statArray.Add(objStudent)public class Student{ private string name; private int RollId; public string Name { get { return name; } set { name = value; } } public int Id { get { return RollId; } set { RollId = value; } } public Employee(string name, int id) { { this.name=name; this.Id=id; } }
I have created a student webpage with many tables like student info,test1 marks,test 2 marks and so on now i have to generate a report for each and every student with their details and average marks in each subject
View 4 Repliesi developed site for School. in that i want to put a option as invoice for student.
which fields should i take and what is the format.
i want code in asp.net using C#
In my ListView control, I display a whole bunch of details for students. One of the fields -- Status -- returns a boolean value. I don't want to display True or False. I'd rather display something more meaningful in English. How do I display "Approved" or "Declined" instead of simple True or False for the following?
[Code]....
if i have database contain table:
1-student
2-accounts
and i make tthe page for login , if the student is record login successfully, how can make page to display information for this student who is logged on the rest of the data without viewing the other students who are in the database. Note:I used the session in the login page .
Develop Tools: Dreamweaver CS5, MySQL Workbench 5.2 CE
View 2 RepliesI have Attendance Table for students and im using stored procedure for add attendance:
1 means attend
0 means absent
DID STDNo L1 L2 L3 L4 L5 L6 L7 Date
1 2334 1 1 1 1 1 1 0 1 12/30/2010
date datatype is nvarchar(50)
stored procedure :
ALTER procedure [dbo].[AddDailyAttendance]
(
@STDNo nvarchar(6),
@L1 int,
@L2 int,
@L3 int,
@L4 int,
@L5 int,
@L6 int,
@L7 int,
@Date nvarchar(50),
)
as
insert into Att_AddDaily (STDNo,L1,L2,L3,L4,L5,L6,L7,Date)values(@STDNo,@L1,@L2,@L3,@L4,@L5,@L6,@L7,@Date)
when i add attendance for example : to student number 2334 at the date 12/30/2010 to check if it's exist in table and if it's exists doesnt add it
i have atable:
STDNo nvarchar(6) //student number primary
CID nvarchar(7) //course ID primary
DNo int //Department Number primary
H1 int allow null // Home work 1
H2 int allow null
H3 int allow null
H4 int allow null
H5 int allow null
Q1 int allow null //Quize 1
Q2 int allow null
Q3 int allow null
Q4 int allow null
Q5 int allow null
HE1 int allow null
HE2 int allow null
FExam int allow null // Final Exam
and stored procedure like this:
ALTER procedure [dbo].[AddMonthlyMarks]
(
@STDNo nvarchar(6),
@CID nvarchar(7),
@Dno int =isnull,
@H1 int,
@H2 int,..........................
the Data key name of grid is STDNo the problem is that the instructor this month will add only homework1(h1) for specific student number or to all students and rest of home works and quezies will not entered (Null), to the next month he will enter home work 2 ,etc... i get an error and i think that the null values for others home works in grid make this error caution: in table i check allow null property,the data type is integer How i can convert this null values to integer?
currently im trying to implement a quiz system on my website in which system will auto mark student's ans. if the student's ans is wrong, system will prompt an incorrect answer, highlight the errors and count the number of errors.
Im using asp.net C#.
I use GridView & FormView to update a record. but when I click the "save" button, throw an except : FormView must be in the insert mode to insert a record. The record has been updated success, and I didn't change the mode of the FormView, how this error comes?
View 3 RepliesIn my detailsview, I have an emptydatatemplate set up to allow users to enter new records. The code works. However, once the record is inserted, the detailsview defaults to a standard insert screen. I know this will cause confusion for the users. I would prefer the detailsview to either show in edit mode or a read-only mode. I have used detailsview.changemode and detailsview.currentmode in the custom sub created for the add new button of the emptydatatemplate- neither of which do what I was hoping. It would be even better if when there was no data, it defaulted to the insert screen (which seems like that should be an easy, no-brainer way for .net to function) but it doesn't. Or, I don't know how to accomplish it.
I don't want to force the user to click cancel after inserting an item through the emptydatatemplate just to be able to use the detailsview for other records.
I have grid view in ASP.Net 3.5. I need to add multiple blank rows in a gridview and then have to save them in database. How can I do that in most simplest way?
View 7 RepliesI am using Visual studio 2010 express and I have a details view databinded to an sql database table. When I use the Insert option on the view it causes an error due to it trying to insert a null into the primary key field. If the Insert function does not create a new primary key entry how is it created?
View 9 RepliesHow do I insert a snippet to change a hyper link ' insert' to a button image?
Here is the front page code:
[Code]....
Disable an Insert button after the insert operation is complete.
Right now, I have onclick event for button that disables the button immediately without executing the insert code.
I have a GridView (BulkEditGridView), that has 10 rows from the datasource. I Add a TemplateField "Insert Row" button to insert 1 blank row at selected row using Rows.AddAt.First time i press "Insert Row", it works as expected, the row inserted at selected row. now i press another "Insert Row", the row is inserted, however the row (in first time inserted) now move to the last row. and so on.
View 7 RepliesI have a problem with DetailsView linked with Database, DetailsView is Insert/Edit enabled, and adding/ediditng data works, however........ when I add a new record (DetailsView in Insert mode) and press INSET instead going to record I have just created in Read-Only Mode it shows me blank form, it looks that the "linking" field is null.
View 3 RepliesI am trying to pass in as an insert parameter for SQLds2 the scope_identity of the insert of SQLds1.
Exception Details: System.InvalidOperationException: Error executing 'InsertCommand' in SqlDataSource 'SqlDataSource1'. Ensure the command accepts the following parameters: @Name1, @NewId
[Code]....
Getting the message that ObjectDataSource ... count not find a non-generic method ... that has parameters ... The parameter list is fine until I get to the very end and it list the two data fields that are in my DetailsView. Using the ASP Tutorial #17 (Examining the Events Associated with Inserting, Updating, and Deleting) and the Exploring the Data Modification - specifically the one showing the INSERT of the Product Name and UnitPrice. ASPX page is pretty simple and attempting something similar, two fields to insert a new record - update the other fields later.
Full Error Message follows along with ASPX and the AsignaturasBLL.cs. Interesting thing is that when I swap the two fields in the DetailView, then the last two fields in the error message are swapped. In the error message I bolded these two fields.
[Code]....
i need to insert multiple rows at a time into database table(sqlserver) from datatable or gridview. Actually iam looping through the rows of gridview and inserting each row. Is there any method to insert entire table of rows at a time into database table. Both datatable columns and database table coulmns are similar.
View 2 RepliesI do have a details view, which insert data to a database table using SQL Datasource. Now i need the data to be inserted in to 2 tables instead of one.
View 1 RepliesI have a Winform that has fields need to be filled by a user. All the fields doesn't belong to one table, the data will go to Customer table and CustomerPhone table, so i decided to do multiple inserts. I will insert appropriate data to CustomerPhone first then Insert the rest data to Customer table.
View 3 RepliesI am using 1 textbox with a Ajax Calendar extender to allow my user's to select a date graphically (exp: 12/15/2009). I have another textbox for the hour and minutes in military time(exp: 15:30). I think i have the code to grab the data from the 2 textbox's and combine them to be inserted into the field (exp: 12/15/2009 15:30). Here is my insert code for the Field:
[Code]....
However unless I make all the fields Nullable the insert fails, on top of that none of the other field that I have selected on the Detailsview Insert or Edit are inserted into there fields. Half of my fields have to be non-null values. So how do I fix this?
I can supply additional vb code and the aspx code if needed.
This is the error I'm getting: Cannot insert the value NULL into column 'Operation_type', table '/GAOSDB.MDF.dbo.BC_Perf_Log'; column does not allow nulls. INSERT fails. The statement has been terminated.'
This is the first non-null column.
I need to get this figured out because I have 30 other web pages that will be utilizing the same approach.
