<div>
Figured it out, once i got my head around Datasets, TableAdapters, etc &nbsp;it became quite easy. Given i'v already made a connection with the database (as my comboboxes are bound to tables) i just need to access the relevant Tableadapter to make the change.<br />
<br />
ie. The Table called &quot;Holidays&quot; has &nbsp;a TableAdapter called &quot;HolidaysTableAdapter&quot; and my Dataset is called &quot;Leave_DataSet&quot;. Therefore:<br />
&nbsp; &nbsp; &nbsp; &nbsp; <br />
&nbsp; &nbsp; &nbsp; Dim DA As New Leave_DatabaseDataSetTable<wbr />Adapters.H<wbr />olidaysTab<wbr />leAdapter<br />
<br />
&nbsp; &nbsp; &nbsp; DA.Insert(&quot;Value for Column1, Value for Column2,etc......&quot;)
</div>


Figured it out, once i got my head around Datasets, TableAdapters, etc  it became quite easy. Given i'v already made a connection with the database (as my comboboxes are bound to tables) i just need to access the relevant Tableadapter to make the change.

ie. The Table called "Holidays" has  a TableAdapter called "HolidaysTableAdapter" and my Dataset is called "Leave_DataSet". Therefore:
       
      Dim DA As New Leave_DatabaseDataSetTableAdapters.HolidaysTableAdapter

      DA.Insert("Value for Column1, Value for Column2,etc......")

<div>
<div class="content wysiwyg-content">
I'm creating a small application using VB.NET whereby i've bound some comboboxes to a database containing data, however now i wish to do the reverse and use some textboxes and other controls to write back to the database. Can anyone give me details on how this can be done, given i've already made a connection to the database? Can this be done simply (like binding) or do i need code?<br />
<br />
Thanks
</div>
</div>


I'm creating a small application using VB.NET whereby i've bound some comboboxes to a database containing data, however now i wish to do the reverse and use some textboxes and other controls to write back to the database. Can anyone give me details on how this can be done, given i've already made a connection to the database? Can this be done simply (like binding) or do i need code?

Thanks

Add Data to Database using VB.NET

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,