Line 18: Dim sql As String
Line 19: '取得產品名稱/型號
Line 20: sql = "SELECT TOP 1 a.[" & webLang & "_desc1] AS [desc1], a.[" & webLang & "_title] AS [title], b.[pic] as [mainpic], a.[categoryId] FROM [products] a join [products_color] b ON b.[productid] = a.[serno] WHERE a.[serno] ='" & Request.Params("id").ToString & "' and a.del = 'N' "
Line 21: Dim dt As DataTable = obj.ExecuteDataTable(sql)
Line 22: If dt.Rows.Count > 0 Then
|