VB.Net代码 - 将文本框数据/下拉值/日历选择/单选按钮保存到SQL DB中 [英] VB.Net Code - Saving Textbox data / dropdown value / calendar selection / radio button into SQL DB
问题描述
大家好
我是这个编码游戏的新手,所以我需要一些帮助
我需要建立一个简单的网站使用VS2012 VB.NET,
我有一个简单的测试网站,包含1个文本框(名称) - 1个下拉列表(性别) - 和日历(dob)
带有SQL数据库的
(TSTWEBDEV)列'名称''性别''DOB'
数据源= TSTWEBDEV;初始目录= TestWebAp;用户ID = testWA;密码= 12345
我有一个提交按钮
protected void Button1_Click(object sender,EventArgs e)
问题是将此插入数据库的代码是什么?
对于那些知道的人来说很容易! :)
任何帮助都会很棒!谢谢
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
推荐答案
尝试这样的事情:
Try something like this:
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
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()
试试吧是
问候
AravindB
try this
Regards
AravindB
这篇关于VB.Net代码 - 将文本框数据/下拉值/日历选择/单选按钮保存到SQL DB中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!