Knowledge Share

Knowledge is NOT Power IMPLEMENTATION of knowledge is Power!!!
 
HomePortalGalleryCalendarFAQRegisterUsergroupsLog in

Share | 
 

 Db

View previous topic View next topic Go down 
AuthorMessage
Admin
Admin


Posts : 141
Points : 407
Reputation : 0
Join date : 2007-12-29
Location : Chennai

PostSubject: Db   Mon Feb 08, 2010 11:17 am

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")
Back to top Go down
http://knowledgeshare.forumotion.com
 
Db
View previous topic View next topic Back to top 
Page 1 of 1

Permissions in this forum:You cannot reply to topics in this forum
Knowledge Share :: .Net-
Jump to: