Advertisement
Guest User

Untitled

a guest
Aug 30th, 2015
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.83 KB | None | 0 0
  1. Protected Function FileUploaedToServer() As String
  2. Dim strName As String = ""
  3. If ThumbImg.HasFile Then
  4. strName = ThumbImg.FileName
  5. Dim strExt As String = System.IO.Path.GetExtension(strName)
  6. Dim strAryExt() As String = New String() {".jpg", ".gif", ".pmb", ".png"}
  7. For i As Integer = 0 To strAryExt.Length - 1
  8. If strExt = strAryExt(i) Then
  9. strName = Guid.NewGuid().ToString & strExt.ToString
  10. ThumbImg.SaveAs(Server.MapPath("~/images/" & strName))
  11. Return strName
  12. Exit For
  13. Else
  14. strName = "~/images/zeitungen_09.jpg"
  15. End If
  16. Next
  17. Else
  18. strName = "zeitungen_09.jpg"
  19.  
  20. End If
  21. Return strName
  22. End Function
  23. Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
  24. Try
  25. Dim con As New SqlConnection()
  26. con.ConnectionString = ConfigurationManager.ConnectionStrings("Elayan_SH").ConnectionString
  27.  
  28. Dim Qet As New SqlCommand()
  29. Qet.Connection = con
  30. With Qet
  31. .Parameters.Add("@Name", Data.SqlDbType.NVarChar)
  32. .Parameters.Add("@IMG", Data.SqlDbType.NVarChar)
  33.  
  34. End With
  35. Qet.CommandType = Data.CommandType.StoredProcedure
  36. Qet.CommandText = "AddPart"
  37. Qet.Parameters("@Name").Value = t1.Value
  38. Qet.Parameters("@IMG").Value = FileUploaedToServer()
  39. con.Open()
  40. Qet.ExecuteNonQuery()
  41. con.Close()
  42. MsgsRepeater.DataBind()
  43.  
  44. Catch ex As Exception
  45. ss.InnerText = ex.ToString()
  46. End Try
  47. ss.Visible = True
  48. t1.Value = ""
  49.  
  50.  
  51. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement