Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
C# Community
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Home
Forums
Database
Database General Discussion
insert into MS Access using vb.NEt
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="nsj_1983" data-source="post: 3336" data-attributes="member: 1485"><p>My code is </p><p></p><p><span style="font-size: 10px"><span style="font-size: 10px"><span style="color: #0000ff">Private</span></span> <span style="font-size: 10px"><span style="color: #0000ff">Sub</span></span><span style="font-size: 10px"> Button1_Click(</span><span style="font-size: 10px"><span style="color: #0000ff">ByVal</span></span><span style="font-size: 10px"> sender </span><span style="font-size: 10px"><span style="color: #0000ff">As</span></span><span style="font-size: 10px"> System.Object, </span><span style="font-size: 10px"><span style="color: #0000ff">ByVal</span></span><span style="font-size: 10px"> e </span><span style="font-size: 10px"><span style="color: #0000ff">As</span></span><span style="font-size: 10px"> System.EventArgs) </span><span style="font-size: 10px"><span style="color: #0000ff">Handles</span></span><span style="font-size: 10px"> Button1.Click</span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span><span style="font-size: 10px"><span style="color: #0000ff">Dim</span></span><span style="font-size: 10px"> strConn </span><span style="font-size: 10px"><span style="color: #0000ff">As</span></span> <span style="font-size: 10px"><span style="color: #0000ff">String</span></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"><span style="color: #0000ff"></span></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"><span style="color: #0000ff"></span></span><span style="font-size: 10px"><span style="color: #0000ff">Dim</span></span><span style="font-size: 10px"> strSQL </span><span style="font-size: 10px"><span style="color: #0000ff">As</span></span> <span style="font-size: 10px"><span style="color: #0000ff">String</span></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"><span style="color: #0000ff"></span></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"><span style="color: #0000ff"></span></span><span style="font-size: 10px"><span style="color: #0000ff">Dim</span></span><span style="font-size: 10px"> Conn </span><span style="font-size: 10px"><span style="color: #0000ff">As</span></span><span style="font-size: 10px"> OleDb.OleDbConnection</span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span><span style="font-size: 10px"><span style="color: #0000ff">Dim</span></span><span style="font-size: 10px"> cmd </span><span style="font-size: 10px"><span style="color: #0000ff">As</span></span><span style="font-size: 10px"> OleDb.OleDbCommand</span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px">Label1.Visible = </span><span style="font-size: 10px"><span style="color: #0000ff">False</span></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"><span style="color: #0000ff"></span></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"><span style="color: #0000ff"></span></span><span style="font-size: 10px">strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _</span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px">"Data Source=C:\db2.mdb;" & _</span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px">"User ID=Admin;" & _</span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px">"Password="</span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span><span style="font-size: 10px"><span style="color: #008000">'Pass the Connection string to OleDbConnection object.</span></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"><span style="color: #008000"></span></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"><span style="color: #008000"></span></span><span style="font-size: 10px">Conn = </span><span style="font-size: 10px"><span style="color: #0000ff">New</span></span><span style="font-size: 10px"> OleDb.OleDbConnection(strConn)</span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px">cmd = </span><span style="font-size: 10px"><span style="color: #0000ff">New</span></span><span style="font-size: 10px"> OleDb.OleDbCommand(strSQL, Conn)</span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px">Conn.Open()</span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span><span style="font-size: 10px"><span style="color: #008000">'Build the SQL strings. </span></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"><span style="color: #008000"></span></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"><span style="color: #008000"></span></span><span style="font-size: 10px">strSQL = "insert into table1 values( 99,'sad')"</span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span><span style="font-size: 10px"><span style="color: #0000ff">Try</span></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"><span style="color: #0000ff"></span></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"><span style="color: #0000ff"></span></span><span style="font-size: 10px">cmd.ExecuteNonQuery()</span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span><span style="font-size: 10px"><span style="color: #0000ff">Catch</span></span><span style="font-size: 10px"> ex </span><span style="font-size: 10px"><span style="color: #0000ff">As</span></span><span style="font-size: 10px"> OleDb.OleDbException</span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px">Label1.Visible = </span><span style="font-size: 10px"><span style="color: #0000ff">True</span></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"><span style="color: #0000ff"></span></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"><span style="color: #0000ff"></span></span><span style="font-size: 10px">Label1.Text = ex.ToString</span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span><span style="font-size: 10px"><span style="color: #0000ff">End</span></span> <span style="font-size: 10px"><span style="color: #0000ff">Try</span></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"><span style="color: #0000ff"></span></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"><span style="color: #0000ff"></span></span><span style="font-size: 10px">Conn.Close()</span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"></span><span style="font-size: 10px"><span style="color: #0000ff">End</span></span> <span style="font-size: 10px"><span style="color: #0000ff">Sub</span></span></span></p><p><span style="font-size: 10px"></span></p><p><span style="font-size: 10px"></span></p><p><span style="font-size: 10px"></span></p><p><span style="font-size: 10px"></span></p><p><span style="font-size: 10px"></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"><span style="color: #0000ff">The database table is table1 in db1.mdb.</span></span></span></p><p><span style="font-size: 10px"></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"><span style="color: #0000ff">the error occurs at cmd.ExecuteNonQuery()</span></span></span></p><p><span style="font-size: 10px"></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"><span style="color: #0000ff">could anyone help me . please!</span></span></span></p><p><span style="font-size: 10px"><span style="font-size: 10px"><span style="color: #0000ff"></span></span></span></p></blockquote><p></p>
[QUOTE="nsj_1983, post: 3336, member: 1485"] My code is [size=2][size=2][color=#0000ff]Private[/color][/size][size=2] [/size][size=2][color=#0000ff]Sub[/color][/size][size=2] Button1_Click([/size][size=2][color=#0000ff]ByVal[/color][/size][size=2] sender [/size][size=2][color=#0000ff]As[/color][/size][size=2] System.Object, [/size][size=2][color=#0000ff]ByVal[/color][/size][size=2] e [/size][size=2][color=#0000ff]As[/color][/size][size=2] System.EventArgs) [/size][size=2][color=#0000ff]Handles[/color][/size][size=2] Button1.Click [/size][size=2][color=#0000ff]Dim[/color][/size][size=2] strConn [/size][size=2][color=#0000ff]As[/color][/size][size=2] [/size][size=2][color=#0000ff]String [/color][/size][size=2][/size][size=2][color=#0000ff]Dim[/color][/size][size=2] strSQL [/size][size=2][color=#0000ff]As[/color][/size][size=2] [/size][size=2][color=#0000ff]String [/color][/size][size=2][/size][size=2][color=#0000ff]Dim[/color][/size][size=2] Conn [/size][size=2][color=#0000ff]As[/color][/size][size=2] OleDb.OleDbConnection [/size][size=2][color=#0000ff]Dim[/color][/size][size=2] cmd [/size][size=2][color=#0000ff]As[/color][/size][size=2] OleDb.OleDbCommand Label1.Visible = [/size][size=2][color=#0000ff]False [/color][/size][size=2]strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\db2.mdb;" & _ "User ID=Admin;" & _ "Password=" [/size][size=2][color=#008000]'Pass the Connection string to OleDbConnection object. [/color][/size][size=2]Conn = [/size][size=2][color=#0000ff]New[/color][/size][size=2] OleDb.OleDbConnection(strConn) cmd = [/size][size=2][color=#0000ff]New[/color][/size][size=2] OleDb.OleDbCommand(strSQL, Conn) Conn.Open() [/size][size=2][color=#008000]'Build the SQL strings. [/color][/size][size=2]strSQL = "insert into table1 values( 99,'sad')" [/size][size=2][color=#0000ff]Try [/color][/size][size=2]cmd.ExecuteNonQuery() [/size][size=2][color=#0000ff]Catch[/color][/size][size=2] ex [/size][size=2][color=#0000ff]As[/color][/size][size=2] OleDb.OleDbException Label1.Visible = [/size][size=2][color=#0000ff]True [/color][/size][size=2]Label1.Text = ex.ToString [/size][size=2][color=#0000ff]End[/color][/size][size=2] [/size][size=2][color=#0000ff]Try [/color][/size][size=2]Conn.Close() [/size][size=2][color=#0000ff]End[/color][/size][size=2] [/size][size=2][color=#0000ff]Sub[/color][/size] [size=2][color=#0000ff][/color][/size] [size=2][color=#0000ff][/color][/size] [size=2][color=#0000ff][/color][/size] [size=2][color=#0000ff][/color][/size] [size=2][color=#0000ff][/color][/size] [size=2][color=#0000ff]The database table is table1 in db1.mdb.[/color][/size] [size=2][color=#0000ff][/color][/size] [size=2][color=#0000ff]the error occurs at cmd.ExecuteNonQuery()[/color][/size] [size=2][color=#0000ff][/color][/size] [size=2][color=#0000ff]could anyone help me . please! [/color][/size][/size] [/QUOTE]
Insert quotes…
Verification
Post reply
Home
Forums
Database
Database General Discussion
insert into MS Access using vb.NEt
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.
Accept
Learn more…
Top
Bottom