Click here to Skip to main content
15,915,600 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Windows Logon in Visual Basic? Pin
Dave Kreskowiak31-Aug-05 2:33
mveDave Kreskowiak31-Aug-05 2:33 
QuestionFind max value in data Grid Pin
Jeeva Jose30-Aug-05 3:17
Jeeva Jose30-Aug-05 3:17 
AnswerRe: Find max value in data Grid Pin
_mubashir30-Aug-05 4:24
_mubashir30-Aug-05 4:24 
Question.Net Sockets Pin
Jason Weibel30-Aug-05 3:11
Jason Weibel30-Aug-05 3:11 
Questionhow to make a datagridcolumn as combobox Pin
kpsetty30-Aug-05 2:46
kpsetty30-Aug-05 2:46 
Answer[Message Deleted] Pin
dptalt31-Aug-05 3:42
dptalt31-Aug-05 3:42 
AnswerRe: how to make a datagridcolumn as combobox Pin
dptalt31-Aug-05 4:00
dptalt31-Aug-05 4:00 
Questionproblrem in sql statment Pin
microuser_200030-Aug-05 2:30
microuser_200030-Aug-05 2:30 
hellow to all ..
i am trying to write sql statment , it run fine ..
but when i run the statment i have this error "Syntax error in FROM clause"
her is my code

Dim sConnection, ssql, cmtype As String
sConnection = "provider=microsoft.jet.oledb.4.0;data source=C:\Printers.mdb"
ssql = "Select * From add Where(type="
ssql = ssql & "'" & Cmbtype.SelectedItem & "')"

Try

Dim OleDbConn As OleDbConnection = New OleDbConnection(sConnection)
OleDbConn.Open()
Dim MyDataReader As OleDbDataReader
Dim MyOleDbCommand As OleDbCommand = New OleDbCommand
Dim MyDataSet As New DataSet
Dim MyOleDataAdapter As OleDbDataAdapter = New OleDbDataAdapter
MessageBox.Show(ssql)
MyOleDataAdapter.SelectCommand = New OleDbCommand(ssql, OleDbConn)
MyOleDataAdapter.Fill(MyDataSet)
MyOleDbCommand.Connection = (OleDbConn)
MyOleDbCommand.CommandText = ssql

MyDataReader = MyOleDbCommand.ExecuteReader


Do While MyDataReader.Read

cmbModel.Items.Add(MyDataReader("ADD.[דגם מכונה]"))

Loop



MyDataReader.Close()
OleDbConn.Close()
OleDbConn.Dispose()

Catch err As System.Exception
MessageBox.Show(err.Message)
End Try


thxx for anyhelp ...

AnswerRe: problrem in sql statment Pin
Dave Kreskowiak30-Aug-05 2:41
mveDave Kreskowiak30-Aug-05 2:41 
QuestionRetrieving data from a datagrid Pin
daviiie30-Aug-05 1:13
daviiie30-Aug-05 1:13 
AnswerRe: Retrieving data from a datagrid Pin
_mubashir30-Aug-05 1:22
_mubashir30-Aug-05 1:22 
GeneralRe: Retrieving data from a datagrid Pin
daviiie30-Aug-05 1:30
daviiie30-Aug-05 1:30 
GeneralRe: Retrieving data from a datagrid Pin
|Spud|30-Aug-05 1:46
|Spud|30-Aug-05 1:46 
GeneralRe: Retrieving data from a datagrid Pin
daviiie30-Aug-05 1:48
daviiie30-Aug-05 1:48 
Questionmd5 Pin
ecentinela30-Aug-05 1:07
ecentinela30-Aug-05 1:07 
AnswerRe: md5 Pin
Insincere Dave30-Aug-05 10:40
Insincere Dave30-Aug-05 10:40 
GeneralRe: md5 Pin
ecentinela30-Aug-05 20:49
ecentinela30-Aug-05 20:49 
GeneralRe: md5 Pin
ecentinela30-Aug-05 22:32
ecentinela30-Aug-05 22:32 
GeneralRe: md5 Pin
Insincere Dave31-Aug-05 4:40
Insincere Dave31-Aug-05 4:40 
Questiongetting ms access columns Pin
tigertwareg30-Aug-05 1:06
tigertwareg30-Aug-05 1:06 
Questiondatabase to pdf Pin
Anonymous30-Aug-05 0:29
Anonymous30-Aug-05 0:29 
QuestionData Input in Text box Pin
prathiba_naresh29-Aug-05 22:46
prathiba_naresh29-Aug-05 22:46 
AnswerRe: Data Input in Text box Pin
toxcct30-Aug-05 0:07
toxcct30-Aug-05 0:07 
GeneralRe: Data Input in Text box Pin
prathiba_naresh30-Aug-05 0:27
prathiba_naresh30-Aug-05 0:27 
GeneralRe: Data Input in Text box Pin
toxcct30-Aug-05 0:58
toxcct30-Aug-05 0:58 

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.