or
<telerik:GridTemplateColumn UniqueName="statusCln" HeaderText="<%$ Resources: Activity, ActivityStatus %>" |
AutoPostBackOnFilter="true" DataField="ActivityStatus.Description"> |
<ItemTemplate> |
<asp:Label ID="lblStatus" runat="server" Text=""></asp:Label> |
<asp:Label Font-Size="0.9em" ForeColor="Red" ID="assignerLbl" runat="server" Text=""></asp:Label> |
</ItemTemplate> |
<FilterTemplate> |
<telerik:RadComboBox runat="server" ID="ComboForStatus" AutoPostBack="true" |
OnClientSelectedIndexChanged="StatusIndexChanged"> |
<Items> |
<telerik:RadComboBoxItem Text="<%$Resources:General,Select %>" Value="0" /> |
</Items> |
</telerik:RadComboBox> |
<telerik:RadScriptBlock ID="RadScriptBlock2" runat="server"> |
<script type="text/javascript"> |
function StatusIndexChanged(sender, args) { |
var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>"); |
tableView.filter("statusCln", args.get_item().get_text(), 1); |
} |
</script> |
</telerik:RadScriptBlock> |
</FilterTemplate> |
</telerik:GridTemplateColumn> |
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()