Web Forms :: Store Radiobuttonlist Inputs Into MS SQL?
Mar 30, 2010
I'm setting up a radiobuttonlist where registrants to my site will be telling me how they found out about my site. What is the best way to store those answers in an MS SQL database?
Should I embed the radiobuttonlist in a control that I could then "connect" to my database (should I use DetailsView? FormView? I'm assuming not GridView or ListView---because I only want to display one record at time?)
Or should I not use an ASP.NET control---and just write a script in VB that binds this control to my database (even though I'm only just learning VB, and would prefer to use ASP.NET controls as much as possible).
Again, all I want to execute is a simple way to display options with corresponding radio buttons---and then store the results for each individual user into the SQL record that corresponds to the user's UserId.
View 5 Replies
Similar Messages:
Mar 24, 2011
So I want to store customer information based on radiobuttonlist selections. The radiobuttonlist items are pulled from a database. When the customer makes a selection I want that selection to be stored in a database to record their order. There are 7 radiobuttonlists. So when they make a selection on one item, they are moved along to the next item. I want this to continue through all 7, store the information in a database and then produce a order summary at the end.
View 2 Replies
Sep 2, 2010
I need to save all the inputs to my MS SQL DB from the ASP.Net page inputs...
When i save this information, It has to check whether exists or not...
If its exists then it shows The Customer already exists..
If it does not exists it needs to show like , Thank You for register with us.. , and after 5 secs it automatically redirect to some other pages...
This all can be done under update panel...
Here i am using,
tr_exists.InnerHtml = "Thank you for register with us..";
View 5 Replies
Feb 2, 2011
I have a radiobuttonlist inside a datalist itemtemplate and i need to bind the radiobuttonlist dynamically from database I have tried to bind it inside itemdatabound event of datalist but it the result is always duplicated according to the fields in teh database.
for more information:
the database has two columns one for questions and the other is for choices , for the first question with id lets say 1 there are 4 choices, when the radiobutton is binded the result appears to be 4 times duplicated ?
View 1 Replies
Feb 20, 2010
I have a requirement that user can input HTML tags in the ASP.NET TextBox. The value of the textbox will be saved in the database and then we need to show it
on some other page what he had entered. SO to do so I set the ValidateRequest="false" on the Page directive. Now the problem is that when user input somthing like :
<script> window.location = 'http://www.xyz.com'; </script>
Now its values saved in the database, but when I am showing its value in some other page It redirects me to "http://www.xyz.com" which is obvious
as the javascript catches it. But I need to find a solution as I need to show exactly what he had entered. I am thinking of Server.HtmlEncode. Can you guide me to a direction for my requirement
View 8 Replies
Mar 17, 2010
I am validator controls to validate all of the my inout controls.
My requirement is i need to validate all of the inputs before saving and updating. I have no problem in that because by default all of the input conrols are validating based on the validation rule.
I have the Copu flag option in dropdown, when i am in the the Copy option i dont need to validate some of the input controls or dont need to validate all of the input controls when i clicked Save or Update button.
View 1 Replies
Dec 30, 2010
I've written a 'register' aspx page and it works fine. Except, while testing it, if I start typing a name in the textbox, and a name with the same 1st letter already has been typed in there before, it keeps showing of and I would like it not to. Its like the autocomplet option of a combobox in winforms VB.
to turn of this feature so no one can see what a previous user has typed in the textboxes?
View 6 Replies
Jul 27, 2010
I am trying to update the database with the edited data. However, it did not manage to read the edited data from the textbox. It returned the retrieve data that I have done in the Page_Load instead. Is there any part of the code that I have written wrongly? I did manage not to use <EditItemTemplate> in my past project and manage to update the database with the same logic.
<aspx>
<!-- This DataList is created to view Personal Information -->
<asp:DataList ID="personal_dl" runat="server"> <ItemTemplate>
<table> <tr> <td style="width: 100px; text-align: left;">
<asp:Label ID="first_lbl" runat="server" ForeColor="Black" Font-Size="11px" Text="First:"></asp:Label></td> <td style="width: 350px">
<asp:TextBox ID="first_tb" runat="server" Width="341px" Font-Size="11px" Text='<%# Eval("FIRST") %>'> </asp:TextBox> </td> </tr> <tr>
<td style="width: 100px; text-align: left">
<asp:Label ID="name_lbl" runat="server" Font-Size="11px" ForeColor="Black" Text="Name:"></asp:Label> </td> <td style="width: 350px">
<asp:TextBox ID="name_tb" runat="server" Width="341px" Font-Size="11px" Text='<%# Eval("NAME") %>'> </asp:TextBox> </td> </tr> <tr> <td style="width: 100px; text-align: left;">
<asp:Label ID="id_lbl" runat="server" ForeColor="Black" Font-Size="11px" Text="ID:">
</asp:Label> </td> <td style="width: 350px">
<asp:TextBox ID="id_tb" runat="server" Width="341px" Font-Size="11px" Text='<%# Eval("ID") %>'> </asp:TextBox> </td> </tr> <tr> <td style="width: 100px; text-align: left;">
<asp:Label ID="contact_lbl" runat="server" ForeColor="Black" Font-Size="11px" Text="Contact No.:"> </asp:Label> </td> <td style="width: 350px">
<asp:TextBox ID="contact_tb" runat="server" Width="341px" Font-Size="11px" Text='<%# Eval("TELEPHONE_HP") %>'> </asp:TextBox> </td> </tr> <tr> <td style="width: 100px; text-align: left;"> <asp:Label ID="add_lbl" runat="server" ForeColor="Black" Font-Size="11px" Text="Address:"> </asp:Label> </td> <td style="width: 350px">
<asp:TextBox ID="add_tb" runat="server" Width="341px" Font-Size="11px" Text='<%# Eval("ADDRESS") %>'> </asp:TextBox> </td> </tr> </table> </ItemTemplate> </asp:DataList>
<br /> <div style="text-align: center; color: Red; width: 460px;">
<asp:Label ID="errorMsg_lbl" runat="server" />
<asp:Button ID="edit_btn" runat="server" Text="Update" />
<asp:Button ID="createBtn" runat="server" Text="Insert" /></div>
<aspx.vb>
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
'display information in datalist
Dim login As String = Session("login")
Dim id As String = Session("id")
bindDataList(personal_dl, getPersonalContent(login, id))
'display necessary DataList
personal_dl.Visible = True
'declare fields
Dim i As Integer
Dim first_tb, name_tb, id_tb, contact_tb, add_tb As New TextBox
For i = 0 To personal_dl.Items.Count - 1
first_tb = personal_dl.Items(i).FindControl("first_tb")
name_tb = personal_dl.Items(i).FindControl("name_tb")
id_tb = personal_dl.Items(i).FindControl("id_tb")
contact_tb = personal_dl.Items(i).FindControl("contact_tb")
add_tb = personal_dl.Items(i).FindControl("add_tb")
'set fields as ReadOnly - cannot edit
first_tb.ReadOnly = False name_tb.ReadOnly = False id_tb.ReadOnly = False
contact_tb.ReadOnly = False add_tb.ReadOnly = False Next
End Sub
Protected Sub edit_btn_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles edit_btn.Click 'declare fields
Dim i As Integer Dim first_tb, name_tb, id_tb, contact_tb, add_tb As New TextBox
Dim id As String = Session("id")
For i = 0 To personal_dl.Items.Count - 1
first_tb = personal_dl.Items(i).FindControl("first_tb")
name_tb = personal_dl.Items(i).FindControl("name_tb")
id_tb = personal_dl.Items(i).FindControl("id_tb")
contact_tb = personal_dl.Items(i).FindControl("contact_tb")
add_tb = personal_dl.Items(i).FindControl("add_tb")
Next Dim myConnection As OleDbConnection = dbConnection()
Dim cmd As New OleDbCommand
Dim sqlStatement As String
Dim condition As String
condition = "UPDATE staff " + _
"SET ((FIRST= @FIRST), (NAME = @NAME), (ID= @ID), (TELEPHONE_NO = @CONTACT_NO), (ADDRESS = @ADDRESS)) " + _
"WHERE (ID= @id)" sqlStatement = condition cmd.CommandText = sqlStatement
cmd.CommandType = CommandType.Text cmd.Parameters.AddWithValue("@FIRST", first_tb)
cmd.Parameters.AddWithValue("@NAME", name_tb)
cmd.Parameters.AddWithValue("@ID", id_tb)
cmd.Parameters.AddWithValue("@TELEPHONE_NO", contact_tb)
cmd.Parameters.AddWithValue("@ADDRESS", add_tb)
cmd.Parameters.AddWithValue("@ID", id)
cmd.Connection = myConnection
Try myConnection.Open()
cmd.ExecuteNonQuery() Catch ex As Exception
Finally If myConnection.State = ConnectionState.Open Then
myConnection.Close()
End If
End Try
'display information in datalist
Dim login As String = Session("login")
bindDataList(personal_dl, getPersonalContent(login, id))
End Sub
View 12 Replies
Jan 25, 2011
I am trying to find a way to limit the inputs on a webpage to a variety of different sequences, and although I have worked through the regular expression library, I am still confused on how to allow decimal places and a maximum value. I initially used rangevalidators, but as you know, these only limit the inputs to a range, and have no control over the decimal places entered. A variety of limits i have been asked to implement are:
1. Range 0-45, 0 decimal places
2. Range 0-20, 2 decimal places
3. Range 16-65, 0 decimal places
4. Range 0-99, 2 decimal places
5. Range 0-1500000, 0 decimal places
6 Range 0-200, 1 decimal place
For 1 and 5 respectively, I have used
([0-9]|[0-9]d|45)$
([0-9]|[0-9]d|1500000)$
but want to be sure that I have understood the pattern correctly. How do I then go about creating a pattern for the other examples?
View 3 Replies
Oct 22, 2010
I have a HTML.BeginForm() to change user's data (email, password etc) but I want to separate the contents at the same page, I mean that there will be:
MainContent with submit button and also
- a HTML.BeginForm() with fields to change password + submit button
- a HTML.BeginForm() with fields to change email + submit button
the thing is, I want to allow user to change his password without sending all form data to the controller, only data from the password fields.That View inherits from my buisness object with properties (Login, Password, Email etc)
View 1 Replies
Feb 4, 2011
do have a very particular question and if you want to answer it go straight to the end. But I do welcome comments and advices hence the lengthy post. we deal with a lot of forms and some of these forms are quite lengthy and have many fields. We also have a requirement - in addition to top level fields - to be able to have variable number of repating rows - as we call them. For example, let's think of a customer which has name, surname and age while it can have zero or many addresses (say 0 to 10) so the user must be able to add or remove contacts from the form while filling it in.
View 4 Replies
Sep 29, 2010
I have upto 16 calculators(I mean 16 stored procedures) in one database.How do I log all inputs for each calculater(each stored proc)?.Most of the variables are not populated in the output table so it became hard to reproduce.The variables are not consistant across all the 16 procs . Do I need to set up new table for these inputs?
View 2 Replies
Jan 4, 2011
With the following htlm:
<html>
<body>
<form action="#">
<p><input type="text"></input></p>
</form>
</body>
</html>
[code]...
View 3 Replies
Oct 26, 2010
How can I change
<telerik:RadTextBox runat="server" ID="txtUserName" Width="238px" EmptyMessage="Lütfen 'Kullanıcı Adı' nızı giriniz.">
</telerik:RadTextBox>
in normal asp input form because in teleriks format I can not use
onFocus="javascript:toggleMsg('msg-2')" or
onBlur="javascript:toggleMsg('msg-2')
View 2 Replies
Jun 18, 2010
I'm using the css sprite technique to hold all the buttons on the site in one PNG Image.
This technique works fine on all browsers on your normal Style Buttons, however for IE 7/8 it shows a border and a red x on any input where I use a css class to define the image. This technique works fine for Firefox. Am I missing something here ?
HTML:[URL]
CSS:[URL]
Comparison:[URL]
View 2 Replies
Dec 13, 2010
I am trying to validate dynamically created text inputs. I have been following tutorials about how to do jquery validation using the validation library, but I cannot seem to get this to work.
Heres the code where I generate the inputs.
[Code]....
View 7 Replies
Apr 21, 2010
Whats the easiest method of hiding all buttons but not all inputs (say drop down lists, text input boxes) in CSS that works with IE6. The purpose of this CSS file is for printing (using the media="Print" tag in the HTML).
View 2 Replies
Jun 4, 2010
How can I do paging with datalist if that datalist is populated with inputs coming from a querystring?
View 3 Replies
Sep 7, 2010
I have a calendar control where a user selects a date and then inputs info into a FormView control. Underneath the FormView is a GridView that shows all data from the SelectedDate on the calendar control. However, when the date is selected, all the information from the table ( from all dates ) is displayed.
[Code]....
And the code behind:
[Code]....
View 4 Replies
Jan 31, 2011
In my application, there is only a login page and a report page. When the user enters his login credentials he will be redirected from the login page to the reports page. I am using forms authentication for this purpose.
On the reports page I will be displaying various reports (using Telerik reporting) based on user inputs for various fields.
Now here is the funnier part; My application works correctly in all browsers (including Safari on windows platform). But when I open it in an Ipad I am getting the below error,
"Potentially dangerous request.form value was detected from the client " This error occurs when the forms authentication redirection happens from the login page to the reports page.
I tried a variety of solutions like setting ValidateRequest="false" & requestValidationMode="2.0" , but none of them helped. I also tried removing the forms authentication and that also didn't
View 1 Replies
Jan 5, 2011
I am using Asp.net and requirement specifies i use html input to post files to server rather than asp:fileupload.[ Reason : Add more html input file controls similar to CPanel file manager.(i.e) clicking on link adds another file input from which user can select another file*.But when ever i post back Request Files collection is always empty.*
HTML FORM:
<form method="post" enctype="multipart/form-data" action="documents.aspx">
<div>
<input type="file" name="attachment" id="attachment" onchange="validate(this)" />
<span class="none">Filename should be within (1-25) letters long. Can Contain only letters
& numbers</span>
<div id="moreUploads">
</div>
<div id="moreUploadsLink" style="display: none;">
<a href="javascript:addFileInput();">Attach another File</a></div>
<input type="submit" id="btnSubmit" />
</div>
</form>
Javascript:
var upload_number = 2;function addFileInput() {
try {
var fileUpload = document.getElementById("attachment");
var elemSpan = nextElement(fileUpload).cloneNode(true);
var elemDiv = document.getElementById("moreUploads");
var d = document.createElement("div");
var file = document.createElement("input");
file.setAttribute("type", "file");
file.setAttribute("id", "attachment" + upload_number);
file.setAttribute("onchange", "validate(this)");
d.appendChild(file);
d.appendChild(elemSpan);
elemDiv.appendChild(d);
upload_number++;
} catch (err) { alert(err);}}
the validate(this) is a function that validates file types on client.When validation succeeds then the link to add more file inputs is enabled. Could someone throw somelight on this.
View 1 Replies
Nov 11, 2010
Its related to datatable in gridview store in session and then session retrive and store to database. basically i am using gridview here creating new row for button click and these row adding untill user's last entry then submit all these entry to database. so i want to use session variable to store this data temporarily and after final entry user click on submit button and all data shold be save in db.
View 9 Replies
Mar 11, 2011
My SQL stored procedure returns 3 different datasets as follows:
team_id name
1 Team1
2 Team2
...and more
location_id name
1 Dallas
2 New York
...and more
branch_id name
1 Austin
2 New Jersey
...and more
How do I put this data into one Dataset so that I can loop through the data and manipulate it?
View 1 Replies
Mar 19, 2010
hey folks I got a general question that maybe some of you can just weigh in. I developed an online store for a client and people place orders online for a food ordering place however I am trying to find the best way to have the orders show up for them at the store. Currently I am sending an email and an autoprint software prints it out which works most of the time but not good enough sometimes it doesn't print. Anyone had similar issues or have other alternative solutions you may have heard off? Like I said the site sends an email to the customer and the store's email account.
View 7 Replies
Nov 23, 2010
To prevent my application from crashing with the error "A potentially dangerous Request.Form value was detected...", I just turned page validation off. I want to revisit this and solve it correctly. Is there a good strategy for this? If people are entering '<' and '>', I think the only way to save their data is to encode it via Javacript. I have tried catching it in the code-behind, but it becomes too late. I am thinking of inheriting the textbox and auto encode/decode the input with client scripts. I also have to think of all the angle brackets that are already saved in my database.
View 4 Replies
