MVC :: Selecting And Inserting Dropdownlist Value In To Table?
Mar 31, 2010
I have a table MemberProfile with columns FirstName, LastName, Gender and ComplexionCode.here iam displaying complexioncode as a dropdownlist with values fair, very fair, brown and when user selects a value I want to insert that in to table
I have creted a class( LookUpCodes) and written following code
public static IEnumerable<ComplexionCode> ComplexionCodes
{
get
[code]...
now when I click the button FirstName, LastName Gender are inserting in to the table. only Dropdownlist( ComplexionCode ) value is not inserting.
View 1 Replies
Similar Messages:
Aug 11, 2010
I am working on a web app for an online photo album. It is the last project in Scott Mitchell's book: "ASP.Net 2.0 in 24 hours".
I am creating a page where users can enter new photo images. The functionality for uploading an image will come later. I am working on just inserting a new row into the Pictures table with an optional category, a required title and a required description.
I am getting an error when I try to insert a new row.
Here is a screenshot of the page with a shot of the dropdown list.
The Categories are user-specific. I am getting the correct values retrieved.
[URL]
There are two pretty simple database tables involved here.
NOTE: The CategoryID and PIctureID are both autoincrement integer columns.
[URL]
The page uses a DetailsView that uses a SqlDataSource that uses the Pictures table. (The DetailsView's Default Mode property is set to "Insert". The "Enable Inserting" checkbox is also checked.)
The dropdown list uses a dropdown control that uses a SqlDataSource that uses the Categories table.
When the "Insert" button is clicked the CategoryID value associated with selected (Category) Name on the dropdown list will be used along with the Title and Description values to insert a row in to the Pictures table. (If no Category value is selected, then a null value will be used for the CategoryID. This is OK because the CategoryID column in the Pictures table allows nulls.)
My problem is that I am getting this error:
Cannot insert explicit value for identity column in table 'Pictures' when IDENTITY_INSERT is set to OFF.
(FYI: I have the full version of both Visual Studio and SQL Server.)
Here is my source code for the page:
[Code]....
View 3 Replies
Mar 28, 2011
i'm using a strongly typed view with a custom viewmodel. this viewmodel contains a collection of books.
public IList<Books> Books { get; private set; }
i'm also passing a select-list to the view. however the DropDownListFor helper class doesn't automatically preselect the default value of the book.
@Html.DropDownListFor(m => Model.Books[i].AuthorID, Model.Author as SelectList)
everything else works, e.g. it does pass the selected value back to the controller.
i figured out a workaround by creating the select list in the viewmodel:
@Html.DropDownListFor(m => Model.Books[i].AuthorID, new SelectList(Model.AuthorList, "Value", "Text", @Model.Books[i].AuthorID.ToString()))
however i don't want to implement this workaround if there is a simpler solution. is there a way that the view can handle values from a collection?
View 2 Replies
Aug 4, 2010
I have a drop-down list that is dynamically filled with a set of values. By viewing the source code in the browser I can tell that this list is correctly filled with the "value" and "text" parameters.
But if I try to retrieve the value using ddl.SelectedItem.Value I get the error "Object reference not set to an instance of an object" which means that there is no parameter in "value" to retrieve ...
Page_Load() contains an "If Not IsPagePostback" in which the list is filled. I don't want to use AutoPostback = True since I want to retrieve the value-parameter when I click a "save" button. I must have missed something fundamental here that I do not grasp ...
The code to fill the list looks like this:
Code:
Dim ds as Dataset ()
ds.ReadXml(the path to an xml file)
ddl.Items.Add(New ListItem("destination", "destination"))
ddl.DataSource = ds.Tables(0).DefaultView
ddl.DataBind()
This snippet does not generate any errors: Everything is printed as it should!
But inside my Submit function I cannot be retrieve the parameter:
Code:
objcmd.parameter.add("?destination ", OdbcType.VarChar).Value = ddl.SelectedItem.Value
View 29 Replies
May 28, 2010
I want to select a particular item in a dropdownlist by value, in asp.net using IronPython.
I found I can do it like this
listItem = ddl.Items.FindByValue(x)
if listItem != None: listItem.Selected = True
But I want to do it in one line
View 1 Replies
Apr 6, 2010
I have a grid and dropdownlist.I want to filter values in a grid by the selection of dropdownlist.How Can i do this? My code is like this
<asp:DropDownList ID="DDLVisitedVol" runat="server" AutoPostBack="true" DataSourceID="DsVisitedVol"
DataTextField="VisitedVol" DataValueField="VisitedVol"
Width="244px">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString=""
ProviderName=""
SelectCommand="SELECT [ID],[UserName], [Email], [visitedVol] FROM [HitTracker] where visitedVol=@VisitedVol ">
<SelectParameters>
<asp:Parameter Name="VisitedVol" Type="String"/>
</SelectParameters>
How can i pass the selected value of dropdown list to @VisitedVol.
View 1 Replies
Feb 22, 2010
I am having trouble with DropDownList (and/or DropDownListFor) when using TemplateInfo's HtmlFieldPrefix in a strongly-typed view. DropDownList properly selects the value from the model when the prefix hos not been site. Once I set the value of HtmlFieldPrefix, the value from the model is not selected in the drop-down list.
I am using .NET 3.5SP1 and ASP.NET MVC 2 RC2.
Model:
public class TestModel
{
public string Text { get; set; }
public string Option { get; set; }
[Code]....
Is there something I should be doing differently to have the proper value selected in the drop-down list?
View 15 Replies
Feb 1, 2011
Im working on an ASP.Net web forms application, where I have a form and the Index is working correctly, until I select a value from one specific control, a dropdownlist. After that no matter what control I am on if I press TAB it will go to the URL/Address Bar, from there to the search bar and then again to the URL bar...
View 1 Replies
Apr 9, 2010
I have several asp dropdownlists that are populated from a database. I would like it so that when an item is selected it opens a seperate page depending on the selection.
View 5 Replies
Feb 15, 2010
I have a complex UserControl with the main purpose to encapsulate DropDownList with a number of properties for advanced manipulation.
List is being populated on PreRender event depending on properties previously were set:
protected void Page_PreRender(object sender, EventArgs e)
{
sourceClient.SelectCommand = this.Property1 ? "exec a" : "exec b";
}
The most used property is ClientID:
[Category("Settings")]
public int ClientID
{
get
{
return Int32.Parse(DropDownList1.SelectedItem.Value);
}
set
{
DropDownList1.Items.FindByValue(value).Selected = true;
}
}
Getter commonly is being called by ControlPameters in SqlDataSources on pages with this control.
Setter - from markup: <uc:UserControl1 runat="server" ClientID='<%# Bind("ID") %>' />.
Why does setter from Bind is called earlier then PreRender? And DropDownList is empty and item selecting doesn't work! How to workaround this behavior?
View 1 Replies
Jul 2, 2010
I inherited a site which I am in the middle of updating which has a DropDownList and a RangeValidator assigned to it. The data is bound to the dropdown on Page_Load. The values are retrieved from the database so the value property of each item is set to the unique ID of the item in the DB.
The RangeValidator looks something like:
<asp:rangevalidator id="ddRangeValidator" runat="server" ControlToValidate="ddMenu" ErrorMessage="Please select value in range" MinimumValue="1" MaximumValue="100000" Type="Integer">*</asp:rangevalidator>
I have a method which automatically populates this value in jQuery e.g.
$("#ddMenu").val("An Option");
This works, however, when I try to post the page the range validation fails. Then even if I manually select that value, or select another valid value it still won't validate. The only way to make it validate is to select non-valid value and then re-selecting a valid one.
Here is the data binding code:
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load, Me.Load
If Not Page.IsPostBack Then
Dim ds As New DataSet()
Dim myDbObject As New myDbObject()
ds = myDbObject.ToDataSet() // retrieves all objects from the database
[Code]....
View 2 Replies
Aug 13, 2010
I have a dropdownlist that controls what the users see in the gridview. I want to be able to have the users select "All" as an option. For example the drop down would for years would show: All, 2010, 2009, 2008. How do I code for the user selecting "All"? I am using ASP.NET 3.5 and C#
View 7 Replies
Feb 5, 2011
I was wondering if ther is a Way to select a table name from a DropDown Menu and then dispaly the data in say a GridView?
For Example;
In PHP you can post a Value to a Veriable and Put that Veriable into a SQL Statement.
"SELECT * FROM '.$VAR.'" would be the statment used to return the data.
I was wondering if there was a similar way to dot his. Currently I have a different page for each table with other dropdown menus to select other options, or would continuing to do it like i have just stated be better?
View 5 Replies
Oct 11, 2010
The intension is to get the all text file names in the drop down present in a particular location. When a user selects any filename from the drop down, it will show the data which is in that particular text file in a GridView.
I've done both the steps and it's almost complete but i stuck on a small issue. Probably because of non-usage of ASP.NET for a long period of time. The problem is, the drop down only selects the default value not other values.Here's my code for DropDown Selected Index Change
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
DirectoryInfo di = new DirectoryInfo(@"C:myLogs");
[code]....
View 2 Replies
Sep 4, 2010
i've created my own custom model binder to handle a Section DropDownList defined in my view as:
Html.DropDownListFor(m => m.Category.Section, new SelectList(Model.Sections, "SectionID", "SectionName"), "-- Please Select --")
And here is my model binder:
public class SectionModelBinder : DefaultModelBinder
{
public override object BindModel(ControllerContext controllerContext, ModelBindingContext bindingContext)
{
var value = bindingContext.ValueProvider.GetValue(bindingContext.ModelName);
if (bindingContext.ModelType.IsAssignableFrom(typeof(Section)) && value != null)
{
if (Utilities.IsInteger(value.AttemptedValue))
return Section.GetById(Convert.ToInt32(value.AttemptedValue));
else if (value.AttemptedValue == "")
return null;
}
return base.BindModel(controllerContext, bindingContext);
}
}
Now within my controller i can say:
[HttpPost]
public ActionResult Create(FormCollection collection)
{
var category = new Category();
if (!TryUpdateModel(category, "Category")
return View(new CategoryForm(category, _sectionRepository().GetAll()));
}
This validates nicely and the correct value for the section is assigned when the model is updated, however it does not select the correct value if another property doesn't validate.
View 1 Replies
Dec 6, 2010
.aspx code looks like:
[Code]....
Now i have to create a textboxes dynamically in the same page as i select the Options value from drop down list...
View 12 Replies
Mar 2, 2014
I have 2 Dropdown(say "DD1", "DD2") and 1 Listbox(say "LB") in my web form,value of the 3 controls depend on each other.
"LB1" is dependent on "DD2" value, "DD2" is dependent on "DD1" value.
I want that if user selects "LB1" without selecting "DD2", it should give a message that "please select DD2 first"similarly if user Selects "DD2" without selecting "DD1", it should give a msg that "Please select DD1 first" ,using ASP.NET C.
View 1 Replies
Feb 8, 2011
I have three tables namely tblPerson, tblAction and tblLog.
tblPerson and tblAction has many to many relationship, so a linker table which is tblLog is necessary. tblLog contains three fields, which is logID, PersonID (tblPerson) and ActionID (tblAction). Now, I need to display the data from the GUI. How could I display the records from tblLog wherein instead of the ID from tblPerson and tblAction, the other fields would show. I know that's the purpose of a linker table, but how to use it?
View 2 Replies
Mar 31, 2010
I have to come up with a way to get data from a SQL server table given it's month
There's a smalldatetime type field called "date" in the "events" table and a field from it looks like this:
29/01/2003 17:00:00
It should be one among those that appear in the gridview when I select jan/03 in a given DropDownList control in ASP.NET.
What would be the best way to do this? Assuming I only want to go as long as 10 years to the past, wouldn't making a dictionary be a good way?
How do I change it so the top month is always the current, and each month another options appeaars in the dropdown ?
It should be a common issue, so that shall not be a trick, but I want a good and clean way of doing this, and (since I'm new to asp.net) I myself would come up with something messy after a long time trying.
So what I want is:
1) Select
2) Best way of populating DropDownList (with the current month always at the top)
3) Best way to bind the DropDownList user-friendly way of writing months to the select query-friendly way of writing datetimes
Info: ASP.NET, (C# or VB.NET), SQL Server 2005
View 4 Replies
Jan 2, 2011
In my project requirement user wants to enter a manual entry if they can not find an item in the drop down list.
Right now what I am doing is:
I set the dropdown list autopost back true and on selectedchanged event I am hiding the drop down list and showing a text box to enter a manual entry...
This is working perfect and no problems..
but the drop down list needs to change to a text box on only selecting a "unknown" option in the list...all other list items are doing unnecessary post back to the server with no use...
View 4 Replies
Jan 7, 2010
The following example displays a modal dialog box when the user clicks the button.What changes do I have to make to get it to display the dialog when a selection is made from the dropdownlist?
Note that if I set the TargetControlID property from "Button1" to "DropDownList1", teh dialog box is displayed when the dropdown is DROPPED rather than when a selection is actually made.
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="MyModalSimple.aspx.vb" Inherits="MyModalSimple" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> [code]....
View 1 Replies
Oct 19, 2010
I have a piece of sql code that selects the top 10% of a table. See below a sample of the database table
And this is my code
[Code]....
So what this code does is add up all the points in the points table, (also works out what percentage of the points each user has) and then displays the top 10%, which in this case will give me "John" and "Dave"
So what I need the sql to do is check if any other records in that table have the same number of points ast the last selected record, and to select it to.
View 3 Replies
Apr 19, 2012
I'm trying to add a time to my database that a user picks from a drop down list but it's proving problematic. Below is the code for the drop down list and the Linq code for adding the selected time to the database.
Drop Down List:
<aspropDownList ID="cboTime" runat="server" AutoPostBack="True">
<asp:ListItem>09:30</asp:ListItem>
<asp:ListItem>10:00</asp:ListItem>
<asp:ListItem>10:30</asp:ListItem>
<asp:ListItem>11:00</asp:ListItem>
<asp:ListItem>11:30</asp:ListItem>
[Code]...
The Error I'm Getting:
Value of type 'Integer' cannot be converted to 'System.TimeSpan?
The datatype is Time in the database.
View 1 Replies
Jul 8, 2010
I am having a staff table which contain staff information on it. To search staff information from the table, I want to prefer filter style. For example in the select query I want to display staff information according to three criterias. Select staff information from all sections, Select staff information from a given section, select staff information by a given Name. All these selects must be performed in a single select statement. Suppose,
SELECT * FROM StaffDetailsTbl
WHERE SectionID = CASE WHEN @SectionFilter IS NULL THEN [SELECT ALL]
ELSE SectionID = @SectionFilter
and Name = CASE WHEN @NameFilter IS NULL THEN [SELECT ALL]
ELSE Name Like '%@NameFilter%'
Where Declared variables are parameterized stored procedure values retrieved from the user.
View 2 Replies
Aug 2, 2010
I want to select a row in gridview and add the data of the row into a DataBase Table.
I have 2 tables
Table A and Table B.
I am displaying Table A data using gridview.When the user clicks the select command button in the gridview then i need to add that row data into Table B.
View 6 Replies
