如何在数据库中插入数据 [英] how to insert data in database
本文介绍了如何在数据库中插入数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何在已经创建的数据库中插入数据
ex。
i am new memer so so how how data in data base(conectivity)
解决方案
以下是使用带参数的查询在VB.NET中执行Insert操作的示例:
Dim cn 作为 SqlConnection
cn = 新 SqlConnection( server = localhost; uid = sa; pwd =; database = medisam)
cn.open
Dim Sqlstr as string
dim cmdInsert as new sqlcommand(Sqlstr,cn)
Sqlstr = 插入资产(代码,serial_number,tr ade_mark,callibration_date,class,category,subcategory)值(@ code,@ serial_number,@ trade_mark,@ calibration_date,@ class,@ category,@ subcategory)
cmdInsert.Parameters.Add( @ code,Data.SqlDbType.nvarchar).value = Textbox1.text
cmdInsert.Parameters .Add( @ serial_number,Data.SqlDbType.nvarchar).value = Textbox2.text
cmdInsert.Parameters.Add( @ trade_mark,Data.SqlDbType.nvarchar).value = Textbox3.text
cmdInsert.Parameters.Add( @ callibration_date,Data.SqlDbType。 nvarchar).value = Textbox4.text
cmdInsert.Parameters.Add( @ class ,Data.SqlDbType.nvarchar).value = Textbox5.text
cmdInsert.Parameters.Add( @ category,Data.SqlDbType.nvarchar).value = Textbox6.text
cmdInsert.Parameters.Add( @ subcategory,Data.SqlDbType.nvarchar).value = Textbox7.text
cmdInsert.ExecuteNonQuery()
cn.close
干杯,
Edo
Imports System.Data
Imports System.Data.OleDb
公共 类 Form1
Dim s,ins As String
私有 Sub Button1_Click( ByVal sender As System。 Object , ByVal e As System.EventArgs)句柄 Button1.Click
Dim con As 新 OleDbConnection(s)
con.Open()
Dim cmd 作为 新 OleDbCommand
ins = 插入stuinfo值('& TextBox1.Text& ','& TextBox2.Text& ','& ComboBox1.Text& ','& ComboBox2.Text& ','& DateTimePicker1.Value。日期& ','& TextBox4.Text& ')
cmd.CommandText = ins
cmd .Connection = con
cmd.ExecuteNonQuery()
cmd.Dispose()
MsgBox( 成功...................)
con.Close()
结束 Sub
私有 Sub Form1_Load( ByVal sender As 系统。对象, ByVal e 作为 System.EventArgs)句柄 MyBase .Load
s = Provider = Microsoft.Jet.OLEDB.4.0; Data S ource = C:\ Users \Dell\Desktop \ dell lab\cr\cr\bin\Debug\crdata.mdb
结束 Sub
end class
这可能有助于你
这取决于你的数据库类型正在使用即MS Access,SQL Server,Oracle等。
因为依赖于你的连接字符串和部分代码将会改变。
引用连接字符串不同类型的数据库请参见以下链接:
http://www.connectionstrings.com/ [ ^ ]
在SQL数据库中插入数据的代码示例:
Dim _objConnection As Sq lClient.SqlConnection
_objConnection = 新 SqlClient.SqlConnection( 你的连接字符串在这里)
_objConnection.Open()
Dim _mCommand 作为 字符串
_mCommand = Insert into TableName(Column1,Column2)值(@ Column1,@ Column2)
Dim _objCommand As 新 SqlClient.SqlCommand(_mCommand,_objConnection)
_objCommand.Parameters.AddWithValue( @ Column1, 值插入)
_objCommand.Parameters.AddWithValue( @ Column2, 值插入)
_objCommand。 ExecuteNonQuery()
_objConnection.Close()
_objCommand.Dispose()
代码泄漏将数据插入Access数据库:
Dim _objConnection As OleDb.OleDbConnection
_objConnection = 新 OleDb.OleDbConnection( 您的连接字符串在此处)
_objConnection.Open()
Dim _mCommand As 字符串
_mCommand = 插入TableName( Column1,Column2)值(@ Column1,@ Column2)
Dim _objCommand As 新 OleDb.OleDbCommand(_mCommand,_objConnection)
_objCommand.Parameters.AddWithValue( @ Column1, 要插入的值)
_objCommand.Parameters.AddWithValue( @ Column2, 要插入的值)
_objCommand.ExecuteNonQuery()
_objConnection.Close()
_objCommand.Dispose()
对于其他类型的数据库,Google就在那里。 :)
我希望它会对你有所帮助。 :)
how to insert data in data base allready created
ex.
i am new memer so how insert my data in data base (conectivity)
解决方案
Here's an example of an Insert operation in VB.NET using a query with parameters:
Dim cn As SqlConnection cn = New SqlConnection("server=localhost;uid=sa;pwd=;database=medisam") cn.open Dim Sqlstr as string dim cmdInsert as new sqlcommand(Sqlstr , cn) Sqlstr="Insert Into asset(code , serial_number , trade_mark , callibration_date , class , category , subcategory) Values (@code , @serial_number , @trade_mark , @callibration_date , @class , @category , @subcategory )" cmdInsert.Parameters.Add("@code",Data.SqlDbType.nvarchar).value=Textbox1.text cmdInsert.Parameters.Add("@serial_number",Data.SqlDbType.nvarchar).value=Textbox2.text cmdInsert.Parameters.Add("@trade_mark",Data.SqlDbType.nvarchar).value=Textbox3.text cmdInsert.Parameters.Add("@callibration_date",Data.SqlDbType.nvarchar).value=Textbox4.text cmdInsert.Parameters.Add("@class",Data.SqlDbType.nvarchar).value=Textbox5.text cmdInsert.Parameters.Add("@category",Data.SqlDbType.nvarchar).value=Textbox6.text cmdInsert.Parameters.Add("@subcategory",Data.SqlDbType.nvarchar).value=Textbox7.text cmdInsert.ExecuteNonQuery() cn.close
Cheers,
Edo
Imports System.Data Imports System.Data.OleDb Public Class Form1 Dim s, ins As String Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim con As New OleDbConnection(s) con.Open() Dim cmd As New OleDbCommand ins = "insert into stuinfo values('" & TextBox1.Text & "','" & TextBox2.Text & "','" & ComboBox1.Text & "','" & ComboBox2.Text & "','" & DateTimePicker1.Value.Date & "', '" & TextBox4.Text & "')" cmd.CommandText = ins cmd.Connection = con cmd.ExecuteNonQuery() cmd.Dispose() MsgBox("success...................") con.Close() End Sub Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load s = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Dell\Desktop\dell lab\cr\cr\bin\Debug\crdata.mdb" End Sub end class
this may help u
It depends on what type of data base you are using i.e MS Access, SQL Server, Oracle and so on.
Because depend on that your connection String and some part of code will change.
To refer Connection Strings for different types of data base see the following link :
http://www.connectionstrings.com/[^]
Code Example to Insert Data In SQL Database :
Dim _objConnection As SqlClient.SqlConnection _objConnection = New SqlClient.SqlConnection("Your Connection String goes here") _objConnection.Open() Dim _mCommand As String _mCommand = "Insert Into TableName(Column1, Column2) Values (@Column1, @Column2)" Dim _objCommand As New SqlClient.SqlCommand(_mCommand, _objConnection) _objCommand.Parameters.AddWithValue("@Column1", "Value To Insert") _objCommand.Parameters.AddWithValue("@Column2", "Value To Insert") _objCommand.ExecuteNonQuery() _objConnection.Close() _objCommand.Dispose()
Code Exaple To Insert Data Into Access Database :
Dim _objConnection As OleDb.OleDbConnection _objConnection = New OleDb.OleDbConnection("Your Connection String goes here") _objConnection.Open() Dim _mCommand As String _mCommand = "Insert Into TableName(Column1, Column2) Values (@Column1, @Column2)" Dim _objCommand As New OleDb.OleDbCommand(_mCommand, _objConnection) _objCommand.Parameters.AddWithValue("@Column1", "Value To Insert") _objCommand.Parameters.AddWithValue("@Column2", "Value To Insert") _objCommand.ExecuteNonQuery() _objConnection.Close() _objCommand.Dispose()
For other type of database Google is there. :)
I hope it will help you. :)
这篇关于如何在数据库中插入数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文