how to insert records in sqlserver2005 using dataadapter in asp.net using vb

Please support our VB.NET advertiser: Intel Parallel Studio Home
Reply

Join Date: Oct 2008
Posts: 1
Reputation: masajid686 is an unknown quantity at this point 
Solved Threads: 0
masajid686 masajid686 is offline Offline
Newbie Poster

how to insert records in sqlserver2005 using dataadapter in asp.net using vb

 
0
  #1
Oct 23rd, 2008
Hello,


I am very new to .Net I want to the detail code for inserting a record using data adapter in asp.net using vb as a language. and the table will simple as DeptNo, DeptName and Location . When I click the add button the records will saved in database.


thankyou
Reply With Quote Quick reply to this message  
Join Date: May 2007
Posts: 45
Reputation: cellus205 is an unknown quantity at this point 
Solved Threads: 1
cellus205 cellus205 is offline Offline
Light Poster

Re: how to insert records in sqlserver2005 using dataadapter in asp.net using vb

 
0
  #2
Oct 24th, 2008
Well when u create the table adapter, it should automatically setup your insert query, so you should be able to just call the query and pass it what you need inserted, like:

MyTableAdapter.Insert(myDeptNo, MyDeptName, MyDeptLoc)
MyTableAdapter.Update()
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Other Threads in the VB.NET Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC