NOT storing in database

Question

0.00/5 (No votes)

See more:

VB

Private Sub SaveToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SaveToolStripMenuItem.Click
       Dim Con As New SqlConnection
       Con.ConnectionString = "Data Source=12.18.1.77;Initial Catalog=ACC_FG;User ID=sa;Password=***********"
       Dim cmd As New SqlCommand
       Dim status As String
       Dim ra As Integer
       If (RadioButton1.Checked) Then
           status = "title"
       ElseIf (RadioButton2.Checked) Then
           status = "regular"
       Else
           status = ""

       End If
       Dim cost As String
       If (CheckEdit1.Checked) Then
           cost = "Branches"
       ElseIf (CheckEdit2.Checked) Then
           cost = "Departments"
       ElseIf (CheckEdit3.Checked) Then
           cost = "projects"
       ElseIf (CheckEdit4.Checked) Then
           cost = "cost centres"
       Else
           cost = ""
       End If

       Try
           Con.Open()

           cmd.Connection = Con

           cmd = New SqlCommand("insert into Accounts values ('" & TextEdit1.Text & "','" & TextEdit2.Text & "','" & TextEdit3.Text & "','" & TextEdit4.Text & "','" & TextEdit5.Text & "','" & TextEdit6.Text & "','" & TextEdit7.Text & "','" & status & "','" & LookUpEdit1.Text & "','" & LookUpEdit2.Text & "','" & cost & "')", Con)
           ra = cmd.ExecuteNonQuery()
           Con.Close()

           MsgBox("CATEGORY ADDED", MsgBoxStyle.Information, "RECORD ADDED=" & ra)


       Catch ex As Exception
           MsgBox("not added", MsgBoxStyle.Critical)

       End Try

its not storing in my database
how can i clear this error

Posted 29-Dec-13 20:59pm

shakeer mp

Add a Solution

Comments

♥…ЯҠ…♥ 30-Dec-13 3:12am

Where and what error you are getting?

Aarti Meswania 30-Dec-13 3:54am

not enough info. provided, debug and check which exception you are getting?

shakeer mp 30-Dec-13 5:17am

The values is not storing in my database

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2013-12-29T21:36:00

Solution 1

Don't you think you should define destination fields?

SQL

INSERT INTO TableName (Field1, Field2, Field3)
VALUES('Value1', Value2, 'Value3')

Posted 29-Dec-13 21:36pm

Maciej Los

shakeer mp · Answer 2 · 2013-12-29T23:11:00

Solution 2

is requred in vb.net that destination is required

Posted 29-Dec-13 23:11pm

shakeer mp