1. For the "add, delete, modify, and query" functions, the most commonly used is "query". When querying, pay attention to keep up with the parameter when you jump to the next page.
Request. querystring ["parameter"]. tostring () is the relationship between the table and the table. Sometimes some conditions are used, for example, where tabel1.meberid = @ tabel2.id, which means that the meberid in Table tabel1 is associated with the primary key in Table tabel2, then a composite query of the table is created, and the fields (data) in the two tables can be found at the same time through this condition ).
Other "Update, delete" operations are like this, so it is not so cumbersome to add! Insert data directly.
2. query new usage Example 1: Select "images/" + IMG from Table1
Read an image and select the path here.
Case2: "case isupload when 1 then 'upfileload/link/'+ imgpath else imgpath end as imgpath"
Here, the imgpath field is processed, that is, a character string 'upfileload/link/'is added to the front, which makes it easy to display another text link when reading the image and changes it, how is it? Is it practical?
