In vb.net ,how to write Commit Roll Back syntax ?

See more:

SQL-Server-2005

VB

SQL-Server

WPF

Hi all

Iam using vb.net , and WPF application.

with data base SQL server 2005.

How to write commit Roll back in vb.net code .

Give me some example with queries.

MY VB CODE :
``````````
try

msSQL = " INSERT INTO m_tproductadd " & _
               " (Product_name,material_gid,standard" & _
               " ) Values ( " & _
               "'" & txtProducts.Text & "'," & _
               "'" & cbomaterialname.SelectedValue & "'," & _
               "'" & txtStandard.Text & "')"

msSQL = " INSERT INTO m_tphysicalparticalsadd " & _
              " (phy_name " & _
              " ) Values ( " & _
              "'" & txtphypartical.Text & "')"
      mnResult = objdbconn.ExecuteNonQuery(msSQL)

catch
end try

IF ANY OF INSERT FAILS ,COMMIT ROLL BACK HOW TO DO

Thanks in advance

Regards

Naveen...