商品信息表用来存储有商品的信息。主要包括这几个字段：shopid(主键，商品号)，shopname(商品名称)，catalogid(商品的类型号)，shichangjia(商品价格),jianjie(商品简介)，pic(商品图片)。

4.1 数据库操作

首先编写一个数据库连接类DBcon，（放到app_code文件夹里）里面包括数据库连接，查询和数据库修改的具体方法。

Imports System

Imports System.IO

Imports System.web

Imports System.Data.Sql

Imports System.Data.SqlClient

Public Class DBcon

    Public Class DBcon

    Private Shared strConnection As String = ConfigurationManager.ConnectionStrings("ecshopConnectionString").ConnectionString

    Public Shared ReadOnly Property DBConnString() As String

        Get

            Return strConnection

        End Get

    End Property

    Public Shared Function Excuteselect(ByVal Sql As String) As DataTable

        Dim sqlcon As New SqlConnection(DBConnString)

        sqlcon.Open()

        Dim sqladapter As New SqlDataAdapter(Sql, sqlcon)

        Dim dsTemp As New DataSet

        Try