943,589 Members | Top Members by Rank

Ad:
  • VB.NET Discussion Thread
  • Unsolved
  • Views: 2006
  • VB.NET RSS
Oct 23rd, 2008
0

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

Expand Post »
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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
masajid686 is offline Offline
1 posts
since Oct 2008
Oct 24th, 2008
0

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

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()
Reputation Points: 10
Solved Threads: 3
Junior Poster in Training
cellus205 is offline Offline
57 posts
since May 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in VB.NET Forum Timeline: plz is there some1 there to help me?
Next Thread in VB.NET Forum Timeline: file transfer online?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC