or
Dim oConn As OdbcConnection<br>
Dim connectionString As String<br>
connectionString = ConfigurationManager.ConnectionStrings("ODBCConnection").ToString<br>
oConn = New OdbcConnection(connectionString)<br>
commandString = "SELECT sCode as Κωδικός, sName as Περιγραφή,sUnitOM as ΜΜ,sWhsalePr as Λιανική From smast where sCode like '" + TextBox1.Text + "%' or sSuplCode like '" + TextBox1.Text + "%' order by scode"<br>
Dim myAdapter As New OdbcDataAdapter(commandString, oConn)<br>
Dim productDataSet As DataSet = New DataSet<br>
myAdapter.Fill(productDataSet)<br>
RadGrid1.DataSource = productDataSet<br>
RadGrid1.DataBind()
.RadPanelBar ul.rpGroup { list-style-type:circle !important;}<telerik:RadComboBox ID="Address_LocationRadComboBox" runat="server" SelectedValue='<%# Bind("Address_Location") %>' Text='<%# Bind("Address_Location") %>' Width="150px"> <Items> <telerik:RadComboBoxItem runat="server" Text="Florida" Value="Florida" /> <telerik:RadComboBoxItem runat="server" Text="New Jersey" Value="New Jersey" /> <telerik:RadComboBoxItem runat="server" Text="New York" Value="New York" /> <telerik:RadComboBoxItem runat="server" Text="Ohio" Value="Ohio" /> <telerik:RadComboBoxItem runat="server" Text="Wisconsin" Value="Wisconsin" /> </Items></telerik:RadComboBox>.........protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e) { string[] retrievedLocations = (string[])Session["LocationData"]; Array.Sort(retrievedLocations); // Assuming Array retrievedLocations has following Values: // New Jersey // New York // Wisconsin if (e.Item is GridEditableItem && e.Item.IsInEditMode) { GridEditableItem item = (GridEditableItem)e.Item; // Beginning of Loop each row in array retrievedLocations until no rows in array RadComboBox combo = (RadComboBox)item.FindControl("Address_LocationRadComboBox"); foreach (RadComboBoxItem ComboItem in combo.Items) { if (ComboItem.Value != row value of array retrievedLocations) { ComboItem.Visible = false; } else { ComboItem.Visible = true; } } // End of Loop each row in array retrievedLocations until no rows in array } }