Code:
Dim cmdInsert as OleDbCommand
Dim strInsert as String
strInsert="Insert into Userdetail (login_id,password, Name, Designation, Company, " _
& "Address, Zip, City, Country, Fax, email, phone, employee_size, sales)" _
& " VALUES (@loginid, @password, @Name, @Designation,@Company," _
& " @Address, @Zip, @City, @Country,@Fax,@Email,@Phone,@EmployeeSize,@Sales)"
cmdInsert= New OleDbCommand(strInsert,conUser)
cmdInsert.Parameters.Add("@loginid", txtLoginID.text)
cmdInsert.Parameters.Add("@Password", txtPassword.text)
cmdInsert.Parameters.Add("@Name", txtName.text)
cmdInsert.Parameters.Add("@Designation", txtDesignation.text)
cmdInsert.Parameters.Add("@Company", txtCompany.text)
cmdInsert.Parameters.Add("@Address", txtAddress.text)
cmdInsert.Parameters.Add("@Zip", txtZip.text)
cmdInsert.Parameters.Add("@City", txtCity)
cmdInsert.Parameters.Add("@Country", txtCountry.text)
cmdInsert.Parameters.Add("@Fax", txtFax.text)
cmdInsert.Parameters.Add("@Email", txtEmail.text)
cmdInsert.Parameters.Add("@Phone", txtPhone.text)
cmdInsert.Parameters.Add("@EmployeeSize", rbEmployeeSize.SelectedItem.Text)
cmdInsert.Parameters.Add("@Sales", rbSalesSize.SelectedItem.Text)
conUser.Open()
cmdInsert.ExecuteNonQuery()
conUser.Close()
Help! Please...