connection with ms access 2007 with datagrid in C#

Question

Hi Guys,

Here I am having Ms Access 2007 database.
Roll number , Student Name, Physics Marks, Chemistry Marks, Maths Marks, Total Marks , Percentage.
fields are there.
Roll number and Student Name is stored in database and others fields are blank in which Roll number is the primary key,
Now I wanted when the code is Run then in datagrid I just given the roll number then its should automatically select the student name from the database and now user will enter the Physics marks chemistry marks and Maths marks ,
then the total marks will be calculated and as well as percentage.
   
Two buttons are there one is SAVE by which the all the marks is going to be saved in database,
another button  is Print by which to take the print out of that page can be done .

Please help me to do that.
  

Answer 1

Please go through below links that might help you:

 

http://www.w3schools.com/php/php_mysql_insert.asp

 

http://www.tutorialspoint.com/php/mysql_insert_php.htm

 

http://people.cis.ksu.edu/~hankley/d764/tut06/GopisettyPHP.html 

Answer 2

Hi Sharfeena,

 

If you are creating database table in server on runtime then it is not good idea. Create a table and on click of "Add House" you should add record in the table.

 

Please let us know where are you getting stuck? 

Answer 3

Hi,

     Thank you for the information.i need one more help.i don't know how to create

      record with in the table . plz send the code .