[RESOLVED] How to fill in my gridview

[shyguyjeff]

Hello everyone, I have here a code but my problem is that how can i add the value of the result in my gridview. Actually when I put msgbox to the "myString" it result 3 by 3 and that's what i want but the problem is that how can i call all of those strings to display on one column of gridview and each value from my database is beside them? Could anyone help me this? This is my code:

  

Dim CSCode As String = = "123456789"

Dim myString As String 
                     
 For z As Integer = 0 To CSCode.Length - 1 Step 3

                myString = CSCode.Substring(z, 3)
                


                Dim objConn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("database\myData.mdb") & ";")

                Dim strSQL As String
                strSQL = "SELECT Classification FROM Classification WHERE ClassCode LIKE '" & myString & "'"


              
                Dim objCmd As New OleDbCommand(strSQL, objConn)
                Dim objDA As New OleDbDataAdapter()
                objDA.SelectCommand = objCmd

                objConn.Open()



                Dim objDS As DataSet = New DataSet()
                objDA.Fill(objDS, "Classification")


                ClassGrid.DataSource = objDS

                ClassGrid.DataBind()


                objConn.Close()

            Next

Thanks in advance.

[danasegarane]

What is the data column type of ClassCode ?

[shyguyjeff]

Integer...I just want to fill in like this and the data has specified value on the database. This is what I want as a result on my datagrid.

123     Steel
456     Pipes
789     Metal

I want also to get that in vice versa, like for example

jeff   123789
james  456789
john   456

So if somebody search "456" it will display like this:

james 
john

and if "789" it will result to

jeff 
james

Thanks and have a nice day.

[danasegarane]

im CSCode As String = = "123456789"
 
                
 
 
                Dim objConn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("database\myData.mdb") & ";")
 
                Dim strSQL As String
                strSQL = "SELECT Classification FROM Classification WHERE ClassCode LIKE '%" & CSCode & "%'"
 
 
              
                Dim objCmd As New OleDbCommand(strSQL, objConn)
                Dim objDA As New OleDbDataAdapter()
                objDA.SelectCommand = objCmd
 
                objConn.Open()
 
 
 
                Dim objDS As DataSet = New DataSet()
                objDA.Fill(objDS, "Classification")
 
 
                ClassGrid.DataSource = objDS
 
                ClassGrid.DataBind()
 
 
                objConn.Close()

[shyguyjeff]

not that one..The string was arranged orderly and get each value of it. It was split 3 by 3 every 3 character there is a specific value in my table.

[shyguyjeff]

I solved it..What i made is that

I split the string and get 3 separate values from it, and I create a comma-separated string with those values.

For z As Integer = 0 To CSCode.Length - 1 Step 3
     myString &= "'" & CSCode.Substring(z, 3) & "'"
     If z < CSCode.Length - 4 Then myString &= ","
Next

Then I use the IN operator in your SQL:

SELECT Classification FROM Classification WHERE ClassCode IN(" & myString & ")


Thanks for the effort everyone. Have a nice day and God Bless..