How to update/insert values in a database
I need ur help,
Actually im designing a web page for my project in ASP.NET with C#....I got Struck in inserting data into the database from the web page.... I feel i can take forward steps if any one can solve the following example which is not the same project which im doing....
here if suppose i have my web page with lables EmployeeNumber,
EmployeeName,Em ployeeAddress,D epartmentName,D epartmentLocati on,Salary,
DateOfBirth. and i have a insert button..so soon i click the insert button the values or text in the appropriate text boxes should insert into the following appropriate two referenced tables in the database..the two table are
tblDepartment (base table) with attributes
DepartmentNumbe r (primary key),Department Name,Department Location
and
tblEmployee with attributes
EmployeeName (primary key),EmployeeNa me,DataOfBirth,
EmployeeAddress ,DepartmentNumb er (Foreign key),Salary.
here i need the department details to be inserted into department table and employee details to be inserted into employee table with Department number as reference field...and if this can be solved then i also want to know how can we increment the DepartmentNumbe r for every record we insert into these tables...
i feel very happy if i will get quick response...
Thanks
Actually im designing a web page for my project in ASP.NET with C#....I got Struck in inserting data into the database from the web page.... I feel i can take forward steps if any one can solve the following example which is not the same project which im doing....
here if suppose i have my web page with lables EmployeeNumber,
EmployeeName,Em ployeeAddress,D epartmentName,D epartmentLocati on,Salary,
DateOfBirth. and i have a insert button..so soon i click the insert button the values or text in the appropriate text boxes should insert into the following appropriate two referenced tables in the database..the two table are
tblDepartment (base table) with attributes
DepartmentNumbe r (primary key),Department Name,Department Location
and
tblEmployee with attributes
EmployeeName (primary key),EmployeeNa me,DataOfBirth,
EmployeeAddress ,DepartmentNumb er (Foreign key),Salary.
here i need the department details to be inserted into department table and employee details to be inserted into employee table with Department number as reference field...and if this can be solved then i also want to know how can we increment the DepartmentNumbe r for every record we insert into these tables...
i feel very happy if i will get quick response...
Thanks
Comment