Datagrid or gridview whith insert button

[amina89]

Hi, idont speek english well sorry! I work with visual web developer 2005 for the 1st time and sqlserver2005 to achieve an intranet site for the service school. Now what they are doing is that university is: For each semester, the registration service write the names and num-registration ds register students this semester in an Excel worksheet for each level. each teacher introduced the notes of his field for different students in a column (note_matière1 for example) of this spreadsheet excel. they use Excel to calculate ways,.. I spent a lot of time to test a gridview but there is no possibility of inserting a column if I: Num_inscription name marks_frensh 1077 ssss 12 1078 AAA 15 1079 kkkkk 16 To insert the notes they need me whenever select and then click update for each student and it is not practical !!!!! I spent a lot of time with and excel without result. I consulted a lot of forum was told than in the controls Infragistics, there is a grid like excel but I need the license !!!!!!! how to insert an entire column marks by clicking on a button. I dont know if I happened to explain this project or not. Thank you very much, Thanks again.

[Prashant B Lavate]

please explain what exactly u want... i am not getting u.... chat wt me i am online on prashant_83@hotmail.com

Thanks & Regards, Prashant B. Lavate Software Engineer Mobile : +919423872257 Pune(India)

[amina89]

Sorry i don't have a hotmail count my email is nature.fleur@gmail.com

[amina89]

Student_id Name_student Marks 15555 gg 15556 cc 15557 ss INSERT Let me explain once so student_id and name_student I select them from my BD and column marks is in editmode ;I need to insert marks students( values column marks)just with a Cliq button. thanks

[amina89]

Hi; i havn't solution Each teacher will have the GridView before him he should write notes of all students, and then save them in the db .The problem is how to store this data just by clicking a button (not for each student but the list). Update the column is possible : 1 foreach (GridViewRow row in GridView1.Rows) 2 { 3 sb.Append("UPDATE EPREUVE SET NOTE = '"); 4 sb.Append((row.FindControl("txtLastNote") as TextBox).Text); 5 sb.Append("'"); 6 sb.Append("WHERE ID_ELEVE = "); 7 sb.Append(Convert.ToInt32((row.FindControl("lblUserID") as Label).Text)); 8 9 sb.Append(" and CODE_MATIERE="); 10 11 sb.Append(Convert.ToInt32((row.FindControl("lblfield") as Label).Text)); 12 sb.Append(" and CODE_ANNEE_UNIVERSITAIRE='" + DropDownList1.SelectedItem + "'"); 13 sb.Append(""); 14 15 sb.Append(""); 16 17 sb.Append(""); 23 } 24 I try to do the same thing to insert