Hello,
I need help.
I'm try connect with MySQL, and not appear connection... can help me?
I install --> http://dev.mysql.com/downloads/file.php?id=407493
nugget package :
Install-Package MySql.Data
Install-Package MySQL.Data.Entities
Install-Package MySql.NET
and not work?
Anybody can help me?
I have a Checkbox in a gridtemplatecolumn. When checked I would like it to auto post back. Everything seems to work, however I cannot get the DataKeyValue.
<
telerik:RadGrid
ID
=
"rgd_OrdersNew"
runat
=
"server"
DataSourceID
=
"sds_ETP_OrdersShipped"
AllowSorting
=
"True"
Width
=
"800px"
>
<
MasterTableView
AutoGenerateColumns
=
"False"
DataSourceID
=
"sds_ETP_OrdersShipped"
DataKeyNames
=
"IDOrder, InvoiceNumber"
ClientDataKeyNames
=
"IDOrder, InvoiceNumber"
HeaderStyle-Wrap
=
"False"
HeaderStyle-HorizontalAlign
=
"Center"
>
<
Columns
>
<
telerik:GridTemplateColumn
DefaultInsertValue
=
""
HeaderText
=
" "
UniqueName
=
"TemplateColumn"
ItemStyle-HorizontalAlign
=
"Center"
ItemStyle-Width
=
"10px"
ItemStyle-CssClass
=
"radgrid_count"
FooterStyle-CssClass
=
"radgrid_count"
>
<
ItemTemplate
>
<%# Container.ItemIndex+1 %>
</
ItemTemplate
>
<
FooterStyle
CssClass
=
"radgrid_count"
></
FooterStyle
>
<
ItemStyle
HorizontalAlign
=
"Center"
CssClass
=
"radgrid_count"
Width
=
"10px"
></
ItemStyle
>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
DataField
=
"InvoiceNumber"
DataType
=
"System.Int32"
FilterControlAltText
=
"Filter InvoiceNumber column"
HeaderText
=
"Invoice"
SortExpression
=
"InvoiceNumber"
UniqueName
=
"InvoiceNumber"
ItemStyle-HorizontalAlign
=
"Center"
DataFormatString
=
"ETP-{0}"
ItemStyle-ForeColor
=
"#597791"
ItemStyle-Width
=
"60px"
ItemStyle-Wrap
=
"False"
>
<
ItemStyle
HorizontalAlign
=
"Center"
Wrap
=
"False"
ForeColor
=
"#597791"
Width
=
"60px"
>
</
ItemStyle
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"IDOrder"
DataType
=
"System.Int32"
FilterControlAltText
=
"Filter IDOrder column"
HeaderText
=
"Order ID"
SortExpression
=
"IDOrder"
UniqueName
=
"IDOrder"
ItemStyle-HorizontalAlign
=
"Center"
Visible
=
"True"
>
<
ItemStyle
HorizontalAlign
=
"Center"
></
ItemStyle
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"OrderStatus"
FilterControlAltText
=
"Filter OrderStatus column"
HeaderText
=
"Status"
ReadOnly
=
"True"
SortExpression
=
"OrderStatus"
UniqueName
=
"OrderStatus"
Visible
=
"False"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"TrackingCode"
FilterControlAltText
=
"Filter TrackingCode column"
HeaderText
=
"Tracking Code"
ReadOnly
=
"True"
SortExpression
=
"TrackingCode"
UniqueName
=
"TrackingCode"
Visible
=
"True"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"ShippingMethod"
FilterControlAltText
=
"Filter ShippingMethod column"
HeaderText
=
"Shipping"
ReadOnly
=
"True"
SortExpression
=
"ShippingMethod"
UniqueName
=
"ShippingMethod"
Visible
=
"True"
ItemStyle-Wrap
=
"False"
>
<
ItemStyle
Wrap
=
"False"
Width
=
"100px"
></
ItemStyle
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"IDCustomer"
DataType
=
"System.Int32"
FilterControlAltText
=
"Filter IDCustomer column"
HeaderText
=
"Customer ID"
SortExpression
=
"IDCustomer"
UniqueName
=
"IDCustomer"
ItemStyle-HorizontalAlign
=
"Center"
Visible
=
"False"
>
<
ItemStyle
HorizontalAlign
=
"Center"
></
ItemStyle
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"DateOrder"
DataType
=
"System.DateTime"
FilterControlAltText
=
"Filter DateOrder column"
HeaderText
=
"Order Date"
SortExpression
=
"DateOrder"
UniqueName
=
"DateOrder"
ItemStyle-HorizontalAlign
=
"Right"
>
<
ItemStyle
HorizontalAlign
=
"Right"
Wrap
=
"False"
></
ItemStyle
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"OrderLastName"
FilterControlAltText
=
"Filter OrderLastName column"
HeaderText
=
"Last Name"
SortExpression
=
"OrderLastName"
UniqueName
=
"OrderLastName"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"OrderFirstName"
FilterControlAltText
=
"Filter OrderFirstName column"
HeaderText
=
"First Name"
SortExpression
=
"OrderFirstName"
UniqueName
=
"OrderFirstName"
>
</
telerik:GridBoundColumn
>
<
telerik:GridHyperLinkColumn
DataNavigateUrlFields
=
"TrackingCode"
HeaderText
=
" "
DataNavigateUrlFormatString
=
"https://tools.usps.com/go/TrackConfirmAction_input?qtc_tLabels1=[{0}]"
Text
=
"Track"
UniqueName
=
"TrackingCode"
AllowFiltering
=
"False"
ItemStyle-HorizontalAlign
=
"Center"
Target
=
"BLANK"
>
<
ItemStyle
Width
=
"75px"
CssClass
=
"tbltdbutton"
/>
</
telerik:GridHyperLinkColumn
>
<
telerik:GridTemplateColumn
>
<
ItemTemplate
>
<
asp:CheckBox
ID
=
"cbx_Deliverd"
Checked='<%# Convert.ToBoolean(Eval("Delivered")) %>'
AutoPostBack="true" OnCheckedChanged="cbx_Deliverd_CheckedChanged" runat="server" />
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
</
Columns
>
</
MasterTableView
>
<
ClientSettings
EnablePostBackOnRowClick
=
"true"
AllowColumnsReorder
=
"true"
ReorderColumnsOnClient
=
"true"
EnableRowHoverStyle
=
"true"
>
<
Selecting
AllowRowSelect
=
"true"
/>
</
ClientSettings
>
</
telerik:RadGrid
>
Protected
Sub
cbx_Deliverd_CheckedChanged(sender
As
Object
, e
As
EventArgs)
Dim
cbx_Deliverd
As
CheckBox =
DirectCast
(sender, CheckBox)
Dim
item
As
GridDataItem =
DirectCast
(cbx_Deliverd.NamingContainer, GridDataItem)
Dim
Deliverd
As
CheckBox =
DirectCast
(cbx_Deliverd.FindControl(
"cbx_Deliverd"
), CheckBox)
Dim
IDOder
As
String
= item.GetDataKeyValue(
"IDOder"
).ToString()
If
Deliverd.Checked
Then
Dim
sql
As
String
Dim
strConnString
As
[
String
] = System.Configuration.ConfigurationManager.ConnectionStrings(
"ETP_OPS_ConnectionString"
).ConnectionString()
sql =
"UPDATE Orders_Shipping SET Delivered = @Delivered WHERE IDOder = @IDOder"
Dim
connection
As
New
SqlConnection(strConnString)
Dim
command
As
New
SqlCommand(sql, connection)
command.Parameters.Add(
"@IDOder"
, SqlDbType.Int).Value = IDOder
command.Parameters.Add(
"@Delivered"
, SqlDbType.Int).Value = 1
command.Connection.Open()
command.ExecuteNonQuery()
command.Connection.Close()
End
If
End
Sub
As always, any help much appreciated.
Hello,
I need help to finish process.
I have 10 pages that call process that generate pdfs, above.
Exemple:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="P1.aspx.cs" Inherits="P1" %>
<%@ Register Assembly="Telerik.ReportViewer.WebForms, Version=9.0.15.225, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" Namespace="Telerik.ReportViewer.WebForms" TagPrefix="telerik" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div align="center">
<telerik:ReportViewer ID="ReportViewer1" runat="server" Width="100%" Height="530px" ProgressText="Generate...">
<typereportsource typename="Project.Relatorios.Page1, Project.Relatorios, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"></typereportsource>
</telerik:ReportViewer>
</div>
</form>
</body>
</html>
public partial class Page1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ReportViewer1.ReportSource.Parameters.Add("Id", User.Session().Id);
}
}
}
I need generate this process programmatically for one diretory, to generate 10 pdfs this diretory,
and concatenet this 10 pdf in one pdf, and show this pdf in one click of button.
Anybody can help me?
I would like to set the raddatepicker calendar to today's date if the DbSelectedDate = "1/1/1900"
Here is my control ASPX
<
telerik:RadDatePicker
ID
=
"rdp_ShipDate"
runat
=
"server"
Culture
=
"English (United States)"
DbSelectedDate='<%#Bind("DateShipped")%>'
SkipMinMaxDateValidationOnServer="True" MinDate="1/1/1800 12:00:00 AM">
<
Calendar
ID
=
"Calendar1"
runat
=
"server"
UseColumnHeadersAsSelectors
=
"False"
UseRowHeadersAsSelectors
=
"False"
ViewSelectorText
=
"x"
>
<
SpecialDays
>
<
telerik:RadCalendarDay
Repeatable
=
"Today"
ItemStyle-BackColor
=
"Green"
>
</
telerik:RadCalendarDay
>
</
SpecialDays
>
</
Calendar
>
<
DatePopupButton
HoverImageUrl
=
""
ImageUrl
=
""
/>
</
telerik:RadDatePicker
>
Here is my attempted code behind
Protected
Sub
fvw_OrderDetails_DataBound(sender
As
Object
, e
As
System.EventArgs)
Handles
fvw_OrderDetails.DataBound
If
fvw_OrderDetails.CurrentMode = FormViewMode.Edit
Then
Dim
DateShipped
As
RadDatePicker =
DirectCast
(fvw_OrderDetails.FindControl(
"rdp_ShipDate"
), RadDatePicker)
If
DateShipped.DbSelectedDate =
"1/1/1900"
Then
CType
(fvw_OrderDetails.FindControl(
"rdp_ShipDate"
), RadDatePicker).Calendar.FocusedDate = DateTime.Now
End
If
End
If
End
Sub
Any help much appreciated.
<telerik:RadSplitter id="RadSplitter1" runat="server"> |
<telerik:RadPane id="MiddlePane" runat="server" Width="956" Scrolling="None"> |
<div class="vo_visite_apercu_conteneur"> |
<asp:Image ImageUrl="~/images/flecheGvisite.jpg" ID="flecheGvisite" CssClass="flecheGvisite" AlternateText="gauche" runat="server" /> |
<asp:Image ImageUrl="~/images/flecheDvisite.jpg" ID="flecheDvisite" CssClass="flecheDvisite" AlternateText="droite" runat="server" /> |
<div class="vo_visite_apercu_div_rotator"> |
<telerik:RadRotator ID="RadRotator1" runat="server" RotatorType="Buttons" Width="316px" Height="90px" ItemWidth="79" ItemHeight="75" ScrollDirection="Left" CssClass="vo_visite_apercu_rotator"> |
<ItemTemplate> |
<div class="vo_visite_apercu_item"> |
<div class="vo_visite_apercu_img"> |
<asp:Image ID="imgVeh" runat="server" Width="75" ToolTip="Cliquez pour accèder au détail" ImageUrl='<%# "~/images/" & Container.Dataitem("imgItem") & "-1small.jpg" %>' /> |
</div> |
<div align="center" class="vo_visite_apercu_chkBox"> |
<asp:CheckBox ID="chkVeh" runat="server" /> |
</div> |
</div> |
</ItemTemplate> |
<ControlButtons LeftButtonID="flecheGvisite" RightButtonID="flecheDvisite" /> |
</telerik:RadRotator> |
</div> |
</div> |
</telerik:RadPane> |
</telerik:RadSplitter> |
<
rad:RadGrid
ID
=
"qualRadGrid"
runat
=
"server"
AllowAutomaticDeletes
=
"false"
AllowAutomaticInserts
=
"false"
AllowAutomaticUpdates
=
"false"
AllowPaging
=
"True"
OnInsertCommand
=
"qualRadGrid_InsertCommand"
OnDeleteCommand
=
"CategoryGrid_DeleteCommand"
OnUpdateCommand
=
"qualRadGrid_UpdateCommand"
AllowSorting
=
"True"
AutoGenerateColumns
=
"False"
DataSourceID
=
"ProgrammeDs"
EnableAJAX
=
"False"
GridLines
=
"None"
RadControlsDir
=
"~/Resources/RadControls/"
Skin
=
"Web20"
SkinsPath
=
"~/Resources/RadControls/Grid/Skins"
Width
=
"750px"
>
<
MasterTableView
AllowMultiColumnSorting
=
"True"
DataKeyNames
=
"ProgId"
DataSourceID
=
"ProgrammeDs"
CommandItemDisplay
=
"Top"
Name
=
"Programme"
>
<
DetailTables
>
<
rad:GridTableView
runat
=
"server"
CommandItemDisplay
=
"Top"
DataKeyNames
=
"QualId"
DataSourceID
=
"QualificationDs"
Name
=
"Qualification"
AllowMultiColumnSorting
=
"True"
AllowAutomaticDeletes
=
"false"
AllowAutomaticInserts
=
"false"
AllowAutomaticUpdates
=
"false"
>
<
ParentTableRelation
>
<
rad:GridRelationFields
DetailKeyField
=
"ProgrammeId"
MasterKeyField
=
"ProgId"
/>
</
ParentTableRelation
>
<
RowIndicatorColumn
>
<
HeaderStyle
Width
=
"20px"
/>
</
RowIndicatorColumn
>
<
ExpandCollapseColumn
>
<
HeaderStyle
Width
=
"20px"
/>
</
ExpandCollapseColumn
>
<
Columns
>
<
rad:GridEditCommandColumn
ButtonType
=
"ImageButton"
EditImageUrl
=
"~/Resources/Buttons/EditButton.jpg"
>
</
rad:GridEditCommandColumn
>
<
rad:GridBoundColumn
DataField
=
"QualId"
HeaderButtonType
=
"TextButton"
HeaderText
=
"Qual Id"
SortExpression
=
"QualId"
UniqueName
=
"QualId"
Visible
=
"false"
>
</
rad:GridBoundColumn
>
<
rad:GridBoundColumn
DataField
=
"QualDescription"
HeaderButtonType
=
"TextButton"
HeaderText
=
"Short Description"
UniqueName
=
"ShortDesc"
>
</
rad:GridBoundColumn
>
</
Columns
>
<
EditFormSettings
EditFormType
=
"Template"
>
<
FormTemplate
>
<
table
id
=
"editableTables-1"
>
<
tr
>
<
td
>
<
asp:Label
ID
=
"Label1"
runat
=
"server"
>Short Description:</
asp:Label
>
</
td
>
<
td
>
<
asp:TextBox
ID
=
"ShortTextBox"
Text='<%# Eval("QualDescription") %>' Width="155px"
runat="server" TextMode="MultiLine" Height="30">
</
asp:TextBox
>
<
asp:RequiredFieldValidator
ValidationGroup
=
"validD"
id
=
"ReqSponsorTextBox"
runat
=
"server"
ErrorMessage
=
"*"
ControlToValidate
=
"ShortTextBox"
></
asp:RequiredFieldValidator
>
</
td
>
</
tr
>
<
tr
>
<
td
>
<
asp:CheckBox
ID
=
"requiresSubjects"
runat
=
"server"
Text
=
"Requires Subjects:"
AutoPostBack
=
"true"
OnCheckedChanged
=
"FindTextBox_OnIndexChanged"
/>
</
td
>
<
td
>
<
telerik:RadComboBox
ID
=
"subjectsCombo"
EnableLoadOnDemand
=
"true"
AutoPostBack
=
"true"
MarkFirstMatch
=
"true"
OnItemsRequested
=
"OnItemsRequested_getSubjects"
runat
=
"server"
RadControlsDir
=
"~/Resources/RadControls/Combobox/Skins"
Width
=
"155px"
Skin
=
"WebBlue"
SkinsPath
=
"~/Resources/RadControls/Combobox/Skins/"
>
</
telerik:RadComboBox
>
</
td
>
</
tr
>
<
tr
>
<
td
>
<
asp:ImageButton
ID
=
"LinkInsert"
ValidationGroup
=
"validD"
Text='<%# (Container is Telerik.WebControls.GridEditFormInsertItem) ? "Insert" : "Update" %>'
ImageUrl="~/Resources/Buttons/SaveButton.jpg" runat="server" CommandName='<%# (Container is Telerik.WebControls.GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'
Visible='<%# (Container is Telerik.WebControls.GridEditFormInsertItem) ? true : false %>' />
<
asp:ImageButton
ID
=
"LinkButton1"
Text='<%# (Container is Telerik.WebControls.GridEditFormInsertItem) ? "Insert" : "Update" %>'
ImageUrl="~/Resources/Buttons/SaveButton.jpg" runat="server" CommandName='<%# (Container is Telerik.WebControls.GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'
Visible='<%# (Container is Telerik.WebControls.GridEditFormInsertItem) ? false : true %>' />
<
asp:ImageButton
ID
=
"LinkButtonCancel"
ImageUrl
=
"~/Resources/Buttons/CancelButton.jpg"
runat
=
"server"
Text
=
"Cancel"
CausesValidation
=
"false"
CommandName
=
"Cancel"
/>
</
td
>
</
tr
>
<
td
>
<
tr
>
<
td
>
<
asp:TextBox
ID
=
"IDTextBox"
Text='<%# Eval("QualId") %>' runat="server" Visible="false">
</
asp:TextBox
>
</
td
>
</
tr
>
</
table
>
</
FormTemplate
>
<
EditColumn
UniqueName
=
"EditCommandColumn1"
>
</
EditColumn
>
</
EditFormSettings
>
</
rad:GridTableView
>
</
DetailTables
>
<
RowIndicatorColumn
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
>
</
RowIndicatorColumn
>
<
ExpandCollapseColumn
Visible
=
"True"
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
>
</
ExpandCollapseColumn
>
<
Columns
>
<%--<
rad:GridEditCommandColumn
ButtonType
=
"ImageButton"
EditImageUrl
=
"~/Resources/Buttons/EditButton.jpg"
>
</
rad:GridEditCommandColumn
>--%>
<
rad:GridBoundColumn
DataField
=
"ProgId"
HeaderText
=
"Programme ID"
SortExpression
=
"ProgId"
UniqueName
=
"ProgId"
Visible
=
"false"
>
</
rad:GridBoundColumn
>
<
rad:GridBoundColumn
DataField
=
"ProgCode"
HeaderText
=
"Programme Code"
SortExpression
=
"ProgCode"
ConvertEmptyStringToNull
=
"false"
UniqueName
=
"ProgCode"
>
</
rad:GridBoundColumn
>
<
rad:GridBoundColumn
DataField
=
"ProgrammeName"
HeaderText
=
"Programme Name"
SortExpression
=
"ProgrammeName"
ConvertEmptyStringToNull
=
"false"
UniqueName
=
"ProgrammeName"
>
</
rad:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
</
rad:RadGrid
>
We want to allow our users to configure a RadHtmlChart piechart a bit and save those settings, and when they return to that aspx page, the chart will load with those settings.
Is there a method to save their settings?
For example, the user only wants to see 5 of the 10 legend items by default.
But we still want to allow them to re-enable the none displayed legend items.. and etc...
So the user loads the page. The pie chart has 10 slices and thus 10 items in the legend.
The user clicks on several of the legend items so they are not displayed in the pie chart.
We want to save this configuration for them in the database.
When they revisit the page a few days later, it remembers their view settings for hte chart and displays it.
Then for example they then decide to show two of the excluded legend items by clicking on them again.
They legends that were once excluded are now included.
Etc..etc...