 |

|
If you Google for "email vb.net" or similar you will find lots of hits, including these CodeProject articles[^].
One of these days I'm going to think of a really clever signature.
|
|
|
|

|
Hi, im not a programmer, but trying to get the below to work, my text file in C drive it needs to be read one line at a time and each line sent to the php input
The php script on the test server works fine
http://home.exetel.com.au/upload/dataupload.php?action=get&pcinfo=pcinfo&exceldata1=exceldata1&exceldata2=exceldata2&exceldata3=exceldata3[^]
and the results page for excel is set
http://home.exetel.com.au/upload/dataupload.html[^]
This is the vbscript, but its for full file upload, i need it to read my text file in C:\Temp3\Test.txt, and each line to be passed on its own argument and then to be uploaded.
Code
do_vbsUpload
Sub do_vbsUpload()
If WScript.Arguments.Count < 2 Then InfoEcho
If InStr(CheckRequirements, "Error") > 0 Then InfoEcho
Dim FileName, DestURL, FieldName
FieldName = "FileField"
Dim aCounter, Arg
aCounter = 1 For Each Arg In WScript.Arguments
Select Case aCounter
Case 1: FileName = Arg
Case 2: DestURL = Arg
Case 3: FieldName = Arg
End Select
aCounter = aCounter + 1
Next
UploadFile DestURL, FileName, FieldName
End Sub
Sub UploadFile(DestURL, FileName, FieldName)
Const Boundary = "---------------------------0123456789012"
Dim FileContents, FormData
FileContents = GetFile(FileName)
FormData = BuildFormData(FileContents, Boundary, FileName, FieldName)
IEPostBinaryRequest DestURL, FormData, Boundary
End Sub
Function BuildFormData(FileContents, Boundary, FileName, FieldName)
Dim FormData, Pre, Po
Const ContentType = "application/upload"
Pre = "--" + Boundary + vbCrLf + mpFields(FieldName, FileName, ContentType)
Po = vbCrLf + "--" + Boundary + "--" + vbCrLf
Const adLongVarBinary = 205
Dim RS: Set RS = CreateObject("ADODB.Recordset")
RS.Fields.Append "b", adLongVarBinary, Len(Pre) + LenB(FileContents) + Len(Po)
RS.Open
RS.AddNew
Dim LenData
LenData = Len(Pre)
RS("b").AppendChunk (StringToMB(Pre) & ChrB(0))
Pre = RS("b").GetChunk(LenData)
RS("b") = ""
LenData = Len(Po)
RS("b").AppendChunk (StringToMB(Po) & ChrB(0))
Po = RS("b").GetChunk(LenData)
RS("b") = ""
RS("b").AppendChunk (Pre)
RS("b").AppendChunk (FileContents)
RS("b").AppendChunk (Po)
RS.Update
FormData = RS("b")
RS.Close
BuildFormData = FormData
End Function
Function IEPostBinaryRequest(URL, FormData, Boundary)
Dim IE: Set IE = CreateObject("InternetExplorer.Application")
IE.Navigate URL, , , FormData, _
"Content-Type: multipart/form-data; boundary=" + Boundary + vbCrLf
Do While IE.Busy
Wait 1, "Upload To " & URL
Loop
On Error Resume Next
IEPostBinaryRequest = IE.Document.body.innerHTML
IE.Quit
End Function
Function mpFields(FieldName, FileName, ContentType)
Dim MPTemplate MPTemplate = "Content-Disposition: form-data; name=""{field}"";" + _
" filename=""{file}""" + vbCrLf + _
"Content-Type: {ct}" + vbCrLf + vbCrLf
Dim Out
Out = Replace(MPTemplate, "{field}", FieldName)
Out = Replace(Out, "{file}", FileName)
mpFields = Replace(Out, "{ct}", ContentType)
End Function
Sub Wait(Seconds, Message)
On Error Resume Next
CreateObject("wscript.shell").Popup Message, Seconds, "", 64
End Sub
Function GetFile(FileName)
Dim Stream: Set Stream = CreateObject("ADODB.Stream")
Stream.Type = 1 Stream.Open
Stream.LoadFromFile FileName
GetFile = Stream.Read
Stream.Close
End Function
Function StringToMB(S)
Dim I, B
For I = 1 To Len(S)
B = B & ChrB(Asc(Mid(S, I, 1)))
Next
StringToMB = B
End Function
Sub InfoEcho()
Dim Msg
Msg = Msg + "Upload file using http And multipart/form-data" & vbCrLf
Msg = Msg + "Copyright (C) 2001 Antonin Foller, PSTRUH Software" & vbCrLf
Msg = Msg + "use" & vbCrLf
Msg = Msg + "[cscript|wscript] fupload.vbs file url [fieldname]" & vbCrLf
Msg = Msg + " file ... Local file To upload" & vbCrLf
Msg = Msg + " url ... URL which can accept uploaded data" & vbCrLf
Msg = Msg + " fieldname ... Name of the source form field." & vbCrLf
Msg = Msg + vbCrLf + CheckRequirements
WScript.Echo Msg
WScript.Quit
End Sub
Function CheckRequirements()
Dim Msg
Msg = "This script requires some objects installed To run properly." & vbCrLf
Msg = Msg & CheckOneObject("ADODB.Recordset")
Msg = Msg & CheckOneObject("ADODB.Stream")
Msg = Msg & CheckOneObject("InternetExplorer.Application")
CheckRequirements = Msg
End Function
Function CheckOneObject(oClass)
Dim Msg
On Error Resume Next
CreateObject oClass
If Err = 0 Then Msg = "OK" Else Msg = "Error:" & Err.Description
CheckOneObject = oClass & " - " & Msg & vbCrLf
End Function
Really hope some one is able to help, i just cant get my head around this to figure it out. Im so lost in the code
Hope this is ok to post here i searched and found nothing for vbscript at google
vbscript site:http://www.codeproject.com/Forums/
Once things are set i do have a htaccess file to try and restrict people to it by IP, i hope that should make it safe and ok
|
|
|
|

