Web Forms :: Give Item With DropDownList DBnull.value?

Mar 6, 2010

I have an optional DropDownList. If the user dosen't select any value the top most value is "0" unfortunatly the only way to send DBnull.Value to the database is check if the value is 0 and if it is then send dbnull. Is there a way you can do this within the dropdownlist without having to check for each and every dropdown?

View 5 Replies


Similar Messages:

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

Web Forms :: Show All Item In Second Cascading DropDownList When Default Item In First One

Aug 12, 2012

I have 2 dropdownlist in my page

1-ddlzone1

2-ddlstore1

What I need is if I select default item i.e. 0 in Zone dropdown I need to show all items in store dropdown. Below is my stored procedure to get the stores

ALTER procedure [dbo].[selectcenter]
@RegionID varchar(5)
as
begin
select ID,Centername
from Shoppingcenter
where RegionID=@RegionID
group by ID,Centername
end

View 1 Replies

Web Forms :: How To Add An Item In A Dropdownlist And Modify The Value Of That Item

Jul 10, 2010

I need to add an item in a dropdownlist and also modify the value of that item, but im getting an error : "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index"here's my Page load

Dim rt as new OleDbCommand("Select * from Question ", con)
dim rd as OleDbDataReader
rd = rt.ExecuteReader
Dim a as new OleDbCommand("Select Count (*) as C from Question" , con)
[code]...

View 2 Replies

MVC :: DropDownList Can Either Select Item OR Save Selected Item Back To Controller?

Jul 7, 2010

I have a project that queries a set of times from a database and uses these entries to populate a dropdownlist. Once the page is loaded, the user can select one of the items in the DropDownList. When the "Save" button is clicked, the Selected item value is returned to the [HttpPost] version of the controller action. This item is then stored into session. If the system returns to the page containing the dropdown, I want the saved Value to be selected in the DropDownList. What actually happens is that the DropDownList is always set to be the first item in the list.

Database Table: This data has been imported using Link to SQL

[code]....

View 4 Replies

Dropdownlist / Every Time Selecct An Item, First Item In List Gets Selected?

Feb 3, 2010

i use a dropdownlist in a page, with its items taken from a mysql database

i also use autopostback property...my problem here is that, every time i selecct an item, the first item in the list gets seelected

View 5 Replies

Access :: Adding Item To Dropdownlist From Database Using First Dropdownlist?

May 28, 2010

i have two dropdownlist , i want to add item in dropdownlist 2 from database if the city is changed in first dropdownlist..I am using access database

here is my code:

[code]....

but when i select any text , it will not show anything in dropdownlist2 ..

View 2 Replies

Web Forms :: Give A Client Side Validation All The Function Work,but In Confirm Password Its Not Hide Wen Give A Correct Password?

Jun 16, 2010

I have create a masterpage and add content page include user (firsname,lastname,password,new password,confirm new password adn etc..)detail update field. i try to give a client side validation all the function work,but in confirm password its not hide wen give a correct password.. anybody give correct solution..code are below..

[Code]....

View 2 Replies

Web Forms :: Specify Item 0 In Dropdownlist?

Jan 3, 2010

My DropDownList control is getting the information from an ObjectDataSource. I need the initial item showing on the DropDownList to be "Select an item" which is not in the database.

[Code]....

View 9 Replies

Web Forms :: Add Item To Dropdownlist - Show Name

Dec 2, 2010

I have a code to add item to dropdownlist but it shows the value only. I want an alternative text to appear for user. How to modify this code ?

DropDownList4.Items.Add(item:="%")

Now % is doing the job but I want the use to see the text "ALL" in the item of the dropdownlist.

I tried DropDownList4.Items.Add(item:="%,ALL") etc but failed.

View 3 Replies

Web Forms :: Getting Item From Created Dropdownlist In C#?

Jan 12, 2010

I have created some dropdownlists in the SelectedIndexChanged from another dropdownlist in a PlaceHolder1. Now I want to retrieve the value from the created dropdownlist

in the Button_Click1 method but I don't understand how I can achieve this.

The list items in lijst seem to be empty so I get an System.NullReferenceException; on line

[Code]....

View 2 Replies

Web Forms :: Keep Last Item In DropDownList As Selected

May 7, 2015

