or
"Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
02 |
<asp:ScriptManager ID="ScriptManager1" runat="server"> </asp:ScriptManager> |
03 |
|
04 |
..... |
05 |
|
06 |
..... |
07 |
|
08 |
<asp:UpdatePanel ID="UpdatePanel1" runat="server"> |
09 |
<ContentTemplate> |
10 |
<asp:UpdateProgress runat="server" ID="UpdateProgress1" DynamicLayout="false" AssociatedUpdatePanelID="UpdatePanel1"> |
11 |
<ProgressTemplate> |
12 |
<img id="Img1" runat="Server" src="~/images/cartoon.gif" height="50" alt=""/> |
13 |
</ProgressTemplate> |
14 |
</asp:UpdateProgress> |
15 |
<asp:ImageButton ID="btn_save_preferences" runat="server" Text="Save Preferences" ImageUrl="images/btn_original_savepreferences.png" onclick="save_preferences" /> |
16 |
</ContentTemplate> |
17 |
</asp:UpdatePanel> |
18 |
|
19 |
... |
20 |
|
21 |
... |
22 |
|
23 |
|
24 |
</asp:Content> |
| Protected Sub RadGrid_Suchresultate_NeedDataSource(ByVal source As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles RadGrid_Suchresultate.NeedDataSource |
| '=== Radgrid "Suchresultate" ============================================================== |
| Dim conn As New SqlConnection |
| conn.ConnectionString = ConfigurationManager.ConnectionStrings("BwaConnectionString").ConnectionString |
| Dim cmd_Suchresultate As New SqlCommand |
| cmd_Suchresultate.CommandType = CommandType.Text |
| cmd_Suchresultate.Connection = conn |
| Dim cmd_Kategorien As New SqlCommand |
| cmd_Kategorien.CommandType = CommandType.Text |
| cmd_Kategorien.Connection = conn |
| If Request.QueryString("Suche") <> "" Then |
| cmd_Suchresultate.CommandText = "SELECT [ArtikelID], [Artikelnummer], [Bezeichnung], [Preis], [Text], [Bild], [WarengruppeID], [Einheit] FROM [Artikel]" |
| cmd_Kategorien.CommandText = "SELECT DISTINCT W.Warengruppe, W.WarengruppeID FROM Artikel As A INNER JOIN Warengruppe As W ON A.WarengruppeID = W.WarengruppeID" |
| '--- Querystring "Suche" in String speichern ---------------------------------------------- |
| Dim str_Suche As String = Request.QueryString("Suche") |
| '--- Suchbegriff(e) in Array speichern ---------------------------------------------------- |
| Dim str_Suchbegriffe As String() = Split(str_Suche, " ") |
| Dim str_Operator As String = " WHERE " |
| For Each str_Suchbegriff As String In str_Suchbegriffe |
| cmd_Suchresultate.CommandText &= str_Operator & " " & "([Artikelnummer] LIKE '%' + @Artikelnummer" & str_Suchbegriff & " + '%' OR [Bezeichnung] LIKE '%' + @Bezeichnung" & str_Suchbegriff & " + '%' OR [Text] LIKE '%' + @Text" & str_Suchbegriff & " + '%')" |
| cmd_Kategorien.CommandText &= str_Operator & " " & "([Artikelnummer] LIKE '%' + @Artikelnummer" & str_Suchbegriff & " + '%' OR [Bezeichnung] LIKE '%' + @Bezeichnung" & str_Suchbegriff & " + '%' OR [Text] LIKE '%' + @Text" & str_Suchbegriff & " + '%')" |
| str_Operator = " AND " |
| '--- SqlParameter definieren -------------------------------------------------------------- |
| 'In der For - Each Schleife wird das Array "Suchbegriffe" durchlaufen und die einzelnen Suchbegriffe der Variablen "Suchbegriff" zugewiesen |
| 'An den Namen des Parameters wir der Suchbegriff angehängt, damit jeder Paramer einen anderen Namen erhält (sonst Fehler, Parameternamen müssen eindeutig sein) |
| With cmd_Suchresultate.Parameters |
| .Add(New SqlParameter("@Artikelnummer" & str_Suchbegriff, str_Suchbegriff)) |
| .Add(New SqlParameter("@Bezeichnung" & str_Suchbegriff, str_Suchbegriff)) |
| .Add(New SqlParameter("@Text" & str_Suchbegriff, str_Suchbegriff)) |
| End With |
| With cmd_Kategorien.Parameters |
| .Add(New SqlParameter("@Artikelnummer" & str_Suchbegriff, str_Suchbegriff)) |
| .Add(New SqlParameter("@Bezeichnung" & str_Suchbegriff, str_Suchbegriff)) |
| .Add(New SqlParameter("@Text" & str_Suchbegriff, str_Suchbegriff)) |
| End With |
| '--- SqlParameter definieren E N D E ------------------------------------------------------ |
| Next |
| Page.Title = "Ihre Suchergebnisse für den Suchbegriff " & str_Suche 'TODO: Title besser machen |
| ElseIf Request.QueryString("Kategorie") <> "" Then |
| '--- Querystring "Kategorie" in String speichern ------------------------------------------ |
| Dim str_Kategorie As String = Request.QueryString("Kategorie") |
| cmd_Suchresultate.CommandText = "SELECT [ArtikelID], [Artikelnummer], [Bezeichnung], [Preis], [Text], [Bild], [WarengruppeID], [Einheit] FROM [Artikel] WHERE WarengruppeID = @WarengruppeID" |
| '--- SqlParameter definieren -------------------------------------------------------------- |
| With cmd_Suchresultate.Parameters |
| .Add(New SqlParameter("@WarengruppeID", str_Kategorie)) |
| End With |
| '--- SqlParameter definieren E N D E ------------------------------------------------------ |
| Page.Title = "Ihre gewünschte Kategorie " & str_Kategorie |
| Else |
| 'Seite direkt aufgerufen |
| Response.Redirect("~/default.aspx") |
| End If |
| Dim dt_Suchresultate As New DataTable |
| Using conn |
| conn.Open() |
| Dim dr_Suchresultate As SqlDataReader = cmd_Suchresultate.ExecuteReader() |
| dt_Suchresultate.Load(dr_Suchresultate) |
| RadGrid_Suchresultate.DataSource = dt_Suchresultate |
| Dim dr_Kategorien As SqlDataReader = cmd_Kategorien.ExecuteReader() |
| drp_Kategorien.DataSource = dr_Kategorien |
| drp_Kategorien.DataValueField = "WarengruppeID" |
| drp_Kategorien.DataTextField = "Warengruppe" |
| drp_Kategorien.DataBind() |
| End Using |
| '=== Radgrid "Suchresultate" E N D E ====================================================== |
| End Sub |
I'm using RadMenu like the "mega drop down" sample.
In IE, moving the mouse over the text of the first level menu fires the menu drop down, which is perfect. However, on Firefox and other browsers, the drop down fires only when moving the mouse over the bottom of the links.
I'm attaching a gif to explain it better.
How can I correct this, please ?
| protected void rgViews_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e) |
| { |
| if (e.Item is Telerik.Web.UI.GridDataItem) |
| { |
| string fulltext = e.Item.Cells[3].Text; |
| if (e.Item.Cells[3].Text.Length >= 70) |
| { |
| e.Item.Cells[3].Text = e.Item.Cells[3].Text.Substring(0, 70) + " ..."; |
| e.Item.Cells[3].ToolTip = fulltext.Replace("\r\n", " ").Replace("\t", ""); |
| } |
| } |
| } |

