I am finishing up the development of a web site in ASP.NET with VB.NET and MS SQL Server 2005 on MS Visual Web Developer. I have a query which pulls the record for a specified product from the table, returning the description field (varchar(6000)). On my web page, I want to display just the first 100 characters of the description, followed by an elipse (...). I'm out of time on this project so would like some help, please.
Dim myConn2 As New SqlConnection(ConfigurationManager.ConnectionStrings("omahavaccineConnectionString").ToString)
myCmd2.Connection = myConn2
myCmd2.CommandType = CommandType.Text
myCmd2.CommandText = "Select * from Product where sku='" & strSKU & "' "
Dim myReader2 As SqlDataReader = myCmd2.ExecuteReader()
Do While myReader2.Read
lblshort_description = (TRIM(myReader2("description")),100) & " ..."