To INSERT a Record
Insert Into student values(12,'kkk','vsp')
To Modify a Field Information
update student set name='kk' where srlno=1
To Delete a Field Information from DB
Delete student where srlno=1
To Delete a Table from DB
drop table student
Connection String to Establish DbConnection
con = New OleDbConnection("User ID=sa;Provider=SQLOLEDB.1; Workstation ID=MYCLASS")
To INSERT a Record
Insert Into student values(12,'kkk','vsp')
To Modify a Field Information
update student set name='kk' where srlno=1
To Delete a Field Information from DB
Delete student where srlno=1
To Delete a Table from DB
drop table student
Connection String to Establish DbConnection
con = New OleDbConnection("User ID=sa;Provider=SQLOLEDB.1; Workstation ID=MYCLASS")
Mon Feb 08, 2010 11:17 am