Click here to Skip to main content
15,914,500 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: What does "GetFiles" do in system directories? Pin
Richard Deeming25-Apr-16 2:01
mveRichard Deeming25-Apr-16 2:01 
GeneralRe: What does "GetFiles" do in system directories? Pin
Sonhospa25-Apr-16 2:46
Sonhospa25-Apr-16 2:46 
AnswerRe: What does "GetFiles" do in system directories? Pin
Bernhard Hiller25-Apr-16 22:12
Bernhard Hiller25-Apr-16 22:12 
GeneralRe: What does "GetFiles" do in system directories? Pin
Sonhospa26-Apr-16 3:23
Sonhospa26-Apr-16 3:23 
AnswerRe: What does "GetFiles" do in system directories? Pin
Sonhospa26-Apr-16 4:16
Sonhospa26-Apr-16 4:16 
QuestionUpdate UI of MDI Parent Pin
Sonhospa25-Apr-16 0:49
Sonhospa25-Apr-16 0:49 
QuestionVBScript DeleteFolder method cannot delete folders under System32 on Win 8.1 Pin
robwm121-Apr-16 10:36
robwm121-Apr-16 10:36 
AnswerRe: VBScript DeleteFolder method cannot delete folders under System32 on Win 8.1 Pin
Dave Kreskowiak21-Apr-16 14:31
mveDave Kreskowiak21-Apr-16 14:31 
AnswerRe: VBScript DeleteFolder method cannot delete folders under System32 on Win 8.1 Pin
Sonhospa25-Apr-16 0:59
Sonhospa25-Apr-16 0:59 
QuestionHow can i make the official VB.net TCP async Example work ?! Pin
Ghassan Mohamed Yousif20-Apr-16 23:53
Ghassan Mohamed Yousif20-Apr-16 23:53 
AnswerRe: How can i make the official VB.net TCP async Example work ?! Pin
Dave Kreskowiak21-Apr-16 2:09
mveDave Kreskowiak21-Apr-16 2:09 
GeneralRe: How can i make the official VB.net TCP async Example work ?! Pin
Ghassan Mohamed Yousif22-Apr-16 9:45
Ghassan Mohamed Yousif22-Apr-16 9:45 
GeneralRe: How can i make the official VB.net TCP async Example work ?! Pin
Dave Kreskowiak22-Apr-16 15:57
mveDave Kreskowiak22-Apr-16 15:57 
QuestionConversion from string "" to type 'Integer' is not valid Pin
kishore-201620-Apr-16 1:46
kishore-201620-Apr-16 1:46 
AnswerRe: Conversion from string "" to type 'Integer' is not valid Pin
Richard MacCutchan20-Apr-16 2:02
mveRichard MacCutchan20-Apr-16 2:02 
AnswerRe: Conversion from string "" to type 'Integer' is not valid Pin
Sascha Lefèvre20-Apr-16 2:29
professionalSascha Lefèvre20-Apr-16 2:29 
AnswerRe: Conversion from string "" to type 'Integer' is not valid Pin
CHill6020-Apr-16 2:37
mveCHill6020-Apr-16 2:37 
Don't concatenate strings to form your database queries - use Parameterised queries.
For example:
C#
cmd.CommandText =
    "insert into tbElogsheet(Allocate_id,Number_plate,Depart_date,Destination,Department,Traveller,NAME,km_read_dept,km_read_arr,Departure_time,Arrival_time,Over_time,Accident) VALUES (@code1,@code2,@code3,@code4,@code5,@code6,@code7,@code8,@code9,@code10,@code11,@code12,@code13)"
cmd.Parameters.AddWithValue("@code1", code1)
cmd.Parameters.AddWithValue("@code2", code2)
cmd.Parameters.AddWithValue("@code3", code3)
cmd.Parameters.AddWithValue("@code4", code4)
cmd.Parameters.AddWithValue("@code5", code5)
cmd.Parameters.AddWithValue("@code6", code6)
cmd.Parameters.AddWithValue("@code7", code7)
cmd.Parameters.AddWithValue("@code8", code8)
cmd.Parameters.AddWithValue("@code9", code9)
cmd.Parameters.AddWithValue("@code10", code10)
cmd.Parameters.AddWithValue("@code11", code11)
cmd.Parameters.AddWithValue("@code12", code12)
cmd.Parameters.AddWithValue("@code12", code13)
cmd.ExecuteNonQuery()

This might well cure your problem.
If it does not then use the Debugger to determine which line is causing the problem and let us know.
GeneralRe: Conversion from string "" to type 'Integer' is not valid Pin
kishore-201621-Apr-16 5:44
kishore-201621-Apr-16 5:44 
GeneralRe: Conversion from string "" to type 'Integer' is not valid Pin
Richard Deeming21-Apr-16 5:54
mveRichard Deeming21-Apr-16 5:54 
GeneralRe: Conversion from string "" to type 'Integer' is not valid Pin
CHill6021-Apr-16 6:17
mveCHill6021-Apr-16 6:17 
GeneralRe: Conversion from string "" to type 'Integer' is not valid Pin
kishore-201621-Apr-16 6:26
kishore-201621-Apr-16 6:26 
QuestionVB6 File not found: 'C:\Users\???\AppData\Local\Temp\VBB685.tmp' Pin
ThePotty120-Apr-16 1:07
ThePotty120-Apr-16 1:07 
AnswerRe: VB6 File not found: 'C:\Users\???\AppData\Local\Temp\VBB685.tmp' Pin
Dave Kreskowiak20-Apr-16 4:18
mveDave Kreskowiak20-Apr-16 4:18 
AnswerRe: VB6 File not found: 'C:\Users\???\AppData\Local\Temp\VBB685.tmp' Pin
CHill6021-Apr-16 6:13
mveCHill6021-Apr-16 6:13 
QuestionVBA minimum margin Pin
JR21219-Apr-16 21:00
JR21219-Apr-16 21:00 

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.