This question is locked. New answers and comments are not allowed.
Hi, I am usingTelerik data access for the first time. Initially I used it with radgrid and it worked fine.
Now , I have a web form with 10 textboxes getting data from open access query, I am not sure how to bind that data. I need something like datareader to bind data from the query.Based on the value selected from customer dropdown, my textboxes value should change. please guide me on this, Thanks.
Now , I have a web form with 10 textboxes getting data from open access query, I am not sure how to bind that data. I need something like datareader to bind data from the query.Based on the value selected from customer dropdown, my textboxes value should change. please guide me on this, Thanks.
<
telerik:OpenAccessLinqDataSource
ID
=
"OALDCustData"
Runat
=
"server"
ContextTypeName
=
"AthenaModel.EntitiesModel"
EnableInsert
=
"True"
EnableUpdate
=
"True"
EntityTypeName
=
""
ResourceSetName
=
"CUSTOMERs"
Where
=
"CUSTOMER_ID == @CUSTOMER_ID"
>
<
WhereParameters
>
<
asp:ControlParameter
ControlID
=
"uxRcbCustomer"
DefaultValue
=
"0"
Name
=
"CUSTOMER_ID"
PropertyName
=
"SelectedValue"
Type
=
"Int64"
/>
</
WhereParameters
>
</
telerik:OpenAccessLinqDataSource
>
<
telerik:RadAjaxManager
ID
=
"RadAjaxManager1"
runat
=
"server"
>
</
telerik:RadAjaxManager
>
<
telerik:RadScriptManager
ID
=
"RadScriptManager1"
runat
=
"server"
/>
<
telerik:RadSkinManager
ID
=
"RadSkinManager1"
Runat
=
"server"
Skin
=
"Web20"
>
</
telerik:RadSkinManager
>
<
div
id
=
"editform"
>
<
telerik:RadAjaxPanel
ID
=
"RadAjaxPanel1"
runat
=
"server"
>
<
asp:HiddenField
ID
=
"hiddenIsDirty"
runat
=
"server"
/>
<
table
>
<
tr
>
<
td
class
=
"labelcol"
>
<
asp:Label
ID
=
"lblEditCustomer"
Font-Bold
=
"true"
ForeColor
=
"navy"
runat
=
"server"
Text
=
"Go To Customer"
></
asp:Label
></
td
>
<
td
style
=
"width: 362px"
>
<
telerik:RadComboBox
ID
=
"uxRcbCustomer"
runat
=
"server"
Width
=
"500px"
AutoPostBack
=
"True"
DataValueField
=
"Key"
DataTextField
=
"Value"
MaxHeight
=
"600px"
EmptyMessage
=
"Select a Customer"
EnableLoadOnDemand
=
"True"
ShowMoreResultsBox
=
"true"
EnableVirtualScrolling
=
"true"
OnItemsRequested
=
"rcbCustomer_ItemsRequested"
>
</
telerik:RadComboBox
>
</
td
>
</
tr
>
<
tr
>
<
td
class
=
"labelcol"
>
Customer Name:
</
td
>
<
td
style
=
"width: 362px"
>
<
telerik:RadTextBox
ID
=
"txtName"
runat
=
"server"
MaxLength
=
"50"
Width
=
"336px"
>
</
telerik:RadTextBox
>
<
asp:RequiredFieldValidator
ID
=
"NameRequiredValidator"
runat
=
"server"
ErrorMessage
=
"Customer Name is required."
Text
=
"*"
ControlToValidate
=
"txtName"
></
asp:RequiredFieldValidator
>
</
td
>
</
tr
>
<
tr
>
<
td
class
=
"labelcol"
>
Wellness Type:</
td
>
<
td
style
=
"width: 362px"
>
<
telerik:RadComboBox
ID
=
"cboWellnessType"
CausesValidation
=
"true"
runat
=
"server"
Width
=
"336px"
OnClientSelectedIndexChanged
=
"onValueChanged"
AutoPostBack
=
"true"
>
</
telerik:RadComboBox
>
<
asp:RequiredFieldValidator
ID
=
"WellnessTypeRequired"
runat
=
"server"
ErrorMessage
=
"Wellness Type is required."
Text
=
"*"
ControlToValidate
=
"cboWellnessType"
></
asp:RequiredFieldValidator
>
</
td
>
</
tr
>
</
table
>
<
asp:Panel
ID
=
"pnlParentCustomer"
runat
=
"server"
>
<
table
>
<
tr
>
<
td
class
=
"labelcol"
>
Reporting Roll-up Customer:
<
img
src
=
"images/Help.png"
alt
=
""
id
=
"imgAtt1"
/>
<
telerik:RadToolTip
ID
=
"RadToolTip2"
TargetControlID
=
"imgAtt1"
IsClientID
=
"true"
runat
=
"server"
HideEvent
=
"LeaveTargetAndToolTip"
AutoCloseDelay
=
"6000"
Text
=
"TODO: Need help text here."
>
</
telerik:RadToolTip
>
</
td
>
<
td
style
=
"width: 362px"
>
<
telerik:RadComboBox
ID
=
"cboParent"
runat
=
"server"
Width
=
"336px"
OnClientSelectedIndexChanged
=
"onValueChanged"
>
</
telerik:RadComboBox
>
</
td
>
</
tr
>
</
table
>
</
asp:Panel
>
</
telerik:RadAjaxPanel
>
<
table
>
<
tr
>
<
td
class
=
"labelcol"
>
Billing Customer:
</
td
>
<
td
style
=
"width: 362px"
>
<
telerik:RadComboBox
ID
=
"cboBillingCustomer"
runat
=
"server"
Width
=
"336px"
OnClientSelectedIndexChanged
=
"onValueChanged"
>
</
telerik:RadComboBox
>
</
td
>
</
tr
>
<
tr
>
<
td
class
=
"labelcol"
>
Health Management Consultant:
</
td
>
<
td
style
=
"width: 362px"
>
<
telerik:RadTextBox
ID
=
"txtInternalContact"
runat
=
"server"
Width
=
"336px"
MaxLength
=
"100"
>
</
telerik:RadTextBox
>
</
td
>
</
tr
>
<
tr
>
<
td
class
=
"labelcol"
>
Lawson Finance Cust. #:
</
td
>
<
td
style
=
"width: 362px"
>
<
telerik:RadNumericTextBox
ID
=
"txtFinanceCustomer"
runat
=
"server"
MaxLength
=
"7"
Width
=
"120px"
Culture
=
"English (United States)"
>
<
NumberFormat
DecimalDigits
=
"0"
GroupSeparator
=
""
/>
</
telerik:RadNumericTextBox
>
</
td
>
</
tr
>
</
table
>
<
br
/>
<
telerik:RadSplitter
ID
=
"RadSplitter1"
runat
=
"server"
Orientation
=
"vertical"
BorderSize
=
"0"
Height
=
"215px"
>
<
telerik:RadPane
ID
=
"RadPane1"
runat
=
"server"
Width
=
"350px"
>
<
strong
>Billing Information</
strong
><
br
/>
<
table
>
<
tr
>
<
td
>
Address Line 1:
</
td
>
<
td
style
=
"width: 237px"
>
<
telerik:RadTextBox
ID
=
"txtAddress1"
runat
=
"server"
Width
=
"95%"
MaxLength
=
"50"
>
</
telerik:RadTextBox
>
</
td
>
</
tr
>
<
tr
>
<
td
>
Address Line 2:
</
td
>
<
td
>
<
telerik:RadTextBox
ID
=
"txtAddress2"
runat
=
"server"
Width
=
"95%"
MaxLength
=
"50"
>
</
telerik:RadTextBox
>
</
td
>
</
tr
>
<
tr
>
<
td
>
City:
</
td
>
<
td
>
<
telerik:RadTextBox
ID
=
"txtCity"
runat
=
"server"
Width
=
"95%"
MaxLength
=
"50"
>
</
telerik:RadTextBox
>
</
td
>
</
tr
>
<
tr
>
<
td
>
State:
</
td
>
<
td
>
<
telerik:RadComboBox
ID
=
"cboState"
runat
=
"server"
Width
=
"95%"
>
</
telerik:RadComboBox
>
</
td
>
</
tr
>
<
tr
>
<
td
>
Zip:
</
td
>
<
td
>
<
telerik:RadTextBox
ID
=
"txtZipCode"
runat
=
"server"
MaxLength
=
"20"
>
</
telerik:RadTextBox
></
td
>
</
tr
>
<
tr
>
<
td
>
Fax Number:
</
td
>
<
td
>
<
telerik:RadMaskedTextBox
ID
=
"txtFaxNumber"
runat
=
"server"
DisplayMask
=
"###.###.####"
Mask
=
"###.###.####"
SelectionOnFocus
=
"CaretToBeginning"
Width
=
"80px"
>
</
telerik:RadMaskedTextBox
>
</
td
>
</
tr
>
</
table
>
</
telerik:RadPane
>