ผมเขียนโค้ดแค่ดึงข้อมูลใน data base มาโชว์อย่างเดียวแล้วจะต้องเขียนโค้ดส่วนอื่น ๆอย่างไรบ้างครับขอคำแนะนำหน่อยครับ ขอบคุณมากครับ
Imports System.Data
Imports System.Data.SqlClient
Partial Class loginproduct
Inherits System.Web.UI.Page
Dim strCon As String = ConfigurationManager.ConnectionStrings("conStr").ConnectionString
Dim con As New SqlConnection(strCon)
Dim com As SqlCommand
Dim da As SqlDataAdapter
Dim dr As SqlDataReader
Dim sql As String = ""
Dim dt As DataTable
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim strConn As String
Dim sqlProduct As String
strConn = "Data Source=.\SQLEXPRESS;Initial Catalog=tawan;Integrated Security=True"
sqlProduct = "SELECT Pro_ID, Pro_Name,Pro_Detial,Pro_Unit,Pro_Price,Pro_Type"
sqlProduct &= " FROM Product"
' PictureURL
Dim Conn As New SqlConnection(strConn)
Conn.Open()
Dim Com As New SqlCommand(sqlProduct, Conn)
Dim dr As SqlDataReader = Com.ExecuteReader
Load balance : Server 04
