


<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> Private Sub RadGridUsers_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles RadGridUsers.SelectedIndexChanged'Clear all Grids of any previous account's dataRADGrid1.DataSource = NothingRADGrid1.DataBind()RADGrid2.DataSource = NothingRADGrid2.DataBind()RADGrid3.DataSource = NothingRADGrid3.DataBind()Select Case TabStrip.SelectedTab.TextCase "TAB 1" RADGrid1.Datasource = GetProfile RADGrid1.DataBind() Exit SelectCase "TAB 2" RADGrid2.Datasource = GetAddressDetails RADGrid1.DataBind() Exit SelectCase "TAB 3" RADGrid3.Datasource = GetOrderHistory RADGrid1.DataBind() Exit SelectEnd SelectEnd SubPrivate Sub TabStrip_TabClick(ByVal sender As Object, ByVal e As Telerik.Web.UI.RadTabStripEventArgs) Handles TabStrip.TabClick Select Case e.Tab.Text Case "TAB1" If Not RadGrid1.Items.Count > 0 Then RadGrid1.Datasource = GetProfile End If Case "TAB2" If Not RadGrid2.Items.Count > 0 Then RadGrid2.Datasource = GetAddressDetails End If Case "TAB3" If Not RadGrid3.Items.Count > 0 Then RadGrid3.Datasource = GetOrderHistory End If End SelectEnd Sub
<MasterTableView Width="100%" DataKeyNames="Odline" HierarchyLoadMode="Client"
ExpandCollapseColumn-ButtonType="ImageButton"
ExpandCollapseColumn-CollapseImageUrl="hide.bmp"
ExpandCollapseColumn-ExpandImageUrl="detail.bmp" >