VB.Net Code - Saving Textbox data / dropdown value / calendar selection / radio button into SQL DB

Question

0.00/5 (No votes)

See more:

Hi all
I'm new to this coding game so I need a bit of assistance

I need to build a simple Website using VS2012 VB.NET,

I have a simple test website that contains 1 textbox(name) - 1 dropdown (gender) - and a calendar (dob)

with a SQL database (TSTWEBDEV) With the columns 'Name' 'Gender' 'DOB'

Data Source=TSTWEBDEV;Initial Catalog=TestWebAp;User ID=testWA;Password=12345

I have a submit button

protected void Button1_Click(object sender, EventArgs e)

Question is what is the code to insert this into the DB?

easy one for those who know! :)
any help will be great! thanks

Posted 22-Dec-13 4:42am

Member 10481933

Add a Solution

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)

OriginalGriff · Answer 1 · 2013-12-22T04:57:00

Solution 1

Try something like this:

VB

Using con As New SqlConnection(strConnect)
    con.Open()
    Using cmd As New SqlCommand("INSERT INTO myTable (myColumn1, myColumn2) VALUES (@C1, @C2)", con)
        cmd.Parameters.AddWithValue("@C1", myValueForColumn1)
        cmd.Parameters.AddWithValue("@C2", myValueForColumn2)
        cmd.ExecuteNonQuery()
    End Using
End Using

Posted 22-Dec-13 4:57am

OriginalGriff

Comments

OriginalGriff 22-Dec-13 11:53am

If you mean "can I have your email?" the answer is "no!" :laugh:
I get enough emails every day, I don't need any more, thanks!
If you have specific areas of confusion, then ask here about them. (That way, others see them too, so you may get responses from more than one person - which can be helpful at times)

Member 10481933 22-Dec-13 12:05pm

hahaha ah bummer! no worries, will have a dig at it and see what i can find :)

OriginalGriff 22-Dec-13 12:14pm

Go for it! :laugh:

Aravindba · Answer 2 · 2013-12-22T18:45:00

VB

Dim objcon As New SqlConnection
objcon.ConnectionString = My.Settings.CS
objcon.Open()

  
Dim objcmd As New SqlCommand("Insert into table([name],gender,dob) values('" + txtname.Text.Trim + "','" + ddl.Text.Trim+ "','" + Calendar1.SelectedDate.ToString("dd/MM/yyyy") + "')", objcon)
                objcmd.ExecuteNonQuery()

try this

Regards
AravindB