|
Requirements |
|
| RadControls version |
2009.2 826 |
| .NET version |
3.5 |
| Visual Studio version |
2008 |
| programming language |
VB.net |
| browser support |
all browsers supported by RadControls |
| <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %> |
| <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> |
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| <html xmlns="http://www.w3.org/1999/xhtml"> |
| <head runat="server"> |
| <title></title> |
| </head> |
| <body> |
| <form id="form1" runat="server"> |
| <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> |
| </telerik:RadScriptManager> |
| <div> |
| <telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" GridLines="None" |
| AllowAutomaticDeletes="true" AllowAutomaticInserts="true" AllowAutomaticUpdates="true"> |
| <MasterTableView DataKeyNames="ID" DataSourceID="SqlDataSource1" CommandItemDisplay="Top"> |
| <RowIndicatorColumn> |
| <HeaderStyle Width="20px"></HeaderStyle> |
| </RowIndicatorColumn> |
| <ExpandCollapseColumn> |
| <HeaderStyle Width="20px"></HeaderStyle> |
| </ExpandCollapseColumn> |
| <Columns> |
| <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn" HeaderStyle-Width="32px"> |
| <HeaderStyle Width="32px"></HeaderStyle> |
| <ItemStyle HorizontalAlign="Center" /> |
| </telerik:GridEditCommandColumn> |
| <telerik:GridBoundColumn DataField="ID" DataType="System.Int32" HeaderText="ID" |
| ReadOnly="True" SortExpression="ID" UniqueName="ID"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="Name" HeaderText="Name" |
| SortExpression="Name" UniqueName="Name"> |
| </telerik:GridBoundColumn> |
| <telerik:GridTemplateColumn UniqueName="Color" HeaderText="Color" DataField="myColor" |
| SortExpression="myColor" AllowFiltering="false" HeaderStyle-Width="32px"> |
| <ItemTemplate> |
| <div style='width: 16px; height: 16px; background-color: <%# Eval("myColor") %>'></div> |
| </ItemTemplate> |
| <EditItemTemplate> |
| <telerik:RadColorPicker runat="server" ShowIcon="true" ID="RadColorPicker1" SelectedColor='<%# HTML2Color(myCStr(Eval("myColor"))) %>' /> |
| </EditItemTemplate> |
| </telerik:GridTemplateColumn> |
| <telerik:GridButtonColumn ConfirmText="Delete this product?" ConfirmDialogType="RadWindow" |
| ConfirmTitle="Delete" ButtonType="ImageButton" CommandName="Delete" Text="Delete" |
| UniqueName="DeleteColumn" HeaderStyle-Width="32px"> |
| <HeaderStyle Width="32px"></HeaderStyle> |
| <ItemStyle HorizontalAlign="Center" /> |
| </telerik:GridButtonColumn> |
| </Columns> |
| </MasterTableView> |
| </telerik:RadGrid> |
| </div> |
| <asp:SqlDataSource ID="SqlDataSource1" runat="server" |
| ConnectionString="<%$ ConnectionStrings:CS_ColorPickingInsideGrid %>" |
| DeleteCommand="DELETE FROM [Products] WHERE [ID] = @ID" |
| InsertCommand="INSERT INTO [Products] ([Name], [myColor]) VALUES (@Name, @myColor)" |
| SelectCommand="SELECT [ID], [Name], [myColor] FROM [Products]" |
| UpdateCommand="UPDATE [Products] SET [Name] = @Name, [myColor] = @myColor WHERE [ID] = @ID"> |
| <DeleteParameters> |
| <asp:Parameter Name="ID" Type="Int32" /> |
| </DeleteParameters> |
| <UpdateParameters> |
| <asp:Parameter Name="Name" Type="String" /> |
| <asp:Parameter Name="myColor" Type="String" /> |
| <asp:Parameter Name="ID" Type="Int32" /> |
| </UpdateParameters> |
| <InsertParameters> |
| <asp:Parameter Name="Name" Type="String" /> |
| <asp:Parameter Name="myColor" Type="String" /> |
| </InsertParameters> |
| </asp:SqlDataSource> |
| </form> |
| </body> |
| </html> |
| Imports Telerik.Web.UI |
| Imports System.Data |
| Imports System.Drawing |
| Partial Class _Default |
| Inherits System.Web.UI.Page |
| Function HTML2Color(ByVal hex As String) As Color |
| Return ColorTranslator.FromHtml(hex) |
| End Function |
| Function myCStr(ByVal dbstring As Object) As String |
| If IsDBNull(dbstring) Then |
| Return ("#ffffff") |
| Else |
| Return CStr(dbstring) |
| End If |
| End Function |
| Protected Sub RadGrid1_ItemCommand(ByVal source As Object, ByVal e As GridCommandEventArgs) Handles RadGrid1.ItemCommand |
| Select Case e.CommandName |
| Case RadGrid.UpdateCommandName |
| Dim editedItem As GridEditableItem = CType(e.Item, GridEditableItem) |
| SqlDataSource1.UpdateParameters("myColor").DefaultValue = ColorTranslator.ToHtml(CType(editedItem.FindControl("RadColorPicker1"), RadColorPicker).SelectedColor) |
| Case RadGrid.PerformInsertCommandName |
| Dim insertItem As GridEditableItem = CType(e.Item, GridEditableItem) |
| SqlDataSource1.InsertParameters("myColor").DefaultValue = ColorTranslator.ToHtml(CType(insertItem.FindControl("RadColorPicker1"), RadColorPicker).SelectedColor) |
| End Select |
| End Sub |
| End Class |
| Protected Sub RadToolBar1_ButtonClick(ByVal sender As Object, ByVal e As Telerik.Web.UI.RadToolBarEventArgs) Handles RadToolBar1.ButtonClick |
| If TypeOf e.Item Is RadToolBarButton Then |
| Dim button As RadToolBarButton = TryCast(e.Item, RadToolBarButton) |
| If button.CommandName = "FullList" Then |
| For Each column As GridColumn In RadGrid1.MasterTableView.Columns |
| column.CurrentFilterFunction = GridKnownFunction.NoFilter |
| column.CurrentFilterValue = String.Empty |
| Next |
| RadGrid1.MasterTableView.FilterExpression = String.Empty |
| RadGrid1.MasterTableView.Rebind() |
| ElseIf button.CommandName = "ExportToPdf" Then |
| RadGrid1.MasterTableView.ExportToPdf() |
| End If |
| End If |
| End Sub |
| <telerik:RadToolBar runat="server" ID="RadToolBar1" OnButtonClick="RadToolBar1_ButtonClick" onclientButtonClicking="radToolBarClientClicked"> |
| <Items> |
| <telerik:RadToolBarButton Text="Full List" CommandName="FullList" ImageUrl="~/Images/AwardsGrid/Table.gif"></telerik:RadToolBarButton> |
| <telerik:RadToolBarButton Text="Print" CommandName="Print" ImageUrl="~/Images/AwardsGrid/Printer.gif"></telerik:RadToolBarButton> |
| <telerik:RadToolBarButton Text="Export to Pdf" CommandName="ExportToPdf" ImageUrl="~/Images/AwardsGrid/Printer.gif"></telerik:RadToolBarButton> |
| </Items> |
| </telerik:RadToolBar> |
| <telerik:RadGrid ID="RadGrid1" runat="server" ShowStatusBar="true" GridLines="Both" CssClass="RadGridCustomClass" AllowFilteringByColumn="true" OnItemCommand="RadGrid1_ItemCommand" > |
| <!-- my RadGrid contents --> |
| </telerik:RadGrid> |
| <asp:LinkButton ID="LinkButton3" runat="server" type="button" Text="[ Export to Pdf ]" |
| OnClick="LinkButton3_ButtonClick" Font-Underline="false" ForeColor="Black" /> |
| Protected Sub LinkButton3_ButtonClick(ByVal sender As Object, ByVal e As EventArgs) Handles LinkButton3.Click |
| RadGrid1.MasterTableView.ExportToPdf() |
| End Sub |
| function RefreshGrid() { |
| var masterTable = $find("<%= RadGrid1.ClientID %>").get_masterTableView(); |
| masterTable.filter("AwardID", "", Telerik.Web.UI.GridFilterFunction.StartsWith, true); |
| masterTable.filter("AwardName", "", Telerik.Web.UI.GridFilterFunction.StartsWith, true); |
| } |
| <form id="form1" runat="server"> |
| <div> |
| <telerik:RadScriptManager ID="radScriptManager" runat="server" /> |
| <telerik:RadGrid ID="radGrid" AutoGenerateColumns="false" AllowSorting="true" OnNeedDataSource="radGrid_NeedDataSource" runat="server"> |
| <ClientSettings> |
| <Scrolling UseStaticHeaders="true" /> |
| </ClientSettings> |
| <MasterTableView AllowMultiColumnSorting="true" CommandItemDisplay="Top" CommandItemSettings-AddNewRecordText="Add new founder" CommandItemSettings-ShowRefreshButton="false" EditMode="InPlace" TableLayout="Fixed"> |
| <Columns> |
| <telerik:GridBoundColumn DataField="Name" DataType="System.String" HeaderText="Name" HeaderStyle-HorizontalAlign="Left" ItemStyle-HorizontalAlign="Left" SortExpression="Name" AllowSorting="true" UniqueName="Name" /> |
| <telerik:GridBoundColumn DataField="Founder" DataType="System.String" HeaderText="Founder" HeaderStyle-HorizontalAlign="Left" ItemStyle-HorizontalAlign="Left" SortExpression="Founder" AllowSorting="true" UniqueName="Founder" /> |
| <telerik:GridEditCommandColumn ButtonType="ImageButton" HeaderStyle-Width="5%" UniqueName="Edit" /> |
| <telerik:GridButtonColumn ButtonType="ImageButton" ConfirmDialogType="RadWindow" HeaderStyle-Width="5%" ConfirmText="Delete this founder?" ConfirmTitle="Delete" CommandName="Delete" /> |
| </Columns> |
| </MasterTableView> |
| </telerik:RadGrid> |
| </div> |
| </form> |