Click here to Skip to main content
15,881,413 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Order Help! Pin
Peter Leow13-Apr-14 15:21
professionalPeter Leow13-Apr-14 15:21 
Question1 form, 2 text boxes, how to write code to exchange text between boxes Pin
ChaseG12-Apr-14 13:24
ChaseG12-Apr-14 13:24 
AnswerRe: 1 form, 2 text boxes, how to write code to exchange text between boxes Pin
Wes Aday12-Apr-14 13:43
professionalWes Aday12-Apr-14 13:43 
AnswerRe: 1 form, 2 text boxes, how to write code to exchange text between boxes Pin
Tim Carmichael12-Apr-14 13:44
Tim Carmichael12-Apr-14 13:44 
GeneralRe: 1 form, 2 text boxes, how to write code to exchange text between boxes Pin
ChaseG12-Apr-14 17:13
ChaseG12-Apr-14 17:13 
GeneralRe: 1 form, 2 text boxes, how to write code to exchange text between boxes Pin
Richard MacCutchan12-Apr-14 22:01
mveRichard MacCutchan12-Apr-14 22:01 
AnswerRe: 1 form, 2 text boxes, how to write code to exchange text between boxes Pin
Tino Fourie24-Apr-14 3:46
Tino Fourie24-Apr-14 3:46 
Questionhow to import all csv files in c: drive to database ? Pin
sensizbenlik12-Apr-14 11:45
sensizbenlik12-Apr-14 11:45 
Imports System.IO
Imports System.IO.File
Imports System.Data
Imports System.Data.SqlClient
Public Class Form1


Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click

Dim table As New DataTable
table.Columns.Add("ZipCode")
table.Columns.Add("State")
table.Columns.Add("City")

Dim parser As New FileIO.TextFieldParser("C//:test.csv") >>>>>>>> the program is running i can import test.csv file but in c: drive i want any .csv file import to the program ("c://*.csv) command is not runnig. pls help can u give me an example??




parser.Delimiters = New String() {";"}
parser.HasFieldsEnclosedInQuotes = True
parser.TrimWhiteSpace = True
parser.ReadLine()
Do Until parser.EndOfData = True
table.Rows.Add(parser.ReadFields())
Loop
Dim Sql As String = "INSERT INTO tblZipCode (ZipCode,State,City) VALUES (@ZipCode,@State,@City)"
Dim SqlconnectionString As String = "Data Source=(localdb)\Projects;Initial Catalog=srkn;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False;"
Using connection As New SqlClient.SqlConnection(SqlconnectionString)

Dim cmd As New SqlClient.SqlCommand(Sql, connection) ' create command objects and add parameters
With cmd.Parameters
.Add("@ZipCode", SqlDbType.VarChar, 15, "ZipCode")
.Add("@State", SqlDbType.VarChar, 20, "State")
.Add("@City", SqlDbType.VarChar, 30, "City")
End With

Dim adapter As New SqlClient.SqlDataAdapter()
adapter.InsertCommand = cmd

'--Update the original SQL table from the datatable
Dim iRowsInserted As Int32 = _
adapter.Update(table)

End Using
End Sub

Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load

End Sub


End Class

AnswerRe: how to import all csv files in c: drive to database ? Pin
Wes Aday12-Apr-14 12:29
professionalWes Aday12-Apr-14 12:29 
AnswerRe: how to import all csv files in c: drive to database ? Pin
Mycroft Holmes12-Apr-14 14:43
professionalMycroft Holmes12-Apr-14 14:43 
Questionhow to import all csv files in a drive to database ? Pin
sensizbenlik11-Apr-14 12:10
sensizbenlik11-Apr-14 12:10 
AnswerRe: how to import all csv files in a drive to database ? Pin
PIEBALDconsult11-Apr-14 12:35
mvePIEBALDconsult11-Apr-14 12:35 
GeneralRe: how to import all csv files in a drive to database ? Pin
sensizbenlik11-Apr-14 13:17
sensizbenlik11-Apr-14 13:17 
GeneralRe: how to import all csv files in a drive to database ? Pin
Mycroft Holmes11-Apr-14 13:54
professionalMycroft Holmes11-Apr-14 13:54 
GeneralRe: how to import all csv files in a drive to database ? Pin
sensizbenlik12-Apr-14 8:00
sensizbenlik12-Apr-14 8:00 
GeneralRe: how to import all csv files in a drive to database ? Pin
Richard MacCutchan12-Apr-14 11:31
mveRichard MacCutchan12-Apr-14 11:31 
QuestionLogout button on a Main form Pin
waner michaud10-Apr-14 4:54
waner michaud10-Apr-14 4:54 
QuestionRe: Logout button on a Main form Pin
Eddy Vluggen10-Apr-14 6:45
professionalEddy Vluggen10-Apr-14 6:45 
AnswerRe: Logout button on a Main form Pin
waner michaud10-Apr-14 7:07
waner michaud10-Apr-14 7:07 
AnswerRe: Logout button on a Main form Pin
Eddy Vluggen10-Apr-14 7:38
professionalEddy Vluggen10-Apr-14 7:38 
GeneralRe: Logout button on a Main form Pin
waner michaud10-Apr-14 15:21
waner michaud10-Apr-14 15:21 
GeneralRe: Logout button on a Main form Pin
Eddy Vluggen11-Apr-14 0:38
professionalEddy Vluggen11-Apr-14 0:38 
QuestionValue of type 'String' cannot be converted to 'System.Windows.Forms.Control' Pin
Ankush Seth9-Apr-14 23:26
Ankush Seth9-Apr-14 23:26 
AnswerRe: Value of type 'String' cannot be converted to 'System.Windows.Forms.Control' Pin
Richard MacCutchan9-Apr-14 23:30
mveRichard MacCutchan9-Apr-14 23:30 
AnswerRe: Value of type 'String' cannot be converted to 'System.Windows.Forms.Control' Pin
Dave Kreskowiak10-Apr-14 2:18
mveDave Kreskowiak10-Apr-14 2:18 

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.