First code post to my new .net site!
this is basicly the same post as i posted to my other site, but now here. so, as a CC of the post, here is pretty much everything i posted before! Enjoy! Ohhh, and if someone knows a really easy of posting code to a blog, like converting from VB.NET code to HTML quickly, please post a comment! Thanks.
Ok. the following code is something i use a fair amount. There would be something in a table with information in it like the following:
45,43,56,77,22,33
This would repesent, lets say as an example, an order for a user. so the user would have bought them products in a single purchase. To get the information about the products, i send that string into a function that splits it and returns a SQL statement. Now, the following code includes a button for testing it. If you see any better ways of doing this, please post a reply!
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
MsgBox(test(";1;2;3;4;5;"))
End Sub
Private Function test(ByVal list As String) As String
Dim sql As String
sql = "select * from products where productid = "
Dim seperator As String = ""
Dim x As Array
Dim i As Integer
x = Split(list, ";")
For i = 0 To x.Length - 1
If x(i) <> "" Then
sql += seperator & x(i)
seperator = " or productid = "
End If
Next
Return sql
End Function