Click here to Skip to main content
15,898,746 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Opening a project Pin
josedariom31-Jan-07 14:01
josedariom31-Jan-07 14:01 
GeneralRe: Opening a project Pin
Christian Graus31-Jan-07 14:43
protectorChristian Graus31-Jan-07 14:43 
GeneralRe: Opening a project Pin
josedariom31-Jan-07 14:51
josedariom31-Jan-07 14:51 
GeneralRe: Opening a project Pin
Christian Graus31-Jan-07 16:26
protectorChristian Graus31-Jan-07 16:26 
QuestionPrinting a document in VB.NET 2005 Pin
harveyhanson31-Jan-07 11:18
harveyhanson31-Jan-07 11:18 
QuestionHow to tell if another application is active or not. [modified] Pin
rnamro31-Jan-07 9:54
rnamro31-Jan-07 9:54 
AnswerRe: How to tell if another application is active or not. Pin
shreekar1-Feb-07 0:07
shreekar1-Feb-07 0:07 
Questionfunction Pin
jds120731-Jan-07 8:55
jds120731-Jan-07 8:55 
I have two subs with the same set of code and I want to combine them into one by creating a function and passing the variables. Here are the two subs code:

Private Sub ImportMO()
Dim dtTable As New DataTable
Dim row As DataRow

Dim DtReceived As String = vbNull
Dim DtBackorder As String = vbNull
Dim DtCanceled As String = vbNull
Dim customername As String
Dim status As String = vbNull
Dim SoNum As String = vbEmpty

Dim Conn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Scanning Files;Extended Properties=""Text;HDR=No;FMT=FixedLength"""
Dim SQLstr As String = "SELECT * FROM lsprint_MO_temp.txt"
Dim da As New OleDb.OleDbDataAdapter(SQLstr, Conn)


Private Sub ImportMS()
Dim dtTable As New DataTable
Dim row As DataRow

Dim DtReceived As String = ""
Dim DtBackorder As String = ""
Dim DtCanceled As String = ""
Dim customername As String
Dim status As String = vbNull

Dim Conn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Scanning Files;Extended Properties=""Text;HDR=No;FMT=FixedLength"""
Dim SQLstr As String = "SELECT * FROM lsprint_MS_temp.txt"
Dim da As New OleDb.OleDbDataAdapter(SQLstr, Conn)

In the connection string, I want to pass a variable for the source and in the sql string I want pass a variable for the files.

Here is what I have so far,

Public Function ImportFeed(ByVal OrderFile As String, ByVal OrderFilePath As String) As String

End Function

I am lost from here. I know what I want to do but don't know how to do it.

Can anyone help me with this function?

AnswerRe: function Pin
Christian Graus31-Jan-07 9:18
protectorChristian Graus31-Jan-07 9:18 
GeneralRe: function Pin
jds120731-Jan-07 9:31
jds120731-Jan-07 9:31 
GeneralRe: function Pin
Christian Graus31-Jan-07 9:40
protectorChristian Graus31-Jan-07 9:40 
AnswerRe: function Pin
Clanguage31-Jan-07 9:48
Clanguage31-Jan-07 9:48 
Questionneed help with crystal reporting in vb.net 2003 Pin
JustmeNick31-Jan-07 8:09
JustmeNick31-Jan-07 8:09 
QuestionHow create a client server windows application Pin
Tomic31-Jan-07 7:29
Tomic31-Jan-07 7:29 
AnswerRe: How create a client server windows application Pin
xstoneheartx31-Jan-07 23:44
xstoneheartx31-Jan-07 23:44 
QuestionHow to put Combobox in datagrid at runtime Pin
Member 374296531-Jan-07 6:34
Member 374296531-Jan-07 6:34 
QuestionMDI Form ToolStripMenu Pin
dpagka31-Jan-07 3:51
dpagka31-Jan-07 3:51 
AnswerRe: MDI Form ToolStripMenu Pin
shreekar1-Feb-07 0:11
shreekar1-Feb-07 0:11 
QuestionAny one can help me Pin
Ahmed El-Badry31-Jan-07 3:42
Ahmed El-Badry31-Jan-07 3:42 
AnswerRe: Useless subject Pin
Guffa31-Jan-07 6:07
Guffa31-Jan-07 6:07 
GeneralRe: Useless subject Pin
Ahmed El-Badry31-Jan-07 9:31
Ahmed El-Badry31-Jan-07 9:31 
QuestionHow do you adjust graph Axes? Pin
KojoAmuel31-Jan-07 3:05
KojoAmuel31-Jan-07 3:05 
AnswerRe: How do you adjust graph Axes? Pin
CPallini31-Jan-07 7:47
mveCPallini31-Jan-07 7:47 
GeneralRe: How do you adjust graph Axes? Pin
KojoAmuel31-Jan-07 8:04
KojoAmuel31-Jan-07 8:04 
GeneralRe: How do you adjust graph Axes? Pin
CPallini31-Jan-07 9:02
mveCPallini31-Jan-07 9:02 

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.