Visual Basic

jds1207 wrote:

I am inserting text files into MySQL using vb.net. However, when I insert the files into the database it only insert every other file. For example, it will insert one file then the next row will be zeros

Colin Angus Mackay wrote:

Oh! oh!! I know! I know! ** Sticks hand high in the air**

Colin Angus Mackay wrote:

We should use parameterised queries! We should use them becuase it makes the application safe from people trying to inject into it!

jds1207 wrote:

The file that I am cleaning is being cleaned and making the file double spaced.

Dim sourceFilename As String = "C:\Scanning files\lsprint_MO.txt"
Dim tempFilename As String = "C:\Scanning files\lsprint_MO_temp.txt"
Dim textline As String
 
If System.Io.File.Exists(sourceFilename) Then
    Try
        Dim sr As New StreamReader(sourceFilename)
        Do
            textline = sr.ReadLine()
 
            ' Why are you using String.Concat??  Your building a line and adding
            ' blank lines to the textline string.  Why??

            ' Parse your line here and make sure that the values you got are VALID!
            ' If not, jump to some other method to report or log the problem.
 
           ' If we get here, the data looks good.  Add it to the database.
            ' Call your database code here and pass the "cleaned" values to it.
        Loop Until textline Is Nothing
 
    Catch ex As Exception
        ' Something happened during the file read or database call.
        ' Log the error or report it somehow and forget the rest of the file.
 
    Finally
        If Not sr Is Nothing Then
            sr.Close()
        End If
    End Try

Mayuri Gaikwad wrote:

Want you to help me.

indian143 wrote:

I am converting a ActiveX(DSO Framer)control into .Net assembly.

indian143 wrote:

1. I was able to import it as assembly using "Tlbimp" utility,

indian143 wrote:

2. I could able to convert the content in to Intermediate Language form by using utility "Ildasm" utility. But

indian143 wrote:

3. When I tried to edit the content for verification by using the utility "Ilasm" its giving error as below

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load<br />
   'Hide the form while splash screen is visible<br />
   Me.Hide()<br />
<br />
   'Insert your form loading code...<br />
<br />
   'Reveal the form when loading is complete<br />
   Me.Show()<br />
End Sub