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
Similar Messages:
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
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
Mar 20, 2014
I used scroll bar fo my dropdownlist
below is code
<asp:DropDownList ID="DDLcity1" runat="server" CssClass="DDlcityE" OnSelectedIndexChanged="DDLcity1_SelectedIndexChanged"
ForeColor="#ca0202" AutoPostBack="true" onclick="onSelectMouseDown()" onfocusout="this.size=1;">
<script>
function onSelectMouseDown() {
document.getElementById("<%= DDLcity1.ClientID%>").size = 10;
}
</script>
problem is :when I select Item from DDL it select Item with delay I want when I select Item from DDL it select it quicly..
View 1 Replies
Feb 7, 2010
I got this to populate the dropdownlist, but I'm not sure how to setup the codebehind to insert the selected value when I select it and hit "insert" in the detailsview.
Details View
<asp:DetailsView ID="DetailsView1" runat="server" Width="400px"
DefaultMode="Insert"
AutoGenerateRows="False" oniteminserted="DetailsView1_ItemInserted">
<Fields>
[Code]....
View 12 Replies
Jul 20, 2012
I have drop down list in my page that contain cities name i bind it from city table
city id
Paris 1
Germany 2
Italy 3
USA 4
View 1 Replies
Jan 13, 2011
here is my latest bit of insanity. I'm using a formview control. In the insert template, I'm grabbing applicable values from my AD to populate a dropdown list. I select the user I want to insert, enter the other pieces of info required for my request and click Insert. The query responds back stating that the userid is NULL. So the big question in my mind is how can I bind userid to the dropdownlist if I'm populating that from the code behind? Here's my code behind code for that list:
[Code]....
View 8 Replies
Mar 24, 2010
I have 2 dropdownlist controls (ddl1 and ddl2). When I pick an item from ddl1, it will update ddl2. The problem is when I pick an item in ddl2, it always selects the first item in the list. Is it that the ddl2 autopostback causes the first ddl1 to reload and results the ddl2 to be refreshed also? Or I didn't set something correctly?
[Code]...
View 12 Replies
Aug 15, 2012
I have dropdown list in my page
BindDropDownList(DdlDistrict, "District1", "District", "ID");
DdlDistrict.Items.Insert(0, new ListItem("select district", "0"));
And I use this code for binding from database
DdlDistrict.Items.FindByText(_dr["District"].ToString()).Selected = true;
Here if in database have value it show in ddldistrict
Now I want if there wasn't any thing in database in dropdown list show "select district" that i define here
DdlDistrict.Items.Insert(0, new ListItem("select district", "0"));
View 1 Replies
Jun 12, 2010
I have been trying for a while to populate a formview when I select an item from the dropdownlist. The dropdownlist is outside of the formview. For some reason, when I select a different item it does not change in the formview. Only the first item of the list shows up. I don't know where I'm doing wrong. I tried many things and suggested informatioin and I still could not get it to work. When I do try to switch I get this error message:
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
[Code]....
[Code]....
View 3 Replies
Feb 25, 2013
I have a Dropdownlist filled from database. Its datavaluefield has a combination of 2 values from database as :
Select (convert(varchar,DoctorID)+'*'+Ltrim(RTrim(DoctorAddress))) as DoctorIDAddress
ddlDoctorName.DataValueField = "DoctorIDAddress"
now while updating the form i want to select value in dropdown list with a combination of two values from database table.
ddlDoctorName.SelectedValue = Securities.HTMLEncode(dr("ReferredByDoctorID").ToString()) + "*" + Securities.HTMLEncode(dr("RefAddress").ToString.Trim)
but when i HTMLCode my Address field and it has '&' saved in it, then it encodes it as '&' and ddl don't have selected value.
so , is there any way to select an item value from ddl using like operator or other :
ddlDoctorName.SelectedValue = Securities.HTMLEncode(dr("ReferredByDoctorID").ToString()) + "*" +"%"
View 1 Replies
Jan 5, 2010
I have a formview on a web page, set to insert mode as default. The form view is bound to a SQLDatasource. This datasource has a custom query written to select the details for this formview. The query joins two tables to provide relevant detail and not just an ID for one of the elements on the form view.
The first tabe contains information regarding projects and the second table contains detail regarding Resources. First table has the following definition:
[Code]....
View 10 Replies
Mar 15, 2011
I have a dropdownlist and a button(btnSend).
protected void btnSend_Click(object sender, EventArgs e)
{
InsertIntoTemporary();
LoadAddressdetails();
MassSendOut();
}
What i need to do is as follows;
1) Once i select the item in the dropdownlist, it will extract data from my sql query which is :
string mySQL = "SELECT * FROM examtimetable WHERE subject_name= '" + dd_cat.SelectedValue + "'";
Once seleted,it will display everything in a gridview1.
subject_id subject_name admission_no date venue seat_no
View 2 Replies
Jul 6, 2010
I would like to know if I can do the following: when I am in insert mode, can I dynamically change the select command of and then display that result in the second dropdownlist based on what was selected in the first dropdownlist.
I would like to include the minimum code to demonstrate what I am trying to do.
[Code]....
[Code]....
View 4 Replies
May 25, 2013
I use below code for binding CheckBox from database
if (_dr["Radiator"] != null && _dr["Radiator"].ToString() != "") {
RDBSH.Checked = true;
}
I want bind RadioButtonList from database like above how I can do it?
<asp:RadioButtonList ID="RBL1" runat="server" RepeatDirection="Horizontal">
<asp:ListItem Text="North" Value="North"></asp:ListItem>
<asp:ListItem Text="South" Value="South"></asp:ListItem>
</asp:RadioButtonList>
View 1 Replies
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
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
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
Feb 3, 2010
In the detailsview, I set a edit item template (a bounded dropdownlist control). But in database there are some data not set to a value (null). After clicking edit button in detailsview control I get the error about the value problem (Because after populating the dropdownlist, there is no item as null in it. )How to set dropdownlist selected index when the data is "null"?
View 6 Replies
Jan 1, 2013
I have a dropdownlist for categories.
DataTextField = "Name";
DataValueField = "ID";
drp.Items.Clear();
drp.Items.Add(new ListItem("--select category--", ""));
drp.AppendDataBoundItems = true;
ID is int and I've got this
drpsub.Items.Add(new ListItem("--select category--", ""));
I want to insert some information plus ID in databaseeverything is ok when user select category from dropdownlist (for example: India, Iran, China) but when the userchoose --select category-- she face an error because the value here is "" not an ID(int value)how can i don't let user choose --select subcategory-- ?
View 1 Replies
Aug 30, 2013
I have a dropdownlist attached to a cell when edit is selected. I am using the following code to populate the drop down list with the value that is on the row.
dlBU.Items.FindByValue((e.Row.FindControl("lblBU") as Label).Text).Selected = true;
This works famously when I have a value in the cell. It fails when the cell has not yet been populated. Is there an if then clause that if the value of e.Row.findcontrol("lblBU") is null no default value?
View 1 Replies
Feb 24, 2011
I'm using a listview control to do a survey stuff. Everything is working perfect to present the data questions, to be answered text with the different type of controls radiobuttonlists, checkboxlists, dropdownlists, etc. The admin can modify, create, change questions, answers, etc. on the survey.When it's select, edit, or insert it's easy to find the control inside a listview.However, I'm wondering how to post user's answers back to DB. How to find controls inside the listview to grab the entered data/responses from there using let's say the submit button that is outside of the listview.I believe there should be a way to do it as otherwise why we put radiobuttonlist on a listview that somebody could click it and then we should be able to get that entries. Or I'm too optimistic on this control?
View 2 Replies
Mar 30, 2010
I am unsure on how to perform this task, what i need to do is make a gallery with tagging. I need this as it is a requirement for the project. Each user will have there own gallery and be able to upload and delete images from there gallery. I already know how to insert and select images from a database. I will then display the gallery using a data repeator with paging, I am sure i can google an article for data repeator with paging.
My challenge is, when the user wants to save a image to there gallery, he must 1st upload the image and then i must some how display the image, when the image is displayed, i will have a text box where they can add tags, this textbox will save in the tag table for that user_id, picture_id and the tag will have an id also. I am unsure on how to do this When he clicks save, i wanna insert the image into the table, and the tag. If he does not click save, then nothing should be saved. Now the 2nd part.
In the data repeator, i want a modal window to popup when they click an image, this modal will have the image and the respective tags that where saved for this image, I am unsure how to this.
View 3 Replies
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
May 7, 2015
i have drop down list bound in database and i want to make the first item in drop down list is <--select-->
View 1 Replies
