Hi all
Please find the below details and help me to solve the prob
code:
Dim con1 As New SqlConnection("Data Source=KITT7-PC;Initial Catalog=project;User ID=sa;Password=1234")
con1.Open()
Dim cmd As New SqlCommand("insert into CompanyCreation values('" & txtCompanyName.Text & "','" & txtCompanyCode.Text & "','" & txtCompanyAlias.Text & "','" & txtAddress.Text & "','" & cmbCity.Text & "','" & txtPincode.Text & "','" & cmbState.Text & "','" & txtCountry.Text & "','" & txtPh1.Text & "','" & txtPh2.Text & "','" & txtPh3.Text & "','" & txtFax.Text & "','" & txtMobile.Text & "','" & txtEmail.Text & "','" & txtWebsite.Text & "','" & txtServiceTAX.Text & "','" & txtVATNo.Text & "','" & cmbTaxing.Text & "','" & cmbFinYear.Text & "','" & txtCurrency.Text & "','" & txtITPan.Text & "','" & cmbAccountingSystem.Text & "','" & txtTIN.Text & "','" & txtCST.Text & "','" & txtWardno.Text & "','" & txtAdminUser.Text & "','" & txtAdminPass.Text & "','" & txtConfirmPass.Text & "','" & txtcodex.Text & "','" & txtPass.Text & "','" & txtConfirmPass.Text & "')", con1)
cmd.ExecuteNonQuery()
Catch ex As Exception
End Try
database:
ID int
CompanyCode varchar(50)
CompanyName varchar(25)
Alias varchar(100)
AgentType varchar(100)
Address varchar(25)
City varchar(25)
Pincode int
State varchar(100)
Country varchar(100)
Ph1 numeric(10, 0)
Ph2 numeric(10, 0)
Ph3 numeric(10, 0)
Fax numeric(10, 0)
Mobile numeric(10, 0)
Email nvarchar(30)
Website nvarchar(30)
Taxing varchar(30)
ServiceTax decimal(10, 2)
VATNo int
FinancialYearStart int
IndianCurrencySymbol varchar(25)
ITPan varchar(25)
AccountingSystem varchar(15)
Account varchar(25)
TIN numeric(10, 0)
CST varchar(25)
WardNo int
AdminUser varchar(30)
AdminPass varchar(30)
LocatonofDataSave varchar(50)
Codex int
I am getting the error saying
Error converting data type varchar to numeric.
Please tell me where is the problem.