<SCRIPT runat="server">
Sub On_Click(ByVal source As Object, ByVal e As EventArgs)
SqlDataSource2.Insert()
End Sub 'On_Click
</SCRIPT>
|
|
|
|-----------more code
|
|
|
<tr>
<td>
Categroy:
</td>
<td>
<telerik:RadComboBox ID="RadComboBox1" runat="server" DataSourceID="SqlDataSource2"
AppendDataBoundItems="true"
DataTextField="Category" DataValueField="CatId" Skin="Windows7"
DropDownWidth="298px" EmptyMessage="Choose a Category" HighlightTemplatedItems="true"
EnableLoadOnDemand="true" Filter="StartsWith" >
<HeaderTemplate>
<table style="width: 100px" cellspacing="0" cellpadding="0">
<tr>
<td style="width: 100px;">
Category Id</td>
</tr>
</table>
</HeaderTemplate>
<ItemTemplate>
<table style="width: 100px" cellspacing="0" cellpadding="0">
<tr>
<td style="width: 100px;">
<%# Eval("CatId")%>
</td>
</tr>
</table>
</ItemTemplate>
</telerik:RadComboBox>
</td>
</tr>
|
|
|
|-----------more code
|
|
|
<tr>
<td colspan="2">
<br />
<br />
<asp:Button ID="btnAdd" runat="server" Text="Add New" OnClick="On_Click" />
</td>
</tr>
|
|
|
|-----------more code
|
|
|
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:MUNTERSJMmlConnectionString %>"
SelectCommand="SELECT MCategories.CatId FROM MCategories"
InsertCommand="INSERT INTO MProducts (CatId) VALUES (@CatId)">
<insertParameters>
<asp:ControlParameter Name="CatId" ControlId="RadComboBox1" PropertyName="SelectedValue" />
</insertParameters>
</asp:SqlDataSource>
<SCRIPT runat="server">
Sub On_Click(ByVal source As Object, ByVal e As EventArgs)
SqlDataSource2.Insert()
End Sub 'On_Click
</SCRIPT>
|
|
|
|-----------more code
|
|
|
<tr>
<td>
Categroy:
</td>
<td>
<telerik:RadComboBox ID="RadComboBox1" runat="server" DataSourceID="SqlDataSource2"
AppendDataBoundItems="true"
DataTextField="Category" DataValueField="CatId" Skin="Windows7"
DropDownWidth="298px" EmptyMessage="Choose a Category" HighlightTemplatedItems="true"
EnableLoadOnDemand="true" Filter="StartsWith" >
<HeaderTemplate>
<table style="width: 100px" cellspacing="0" cellpadding="0">
<tr>
<td style="width: 100px;">
Category Id</td>
</tr>
</table>
</HeaderTemplate>
<ItemTemplate>
<table style="width: 100px" cellspacing="0" cellpadding="0">
<tr>
<td style="width: 100px;">
<%# Eval("CatId")%>
</td>
</tr>
</table>
</ItemTemplate>
</telerik:RadComboBox>
</td>
</tr>
|
|
|
|-----------more code
|
|
|
<tr>
<td colspan="2">
<br />
<br />
<asp:Button ID="btnAdd" runat="server" Text="Add New" OnClick="On_Click" />
</td>
</tr>
|
|
|
|-----------more code
|
|
|
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:MUNTERSJMmlConnectionString %>"
SelectCommand="SELECT MCategories.CatId FROM MCategories"
InsertCommand="INSERT INTO MProducts (CatId) VALUES (@CatId)">
<insertParameters>
<asp:ControlParameter Name="CatId" ControlId="RadComboBox1" PropertyName="SelectedValue" />
</insertParameters>
</asp:SqlDataSource>
Hi,
I am not able to get the ID from the dropdown to do the insert of the new record based on that selected item from the that dropdown.
So when I click the "Add file" no record is being saved to the database.
thanks
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<
asp:Content
ID
=
"Content1"
ContentPlaceHolderID
=
"ContentPlaceHolder1"
runat
=
"Server"
>
<
telerik:RadFormDecorator
ID
=
"RadFormDecorator1"
Runat
=
"server"
Skin
=
"Windows7"
DecoratedControls
=
"Textbox"
/>
<
div
style
=
"padding-left:20px"
>
<
table
width
=
"90%"
border
=
"0"
cellpadding
=
"5"
style
=
"text-align:left"
>
<
tr
>
<
td
align
=
"left"
> <
div
style
=
"font-size: 14pt; font-weight: bold;"
>
Add New Media
</
div
>
</
td
> <
td
align
=
"right"
>
<
img
src
=
"../images/arrow_back.png"
align
=
"absmiddle"
/> <
asp:LinkButton
ID
=
"btnAddMedia"
Font-Bold
=
"false"
CausesValidation
=
"false"
runat
=
"server"
Text
=
"Back to Listings"
/>
</
td
>
</
tr
>
<
tr
>
<
td
><
div
runat
=
"server"
id
=
"successaddmsg"
visible
=
"false"
>
<
img
src
=
"../images/accept.png"
align
=
"absmiddle"
/>
<
asp:Label
ID
=
"Label1"
runat
=
"server"
ForeColor
=
"green"
Font-Bold
=
"true"
Font-Size
=
"12px"
Text
=
"Media item was successfully added."
/>
</
div
>
</
td
>
<
td
>
<
asp:CustomValidator
ID
=
"CustomValidator1"
runat
=
"server"
ClientValidationFunction
=
"validateRadUpload"
ErrorMessage
=
"Please select at least one valid media file"
fileOnServerValidate
=
"CustomValidator1_ServerValidate"
/>
</
td
>
</
tr
>
<
tr
>
<
td
>
Categroy:
</
td
>
<
td
>
<
telerik:RadComboBox
ID
=
"RadComboBox1"
runat
=
"server"
DataSourceID
=
"SqlDataSource2"
AppendDataBoundItems
=
"true"
DataTextField
=
"Category"
DataValueField
=
"CatId"
Skin
=
"Windows7"
>
<
Items
>
<
telerik:RadComboBoxItem
/>
</
Items
>
</
telerik:RadComboBox
>
</
td
>
</
tr
>
<
tr
>
<
td
>
Media File:
</
td
>
<
td
>
<
telerik:RadUpload
ID
=
"RadUpload1"
runat
=
"server"
ControlObjectsVisibility
=
"None"
Skin
=
"Office2007"
>
</
telerik:RadUpload
>
</
td
>
</
tr
>
<
tr
>
<
td
>
Title:
</
td
>
<
td
>
<
asp:TextBox
ID
=
"txtTitle"
Width
=
"321px"
runat
=
"server"
></
asp:TextBox
>
</
td
>
</
tr
>
<
tr
>
<
td
>
Comments:
</
td
>
<
td
>
<
asp:TextBox
ID
=
"txtDesc"
Width
=
"321px"
runat
=
"server"
></
asp:TextBox
>
</
td
>
</
tr
>
<
tr
>
<
td
colspan
=
"2"
>
<
asp:CheckBox
ID
=
"chkShow"
Checked
=
"true"
runat
=
"server"
Text
=
"Make it available on User's Download Page."
/>
</
td
>
</
tr
>
<
tr
>
<
td
colspan
=
"2"
>
<
br
/>
<
br
/>
<
asp:Button
ID
=
"btnAdd"
runat
=
"server"
Text
=
"Add file"
/>
</
td
>
</
tr
>
</
table
>
</
div
>
<
asp:SqlDataSource
ID
=
"SqlDataSource2"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:MUNTERSJMmlConnectionString %>"
SelectCommand="SELECT MediaCategories.CatId, MediaCategories.CatName AS Category FROM MediaCategories ORDER BY CatName ">
</
asp:SqlDataSource
>
<%--
Upload Large File Setting Requirements:
Open the file C:\Windows\System32\inetsrv\config\applicationHost.config and find the line:
<
section
name
=
"requestFiltering"
overrideModeDefault
=
"Deny"
/>
Set the overrideModeDefault property to Allow. So now the line should look like:
<
section
name
=
"requestFiltering"
overrideModeDefault
=
"Allow"
/>
--%>
</
asp:Content
>