62,046
社区成员
发帖
与我相关
我的任务
分享
Imports Microsoft.VisualBasic
Imports System.Data.SqlClient
Imports System.Collections.Generic
Imports System.Data
Partial Class test
Inherits System.Web.UI.Page
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Try
Label1.Text = "<font color='green'><b>" & TextBox1.Text & "</b></font> 已经添加成功!"
Dim conn As SqlConnection
Dim cmd As SqlCommand
Dim file As String = FileUpload1.PostedFile.FileName.ToString()
Dim cmdString As String = "Insert test(Name,Img) Values ('" & TextBox1.Text & "','" & "~/img/" & file & "')"
conn = New SqlConnection("Data source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\database.mdf;Integrated security=true;user instance=true")
cmd = New SqlCommand(cmdString, conn)
conn.Open()
cmd.ExecuteNonQuery()
conn.Close()
Label2.Text = "~/img/" & FileUpload1.PostedFile.FileName.ToString()
Catch ex As Exception
Label1.Text = ex.Message()
End Try
GridView1.DataSourceID = ""
GridView1.DataSourceID = "sqldatasource1"
End Sub
End Class
Dim cmdString As String = "Insert test(Name,Img) Values ('" & TextBox1.Text & "','" & "~/img/" & file & "')"
conn = New SqlConnection("Data source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\database.mdf;Integrated security=true;user instance=true")
GridView1.DataSourceID = ""
GridView1.DataSourceID = "sqldatasource1"