VB Code:
Dim sqlSaveCust As String = ("INSERT INTO [Customer] (CustCode, SuppCode, CustName, CustAddr1, CustAddr2, CustAddr3, CustAddr4, CustContact, CustPhone, CustFax, CustMobile, CustSupp) " _
& "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")
Dim CMDSaveCust As New OleDb.OleDbCommand(sqlSaveCust, TrenConn)
CMDSaveCust.CommandType = CommandType.Text
CMDSaveCust.Parameters.Add("@CustCode", OleDb.OleDbType.VarChar, 15).Value = Me.TxtCustCode.Text
CMDSaveCust.Parameters.Add("@SuppCode", OleDb.OleDbType.VarChar, 15).Value = Me.TxtSuppCode.Text
CMDSaveCust.Parameters.Add("@CustName", OleDb.OleDbType.VarChar, 50).Value = Me.TxtCustName.Text
CMDSaveCust.Parameters.Add("@CustAddr1", OleDb.OleDbType.VarChar, 30).Value = Me.TxtCustAdd1.Text
CMDSaveCust.Parameters.Add("@CustAddr2", OleDb.OleDbType.VarChar, 30).Value = Me.TxtCustAdd2.Text
CMDSaveCust.Parameters.Add("@CustAddr3", OleDb.OleDbType.VarChar, 30).Value = Me.TxtCustAdd3.Text
CMDSaveCust.Parameters.Add("@CustAddr4", OleDb.OleDbType.VarChar, 30).Value = Me.TxtCustAdd4.Text
CMDSaveCust.Parameters.Add("@CustCont", OleDb.OleDbType.VarChar, 30).Value = Me.TxtCustCont.Text
CMDSaveCust.Parameters.Add("@CustPhone", OleDb.OleDbType.VarChar, 20).Value = Me.TxtCustPhone.Text
CMDSaveCust.Parameters.Add("@CustFax", OleDb.OleDbType.VarChar, 20).Value = Me.TxtCustFax.Text
CMDSaveCust.Parameters.Add("@CustMob", OleDb.OleDbType.VarChar, 20).Value = Me.TxtCustMob.Text
CMDSaveCust.Parameters.Add("@CustSupp", OleDb.OleDbType.Boolean).Value = Me.CB1CustSupp.SelectedIndex
Conn_Open()
CMDSaveCust.ExecuteNonQuery()
Conn_Close()
It all depends on your backend DB and the driver it supplies for .NET also if your DB supports Ansi SQL.