I have items in a sql table that i populate a dropdown list with.  so on page load the items are sent to dropdown list.  I have a button on the page with the dropdown list that onclick it launches another page that allows more items to be added to the database table.

What I want to do is to refresh/update the list of items in the dropdown list when the second page is closed.  In addition the last item added to the table will be the selected item in the drop down list.

View 1 Replies

Web Forms :: Set Last Item Of DropDownList As Selected

May 7, 2015

I am inserting a new states in the table from dropdown list , the dropdown list has new in the list, clicking on new gets me a pop up which takes the new state and inserts in a table. My requirement is I want to get the last inserted state in the dropdownlist and its id  to be selected as soon as insertion is done.

The second function is to insert the contact details where i have countryid,stateid,cityid

protected void stateSave(object sender, EventArgs e) {
using (SqlConnection conn = new SqlConnection(cs)) {
SqlCommand cmd = new SqlCommand("newStates", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter outparm = new SqlParameter("@stateID", SqlDbType.Int);

[Code] ....

View 1 Replies

Web Forms :: Trying To Add A List Item To A GridView DropDownList?

Jun 4, 2010

I'm trying to add a list item to a gridView dropDownList for when a certain value is in a certain cell in the gridview's edit mode:

[Code]....

I'm not getting any error but the 'if' is being skipped - the value of row.Cells[5] is not being read.

View 5 Replies

Web Forms :: DropDownList - Can A Value Be Sent As The Selected Item From Another Webpage

Jun 9, 2010

I would like to be able to pass a new value into a dropdownlist control from another webpage and cause an autopostback to occur. How can this be done?

View 27 Replies

Web Forms :: Can't Add Item To Different Dropdownlist By Passing Different Parameter?

Jan 12, 2010

call the method by passing parameter:

add_ddl_item_by_dt((DataTable)Session["dt_1"],ddl_1);
add_ddl_item_by_dt((DataTable)Session["dt_2"],ddl_2);
protected void add_ddl_item_by_dt(DataTable dt,DropDownList ddl)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ddl.Items.Add(dt.Rows[i]["Field_1"].ToString());
}
}

why i cannot use the above method to add item to different dropdownlist by passing different parameter?

View 3 Replies

Web Forms :: Dropdownlist Item Added Through Javascript?

Apr 19, 2010

I have a formview that when in insert/edit mode, has a dropdowlist and a linkbutton. The linkbutton opens a popup with another formview that allows the user to enter new items that are required to be added to the dropdownlist. When the popup closes, it adds any new items to the dropdownlist options (there may be more than one item added). The purpose is to prevent having to have my users partially add/update a record, go create a new item for the dropdownlist then have to come back and edit again since any new items won't be known until they are needed.

At first, I recieved the 'invalid postback or callback' warning and began reading up on the issue. Though there were several forum posts and web articles, most seemed a few years old so I thought I would find out if there were any subsequent changes that might help me out. I'm using vwd2005/ASP.Net 2.0 and do not have ajax (not available on my corporate web servers). In the page directives, I disabled EnableEventValidation but then I found that while other controls were updating, the value set in the dropdownlist was not and I had to make 2 edits anyway. Since new items in the ddl won't be around when it is rendered, i've read that I can't make use of registerforeventvalidation. ps. i have thought that i could save my viewstate, browse away from the page instead of use a popup, then restore the viewstate, but I'm concerned about being able to update the ddl while retaining the viewstate.

View 2 Replies

Web Forms :: Dropdownlist Selection Changes To First Item On Postback

Oct 19, 2010

I have been having some trouble with dropdown lists reverting back to selecting the initial item in the list after a postback once a selection has been made from the dropdown list. I have read up on this and found out that a "if not ispostback then" is required.This works fine when I add in all the items in the dropdown list manually like:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not IsPostBack Then
ddl1.Items.Add("Select...") [code]....

However, I have over 250 items and so it is far more efficient for me to load then in by using part of a multidimensional array which is created from a text file - Definitive database.txt. I have been using the following code to do so:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not IsPostBack Then
'loads the definitive database array[code]...

This loads all the items into the dropdown list perfectly, but now every time a selection is made, it reverts back to the inital item on postback even though i have included the "if not ispostback then" part.

View 3 Replies

Web Forms :: Finding The Matching Dropdownlist Item?

Mar 26, 2010

I want to compare each item in a dropdownlist to a value and if the item matches the value, I want that ddl list item to be 'selected' and showing...

why doesn't this work:

[Code]....

View 5 Replies

Web Forms :: How To Hide Selected Item Of DropDownList

Feb 23, 2014

based on the below image, May i know how if  tick the checkbox, then will hide the selected data value only.

Example, hide "a", then will hide "a" data value only.

View 1 Replies

Web Forms :: Search According To 2 DropDownList Selected Item

Aug 18, 2012

I have 2 dropdown list in my page  

1- ddlzone1    
2- ddldistrict1 and one button (search)

At first I select item from ddlzone1  click on search button according to below SP it search on database and show result... 

ALTER procedure [dbo].[GetCustomersPageWise]
@PageIndex INT = 1
,@PageSize INT = 5
,@RecordCount INT OUTPUT
,@Region nvarchar(10)
,@District nvarchar(20)

[Code] ...

Now I want when users select item from ddlzone1  after that if they select item from ddldistict1 according to their selected item from ddlzone1 and ddldistrict1  it search in table and show result

Now how I can change my SP

I changed below code in SP  but it didn't work

 WHERE ([HOuse_info].Region = @Region or @Region='0') or ([House_Info] .District=@District or @District='0')
SELECT @RecordCount = COUNT(*)

View 1 Replies

Web Forms :: Select Item In DropDownList By Text

Apr 10, 2014

Iam using dropdownlist with required filed validator and Iam getting the text from db and binding to dropdownlist so its comng well but it is showning two times in dropdown I mean in actal place and the select place so whenever I click on button it firing...

Code:

<asp:DropDownList ID="ddlMemberType" runat="server" CssClass="product-textbox" Width="420" onchange="changeMember();">
<asp:ListItem Value="Select" Text="Select MemberType" />
<asp:ListItem Value="Family" Text="Family Man" />
<asp:ListItem Value="Employee" Text="Employee" />

[Code] ....

View 1 Replies

Web Forms :: How To Clear DropDownList Selected Item

Apr 22, 2013

I have dropdownlist in my page

In Page_load page I wrote below code

  if (!IsPostBack) {
DDL1.Items.Insert(0, new ListItem("select city", "0"));
DDL2.Items.Insert(0, new ListItem("select region", "0"));
DdlDistrict.Items.Insert(0, new ListItem("select district", "0"));
}

And in this page I have btnInsert that when users click on it, it insert data in database

I want when users click on button all textboxs text be clear and all DDL selected Item clear so I set below code in btnInsert event

protected void imginsert_Click(object sender, ImageClickEventArgs e) {
SqlCommand _cmd = new SqlCommand("insertFreg", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cn.Open();
_cmd.Parameters.AddWithValue("@address", txtsdd.Text);
_cmd.Parameters.AddWithValue("@Aname", txtAname.Text);

[Code] .....

But here when I click on button it clear textboxs text but it didn't do any thing on Dropdownlist i.e

If I select 'Paris' from DDL1 when I click on button I want It show in ddl1 'Select city'

But it show 'Paris' again

What should I do?

View 1 Replies

Web Forms :: If Condition For Selected Item From DropDownList

Mar 4, 2013

I have one dropdownList=DDLtradeO  and one button=btnsubmit  In Admin.aspx page

and  I have House_info table that one of column's is T_name

here I want if users select State from DDLtradeO , in House_info table in T_name column insert "STATE"

and if users select other Item from DDLtradeO  in T_name column insert "STORE"

so in behind code I wrote below code

protected void btnsubmit(object sender, ImageClickEventArgs e)
{
string T_name = DDLtradeO.Text == "State"?"State":"Store"
SqlCommand _cmd = new SqlCommand("registerspecial", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cn.Open();

_cmd.Parameters.AddWithValue("@T_name", T_name);
_cn.close();
}

but here when I click on State Item or Other Item from DDLtradeO in both case it insert "STORE" in table

View 1 Replies

Web Forms :: Insert Only If Item Is Selected In DropDownList

Aug 12, 2012

i have dropdown list in my page that bind it from database

BindDropDownList(DDL3, "Guidcenter", "Centername", "ID");
DDL3.Items.Insert(0, new ListItem(" select all", "0"));

here when users don't select any thing from dropdown list in data base insert 'select all'  text but i want if users don't select any thing from DDL in database insert NULL.

View 1 Replies







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