This is a migrated thread and some comments may be shown as answers.

insert new record into sql db question

1 Answer 51 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

Nick asked on 13 Apr 2011, 05:30 PM

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 />

<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>

insert new record into sql db question

1 Answer, 1 is accepted