Click here to Skip to main content
15,886,873 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: can not create activex component Pin
Dave Kreskowiak14-May-07 3:41
mveDave Kreskowiak14-May-07 3:41 
QuestionCreating user controls Pin
steve_rm12-May-07 0:49
steve_rm12-May-07 0:49 
AnswerRe: Creating user controls Pin
Christian Graus12-May-07 0:57
protectorChristian Graus12-May-07 0:57 
QuestionRadio Button insert option Pin
rrrriiizz12-May-07 0:43
rrrriiizz12-May-07 0:43 
AnswerRe: Radio Button insert option Pin
Christian Graus12-May-07 0:53
protectorChristian Graus12-May-07 0:53 
QuestionDataGridView Virtual Mode Sort Pin
_mubashir12-May-07 0:40
_mubashir12-May-07 0:40 
AnswerRe: DataGridView Virtual Mode Sort Pin
Dave Kreskowiak14-May-07 3:40
mveDave Kreskowiak14-May-07 3:40 
QuestionSQL statement problem [modified] Pin
Toubou11-May-07 23:34
Toubou11-May-07 23:34 
error I got is "no value given for one or more required parameters"

in cmd.CommandText, I tried <"SELECT Res FROM WordList WHERE Src='" & mtxt & "'">, and tried <"SELECT Res FROM WordList WHERE Src='test'">, both doesn't work
but it runs fine if I use <"SELECT * FROM WordList"> but this is not what I wanted.

Here's my code
Dim conn As New OleDb.OleDbConnection
Dim cmd As New OleDb.OleDbCommand
conn.ConnectionString = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database L" & _
         "ocking Mode=1;Data Source=""dictdb.mdb"";Jet OLEDB:Engine Type=5;Provider=""Micr" & _
         "osoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist secu" & _
         "rity info=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:Encrypt Data" & _
         "base=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on" & _
         " Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet " & _
         "OLEDB:Global Bulk Transactions=1"
' ^ Connection string copied from wizard, so this line is fine

conn.Open()

cmd.Connection = conn
cmd.CommandText = "SELECT Res FROM WordList WHERE Src = ?" 'I think error must be from this line
cmd.Parameters.Add(New OleDb.OleDbParameter("", mtxt)) 'or from this line

Dim rdr As OleDb.OleDbDataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection) 'error was thrown in this line at ExecuteReader
rdr.Read()
txtRes.Text = rdr.GetString(0)
rdr.Close()


Anybody know what's wrong?

Thanks in advance


-- modified at 7:07 Saturday 12th May, 2007
AnswerRe: SQL statement problem Pin
CPallini12-May-07 5:03
mveCPallini12-May-07 5:03 
Questionhelloooooooooooooooooo its urgent Pin
imanos11-May-07 22:50
imanos11-May-07 22:50 
AnswerRe: helloooooooooooooooooo its urgent Pin
theScorp11-May-07 23:10
theScorp11-May-07 23:10 
GeneralRe: helloooooooooooooooooo its urgent Pin
imanos13-May-07 22:39
imanos13-May-07 22:39 
AnswerRe: helloooooooooooooooooo its urgent Pin
Christian Graus12-May-07 0:13
protectorChristian Graus12-May-07 0:13 
JokeRe: helloooooooooooooooooo its urgent Pin
Paul Conrad12-May-07 14:31
professionalPaul Conrad12-May-07 14:31 
GeneralRe: helloooooooooooooooooo its urgent Pin
imanos13-May-07 22:50
imanos13-May-07 22:50 
GeneralRe: helloooooooooooooooooo its urgent Pin
Paul Conrad14-May-07 5:24
professionalPaul Conrad14-May-07 5:24 
Questionwhat is vb.net code for search the value in datagrid by select the value in combo box in vb.net windows application Pin
sathyan_829411-May-07 21:47
sathyan_829411-May-07 21:47 
AnswerRe: what is vb.net code for search the value in datagrid by select the value in combo box in vb.net windows application Pin
Christian Graus12-May-07 0:16
protectorChristian Graus12-May-07 0:16 
Questionwhat is vb.net code for delete a record in datagrid using vb.net windows application Pin
sathyan_829411-May-07 21:30
sathyan_829411-May-07 21:30 
AnswerRe: what is vb.net code for delete a record in datagrid using vb.net windows application Pin
harsh_c13-May-07 22:11
professionalharsh_c13-May-07 22:11 
Questionwhat is vb.net code for changing the values in datagrid and save the changed values in datagrid in vb.net windows application Pin
sathyan_829411-May-07 21:25
sathyan_829411-May-07 21:25 
QuestionVB in Excel Pin
sujithkumarsl11-May-07 20:23
sujithkumarsl11-May-07 20:23 
AnswerRe: VB in Excel Pin
harsh_c13-May-07 22:14
professionalharsh_c13-May-07 22:14 
QuestionWin32 APIs Pin
P P Vilsad11-May-07 19:56
P P Vilsad11-May-07 19:56 
AnswerRe: Win32 APIs Pin
Christian Graus11-May-07 20:01
protectorChristian Graus11-May-07 20:01 

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.