VC#.NET - insertion and updation of information through textboxes to the SQL SERVER 2000
Posted on 2005-03-15
i am very beginner to the programming
i am explaing my test project conditions
SQL Server Service Manager Interface is
Server : TOMS\TOMS
Services: SQL Server
SQL is installed on a desktop XP system
label1(text=enter your name) corresponding textbox1
label2(text=enter your address) corresponding textbox2
label3(text=enter your phone number) correspondig textbox3
user id: sa
database name : toms
table name :users
columns are :STUDENT_ID,ADDRESS,PHONE
i already inserted 2 rows of information in this table.
my needs are:
( 1) i am entering a name in the 'textbox1' and pressing ' showdetails button '.then i want to show the address and phone informations on the corresponding textboxes....then if i am pressing
' next button' then i want to show next row.....
(2) when i am entering the all 3 fields and pressing the insert button then i want to insert data into the same table 'users' in the same database ' toms' and show a message "your data saved".
(3) now i want to change address and phone details for a particular user ...for this i will enter a name ,address and phone in the corresponding textboxes.....if this name is not in the users table , i want to throw an exception message "the name does not exists" continue the processes....otherwise do update the database and show a message "your data has been updated..."
hopely waiting for a solution in VC#.NET in connection oriented data access method and disconnected data access method....in exact coding with my details i have explained above because i am very beginner to the programming......
please give me a replay as soon as possible