Forms Data Controls :: Insert Database NULL If Drop Downlist Item Is Not Selected?

Sep 1, 2010

on my aspx I have the below DDL

<asp:DropDownList ID="ColorDDL" runat="server" DataSourceID="ColorObj"
DataTextField="Size" DataValueField="BustId" Width="150px"
AppendDataBoundItems="True">
<asp:ListItem Value="-1">(Optional)</asp:ListItem>
</asp:DropDownList>

If the user does not select an item I get an exception when i call the ObjectDataSource Method and DAL as below to insert into database

ProfileObj.InsertParameters["ColorId"].DefaultValue = ColorDDL.SelectedValue.ToString();

What I want to do is insert a database NULL instead.

View 3 Replies


Similar Messages:

How To Get The Selected Item In Drop Down List And Insert It Into Database

Jan 29, 2010

how do i get the selected item in the drop down list and insert it into database (togethi populated the drop down with the values from the tables in database. It is dynamic, not static.i have a button in the gridview called 'add'. so when user clicks on it the row (whatever columns in the row) would be inserted into database. i am doing insertion/create for this.

View 14 Replies

Web Forms :: Validating Drop Downlist Whose Data Is Coming From Sql Database

Oct 25, 2010

I am using DropDownlist to validate culture as follows. <asp:DDL ID="ddlculture" runat ="server" /> for this ddlculture data is comming from sql database like this

dim dt as datatable
dim dr as datarow
dr(0) = ""
dr(1) ="--select culture"
dt.Rows.InsertAt(dr, 0)
ddlculture.DataTextField = "CultureName"
ddlculture.DataValueField = "Culture"
ddlculture.DataSource = dt
ddlculture.DataBind()

everything is ok... but i am trying to validate it using Required Field Validator or compare validator or javascript. it is not validating. what is the problem

View 5 Replies

Data Controls :: Insert NULL In Database If User Does Not Select Item From DropDownList

Jan 6, 2013

I have some textbox and Dropdownlist in my page and bind it from database

BindDropDownList(DDL3, "Guidcenter", "Centername","id");

DDL3.Items.Insert(0, new ListItem(" please select ", "0"));

I have button in my page that when user click on it insert data into database

Here when users didn't select Item from dropdownlist it insert "please select" ( text that I define for DDL ) into database but I want when users didn't select Item from database it insert NULL in database.... 

protected void ImageButton2_Click1(object sender, ImageClickEventArgs e) {
string data = Server.UrlDecode(Request.QueryString["BehCode"]);
SqlCommand _cmd = new SqlCommand("insertinfo", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cn.Open();

[Code] ......

View 1 Replies

Data Controls :: Insert Null Into Database If Users Didn't Select Any Item From DropdownList

Jan 9, 2013

URL.... When I wrote this code in other page with different SP It didn't worked correctly I change SP in new SP I used INSERT code instead of UPDATE now when users didn't select Item from ddl3 it insert 'please select' in table these are my code

protected void ImageButton2_Click1(object sender, ImageClickEventArgs e) {
SqlCommand _cmd = new SqlCommand("insertSreg", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cn.Open();

[code]....

View 1 Replies

Forms Data Controls :: Can Load Drop Downlist Along A Gridview With A Second Query

Mar 16, 2010

I have a gridview that is loaded with data from a dataset and when editing a row, i need to have a drop down list populated with another dataset with the appropriate information. I am trying to implement this on the Row_Editing event. Here's my ASP and VB codebehind for this page.

ASP.NET Code
[Code]....
VB Codebehind
[Code]....

View 7 Replies

Web Forms :: Insert Radio Button Selected Item To Database

Jun 30, 2012

I have 2 radiobutton  

1 text box and   1 button

radiobutton1

radiobutton2

And this is my table

price name Id 

View 1 Replies

Web Forms :: Redirecting A User Selected Item In A Drop Down List To Another Item?

Feb 10, 2010

I have a list with 2 sorts of items. Items that have actual values (1,2,3,4 etc) and items that are like group headings so all their values are set to 0. If someone decides to select a group heading - which has a value of 0, is it possible to redirect them to my 'Select an item' item which has a value of ""?

If worse comes to worse, I can just reconstruct the entire list, although if possible I'd like to avoid it.

View 4 Replies

Web Forms :: How To Create Hierarchy Drop Downlist

Jul 1, 2010

how to create Hierarchy Drop Downlist

View 8 Replies

C# - Select Item In Formview Based On Drop Down Selected Item

Jul 4, 2010

I am trying to get a drop down and a form view to work together. I've never used form views before. I also am using the entity framework to do everything. This is also my first time with it.

I want to be able to have a drop down, that is populate from the same data source as the form view. So far that works fine.

I then want to be able to change the drop down item, and it change the form view item that is displayed. I cannot figure out how to make this work.

View 3 Replies

Web Forms :: Drop DownList Limit Number Of Rows

Sep 17, 2010

I have a dropdown list. This is a bound to a column in Table which has around 200 entires.Now when a user clicks on the drop down list I want him to see not more than 10 rows. The rest he should navigate by using scroll bars.

View 5 Replies

Forms Data Controls :: Check If Data Exist In Database BEFORE Insert New Item

Dec 3, 2010

I have a GridView on a page for maintainance of the database (mdf). Under this GridView1 I have a FormView1 where I use the ItemInsertTemplate to Insert new rows in my database (which shows the data in GridView1). The first textbox (BIDTextBox) i have on this template, contains text which identify a person. I would like to have a routine which checks if the same value that is entered in the BIDTextBox allready exists in the database. This routine should be fired upon leaving the control BIDTextBox.

I have tried with some stored procedure in my database, but that dosn't seem to do the trick. The most logical to me seems to do a loop thru my table "Ansatte" in my database using sql, selecting any occurence from the field "BID" in my table "Ansatte" that is simillar to the text entered in the BIDTextBox.

View 6 Replies

Web Forms :: Focus On Selected Item On Drop Down List?

Mar 26, 2010

Alright heres my scenario. I click on an event and a new aspx page opens. I have two drop down lists and three text boxes. All populated with the data from the database. But when the page opens the drop down lists always show the item that is at the top of the list. Not the actual item that is in the database.

So say the name John should be there in one and a car names honda. But instead it shows alex and acura. These are just examples. But it alwasy starts with the item at the top

View 3 Replies

Data Controls :: Set RadioButton Selected Item True Using Value From Database

May 7, 2015

I have House_info table with Storetype column and I have radiobuttonlist in my page below is code

<asp:RadioButtonList ID="RBLType" runat="server" RepeatDirection="Horizontal">
<asp:ListItem Value="Galary"><span style="color:#676767">Galary</span></asp:ListItem>
<asp:ListItem Value="Product"><span style="color:Red">Product</span></asp:ListItem>
</asp:RadioButtonList>

Now I want if in Storetype column in database was="Product" then radiobutton item with text="Product" selected=true  and if in store type column was="Galary" radiobutton item with text="Galary" selected="true"

How I can do it?

View 1 Replies

Data Controls :: Delete Selected Item From Database Using DropDownList

May 7, 2015

I want to delete selected item of dropdownlist on Delete button click

Hint :1-It should also delete value from Database.
 2-I want to Delete with the id of that selected item.

View 1 Replies

Web Forms :: Dynamic Drop Down List With Selected Item Change?

Jul 14, 2010

In my application i used drop down list dynamically so that if i enter the the value in the text box that many drop down list genrated with data from database. if i select the different iteam in the drop down list it will not changed it remains the first iteam of the dropdown list. if i use post back event is true in code part that drop down list is not visible.

nt i = 0; i < rows; i++)
{
TableRow row = new TableRow();
for (int j = 0; j < column; j++)
{
TableCell cell = new TableCell();
[code]...

View 5 Replies

C# - Hyper Link To Set Drop Downlist To Visible

Apr 3, 2011

if there is a way upon clicking on a hyper link to set drop downlist to visible in code behind or asp?

<asp:HyperLink ID="HyperLink2" runat="server">View More Workout Programs »</asp:HyperLink>

View 5 Replies

How To Give Tolltip Drop Downlist Box When It Is Populated

Jan 29, 2010

when i just click on the DropDownListBox then it populates the list of items.
when i move on the on of item then color of that item changes to blue i want to assignthe tooltip for this perticular item.bcoz my text of listitem is too large which is greater than width of listbox.s there any event to capture the moved listitem

View 1 Replies

Data Controls :: Save Insert DropDownList Selected Value To Database?

Jan 20, 2014

Based on  below SQL code i would like to control the data insert.

Example If select type is 'DM', then only insert into the WM table. 

string InserttoWM = ConfigurationManager.ConnectionStrings["CIMProRPT01testserverConnectionString"].ConnectionString;
using (SqlConnection Insertcn = new SqlConnection(InserttoWM))
{

[Code].....

View 1 Replies

Web Forms :: DropDownList Selected Item Is Lost And Default Item Is Inserted In Database On Button Click

Jul 16, 2012

I bind dropdownlist in my page

protected void Page_Load(object sender, EventArgs e) {
BindDropDownList(DDL1, "city1", "name", "ID");
DDL1.Items.Insert(0, new ListItem("select city", "0"));
}

And SP

LTER procedure [dbo].[city1]
as
begin
select id,Name
from city
end

And design code

 <asp:DropDownList ID="DDL2" runat="server" CssClass="daddsd">
</asp:DropDownList>

And here is imagebutton code that when click on it update data into table

protected void ImageButton_Click1(object sender, ImageClickEventArgs e) {
string data = Server.UrlDecode(Request.QueryString["BehCode2"]);
SqlCommand _cmd = new SqlCommand("insertinfo", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cn.Open();

[Code] ....

Here when i click on button it insert all data into table but it didn't insert my selected item from dropdownlist it insert select city that i define in page_load

 DDL1.Items.Insert(0, new ListItem("select city", "0"));

And when i delete this code from page load it insert in table first row of my table it didn't insert my selected item from dropdown list.

View 1 Replies

Data Controls :: Insert (Save) Selected TreeView Nodes To Database

Nov 22, 2015

<div>
<asp:TreeView ID="TreeView1" runat="server" ExpandDepth="0" ShowLines="true"
OnSelectedNodeChanged="TreeView1_SelectedNodeChanged">

<HoverNodeStyle Font-Underline="True" ForeColor="#6666AA" />
<NodeStyle Font-Names="Tahoma" Font-Size="8pt" ForeColor="Black" HorizontalPadding="2px"
NodeSpacing="0px" VerticalPadding="2px"></NodeStyle>

[CODE]...

View 1 Replies

Data Controls :: Insert Update Selected Value Of DropDownList In GridView To Database?

Feb 21, 2013

in griedview how to save dropdown list value  save in sql  server .  

View 1 Replies

Selected Item In Dynamic Drop-down?

Oct 14, 2010

I'm trying to make the selected item the value of an asp:Label if this is possibleI am putting my drop down list in like this

For ddlAdults As Integer = 1 To strNumberSlept
CType(e.Item.FindControl("ddlEditAdults"), dropdownlist).Items.Add(new ListItem(ddlAdults.ToString(), ddlAdults.ToString()))
Next ddlAdults

And I need to add a selected item in to be the value of strSelectedItem

Dim strSelectedItem = CType(e.Item.FindControl("lblAdults"), label).Text

Not sure how to add this in dynamically

View 1 Replies

Web Forms :: Insert NULL Value When No Value Selected In ListBox

May 7, 2015

if (!String.IsNullOrEmpty(hospitallist))
{
//If TextBox is not empty pass value.
cmd.Parameters.Add(new SqlParameter("@Hospital_list ", SqlDbType.VarChar, 2000));
}
else

[Code] .....

View 1 Replies

Forms Data Controls :: Validating Page With Listview Edit Item And Insert Item Templates Are Both Present

Aug 9, 2010

I have a listview set up in "flow" mode where the existing records are all on an extended page so you can scroll down to any record.

The InsertItem Template is in the first position, making it easy to insert a new record.

And one can scroll down the page to any record, click the edit button and update that record -- nice having everything on one scrollable page.

I am running into a problem with validations. I have validation controls restricting inputs for all the textboxes on the Insert Item template. They work fine. And on Item Inserted I am running a page validation:

Page.Validate()
If Not Page.IsValid Then
e.Cancel = True
End If

which works fine also.

The problem occurs when I scroll down to an existing record, and go to edit it. I have all the same validation constraints on the textboxes for the EditItemTemplate as I have on the InsertItemTemplate. But I cannot successfully do a page validation on updating the record. The code I am using on update is:

Protected Sub LVRentals_ItemUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ListViewUpdateEventArgs) Handles LVRentals.ItemUpdating
Page.Validate()
If Not Page.IsValid Then
e.Cancel = True
End If
End Sub

This results in a Cancel even if there are no validation errors on the InsertItemTemplate because the Page.Validate() seems to be causing the InsertItemTemplate to think its fields should be filled out also.

Here is the code for a typical entry of the InsertItem Template:

[code]....

All the controls in the Edit Item template are part of ValidationGroup "edit1" and those of the InsertItem Template are part of ValidationGroup "edit2"

How can I get around receiving validation errors on the InsertItem Template when I am trying to validate just the EditItemTemplate when both are present on the page?

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved