Click here to Skip to main content
15,917,177 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: VB & C# Pin
Dave Kreskowiak17-Jul-05 11:18
mveDave Kreskowiak17-Jul-05 11:18 
GeneralRe: VB & C# Pin
Rob Graham17-Jul-05 14:14
Rob Graham17-Jul-05 14:14 
GeneralRe: VB & C# Pin
Christian Graus17-Jul-05 18:06
protectorChristian Graus17-Jul-05 18:06 
GeneralRe: VB & C# Pin
Dave Kreskowiak18-Jul-05 2:32
mveDave Kreskowiak18-Jul-05 2:32 
GeneralRe: VB & C# Pin
Christian Graus18-Jul-05 12:54
protectorChristian Graus18-Jul-05 12:54 
GeneralRe: VB & C# Pin
Dave Kreskowiak19-Jul-05 2:53
mveDave Kreskowiak19-Jul-05 2:53 
GeneralRe: VB & C# Pin
Christian Graus19-Jul-05 10:40
protectorChristian Graus19-Jul-05 10:40 
Generalinsert statment Pin
Anonymous16-Jul-05 11:36
Anonymous16-Jul-05 11:36 
hellow to all ..
can anybody tell me what's wrong with this insert statment
i recive Syntax error message ...


If TextBox1.Text = "" Or TextBox2.Text = "" Or TextBox3.Text = "" Or TextBox4.Text = "" Then
MessageBox.Show("Fill in all the fields")
Else


Dim ConnString As String
ConnString = "provider=microsoft.jet.oledb.4.0;data source=C:\Message.mdb"
Dim MyOledbCommand As OleDbCommand = New OleDbCommand
Dim OleDbConn As OleDbConnection = New OleDbConnection(ConnString)
OleDbConn.Open()

Dim String1, String2, String3, String4 As String

Dim u_date As String






String1 = TextBox1.Text
String2 = TextBox2.Text
String3 = TextBox3.Text
String4 = TextBox4.Text
String5 = Date.Today

Try


MyOledbCommand.CommandText = "Insert Into User " _
& "(user_name,password,first_name,last_name,u_date) " _
& "Values (" & "'" & String1 & "', " & "'" & String2 & "', " & "'" & String3 & "', " & "'" & String4 & "', " & "'" & String5 & "')"


MessageBox.Show(MyOledbCommand.CommandText)
MyOledbCommand.Connection = OleDbConn

MyOledbCommand.ExecuteNonQuery()
OleDbConn.Close()




MessageBox.Show("User was added")
TextBox1.Clear()
TextBox2.Clear()
TextBox3.Clear()
TextBox4.Clear()
Catch err As System.Exception
MessageBox.Show(err.Message)
End Try
End If
GeneralBitblt .Net style help using (Matthew Hazlett) code Pin
Fraxx Daidouji16-Jul-05 6:47
Fraxx Daidouji16-Jul-05 6:47 
Generaladding new form Pin
Anonymous15-Jul-05 23:26
Anonymous15-Jul-05 23:26 
GeneralRe: adding new form Pin
[Marc]16-Jul-05 8:52
[Marc]16-Jul-05 8:52 
GeneralRe: adding new form Pin
Anonymous16-Jul-05 11:02
Anonymous16-Jul-05 11:02 
GeneralRe: adding new form Pin
[Marc]16-Jul-05 15:48
[Marc]16-Jul-05 15:48 
GeneralFolder Treeview with checkboxes (VB6) Pin
xer131415-Jul-05 22:30
xer131415-Jul-05 22:30 
Generalsqlce connection help Pin
Member 190267915-Jul-05 22:00
Member 190267915-Jul-05 22:00 
GeneralVb+scanned image reading Pin
royrana15-Jul-05 22:00
royrana15-Jul-05 22:00 
GeneralLog File Question Pin
LordLothar15-Jul-05 20:30
LordLothar15-Jul-05 20:30 
Generalcode net send Pin
Member 199098515-Jul-05 15:56
Member 199098515-Jul-05 15:56 
GeneralWindows Authentication IIS Pin
Harmonium15-Jul-05 9:12
Harmonium15-Jul-05 9:12 
GeneralWaiting on process to finish Pin
phraser15-Jul-05 9:11
phraser15-Jul-05 9:11 
GeneralRe: Waiting on process to finish Pin
Dave Kreskowiak15-Jul-05 9:30
mveDave Kreskowiak15-Jul-05 9:30 
GeneralRe: Waiting on process to finish Pin
phraser15-Jul-05 9:34
phraser15-Jul-05 9:34 
GeneralRe: Waiting on process to finish Pin
rwestgraham15-Jul-05 10:45
rwestgraham15-Jul-05 10:45 
GeneralRe: Waiting on process to finish Pin
Dave Kreskowiak15-Jul-05 11:24
mveDave Kreskowiak15-Jul-05 11:24 
GeneralRe: Waiting on process to finish Pin
phraser15-Jul-05 11:40
phraser15-Jul-05 11:40 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.