windows form application with online database

Question

0.00/5 (No votes)

See more:

i have created an small application which edit image, i want to store it and retrieve from database, i have an online database, every thing is working fine but uploading and retrieval of image is too slow , how can i make it work fast.
connection code

VB

Try


          Dim gszStr As String


          gszStr = "Data Source =server ip;database=dbName ;UID=@# ;Password=$#$#$"
          Con.ConnectionString = gszStr
          Con.Open()
      Catch ex As Exception
          MsgBox("Not Connected To Internet", MsgBoxStyle.Information)

      End Try

  End Sub

Retrieval Code

VB

Try


           Dim ct1 As New SqlClient.SqlCommandBuilder
           Dim tmpds As New DataSet
           Dim tmpda As New SqlDataAdapter

           tmpda.SelectCommand = New SqlCommand(sql, Con)
           tmpda.Fill(tmpds)

           If tmpds.Tables(0).Rows.Count <> 0 Then


               PF_ShowImage(tmpds.Tables(0).Rows(0).Item(2))

           End If
       Catch ex As Exception
           MsgBox("Server Not Responding", MsgBoxStyle.Critical)

       End Try

Upload code

VB

Dim Sqlstr As String
      Dim daH As New SqlDataAdapter

      Dim data() As Byte = PF_SaveImage()

      PictureBox1.Image.Save("C:\NewFileName.jpg", System.Drawing.Imaging.ImageFormat.Jpeg)

      Sqlstr = ("Insert into TestImage Values(@Img)")              ''
      daH.InsertCommand = New SqlCommand(Sqlstr, Con)
      daH.InsertCommand.Parameters.Add(New SqlParameter("@Img", SqlDbType.Image)).Value = data

      daH.InsertCommand.ExecuteNonQuery()

      '******************Give save successfull message ***********************
      MsgBox("Values Saved Successfully", MsgBoxStyle.Information)

code is working fine but how to speed up things ?

Posted 10-May-13 20:54pm

akjan4

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2013-05-10T21:05:00

No, probably not.
The problem is almost certainly the amount of traffic between you and the server via the internet - which is restricted by you connection speed. If this operation is slow, it is likely that your connection speed is just not up to the job, particularly upload which is generally slower than download anyway. Depending on the connection speed and the size of your images, it could take some considerable time to view the images (try looking at large images from the net - they take time to appear for exactly the same reasons)

Using an "open" database on the internet directly is a fairly poor idea from a security point of view anyway, so live with the delay, or find a more local cache from your images. And I really, really hope you have disabled the "SA" account on your SQL server!