|
Hi friends, I am a C Developer. Now i assigned to a new project which has front end as vb, Application layer is C++ and back end is sql server. since i am new to these platforms i am trying to implement the application using this. i tried one small application using our company's already written api. for example, i had created a front end with two text boxes, and when i try to save the record, its showing run time error like, "method 'insert' of object 'datasource' failed". i just want to know the reason why these error showing? and how to rectify it?
|
|
|
|

|
Welcome to the VB.NET forum. I suggest you post your question in a more relevant forum, including a code-snippet of the code that throws the error.
|
|
|
|

|
Dear(s) I somehow stuck. Pleaes help me in this regard. I am trying to incorporte Arabic language support in my application. I have done the following. 1. Took Textbox with Arial Unicode MS Font and Arabic charset. 2. At backend I change my field to NVARCHAR to hold unicode. Alls went well execpt, When i took input in arabic from user, the textbox gives me this ÚÇãÑ ÑÔíÏ after taking input. I ll try to convert it into string but fail. And in SQL Server the Insert statement saves the same it get from textbox not the arabic text. Please help me in this regard Ahsan Sheraz
|
|
|
|

|
The VB.NET IDE is available for free, as is the runtime. I strongly suggest you switch your platform. VB6 is no longer actively supported.
To make the decision easier; this is a problem with text-encodings. VB.NET would convert it to UTF and be done with it - no more "weird characters".
|
|
|
|

|
Dear Brother Thanks very much for your reply, but I am working on an ERP having 7 fully functional modules, I cannot switch over right now the platform. Please help me. Let me tell you this junk is displaying correct value in text box or crystal repots having font supports arabic charset. But at the time of saving in (Insert statement) textbox.text gives me this junk, How can I play with them. Thanks in advance ahsan sheraz
|
|
|
|

|
There's nothing to play with. First, VB6 was know to have bad support for Right-to-Left text.
But, the textbox will display any text it's given, provided the font being used supports the appropriate characters. It'll look like junk if the font doesn't support it. So, where exactly are you seeing this "junk"?
|
|
|
|

|
Member 9707221 wrote: Dear Brother
I'm neither.
Member 9707221 wrote: Let me tell you this junk is displaying correct value in text box or crystal repots having font supports arabic charset. But at the time of saving in (Insert statement) textbox.text gives me this junk, How can I play with them.
Like I said, it's a dead language. If you want to use it, you'll be doing a lot of archeology.
http://blogs.msdn.com/b/vsarabic/archive/2012/04/05/install-arabic-vb6-applications.aspx[^].
|
|
|
|

|
i want to use class Win32_DefragAnalysis(WMI) to scan status of other volume, but it is not active, exactly, the For-each is not work, please help me, <pre lang="vb">Private Sub defrag_analysis() On Error Resume Next Dim item Dim nameSQL Dim wmiOBJECT Dim itemCOLLECTION Set wmiOBJECT = GetObject("Winmgmts:\\.\root\cimv2") nameSQL = "select * from Win32_DefragAnalysis" ' Where VolumeSize > 0 " Set itemCOLLECTION = wmiOBJECT.ExecQuery(nameSQL) For Each item In itemCOLLECTION 'not print properties of item MsgBox "VolumeSize : " & item.VolumeSize MsgBox "Name : " & item.VolumeName MsgBox "FreeSpace :" & item.FreeSpace MsgBox "AverageFileSize : " & item.AverageFileSize Next MsgBox "jump here" End Sub </pre>
|
|
|
|
 |
|