Forms Data Controls :: Inserting CheckBox List Values Into Database Rows?
Dec 28, 2010
My problem is this "I have all the tools, VS 2005, 2008, 2010. I have every book, I have SQL server 2005 and 2008" I have all the tools, but I do not know what tool or technology to use when starting out learning all this. I juat do not know what book teaches what I need to do for something like below.
Here is my question:
I created an .ASPX webform that is to "Submit" to a SQL 2005 database. I gave this form to my DBA, and he has made up a Data Model. Now I have to figure out how to write the ASP.NET code so it will submit to the DB. My first issue is not knowing this:
1. "How do I loop through my CheckBox List", and then insert the values checked into a "Database Table" (Each Checkbox value MUST be a seperate row in the table, the DBA does not want a seperate column for each checkbox value)
2. The database is using stored procedures
3. My third issue is this: "I do not know "where" to put the "code". If you do resond to this,
Summary: I just need shown the code on how to "loop through" the CheckBox List on my form, and insert those values into a database table as seperate rows.
View 2 Replies
Similar Messages:
Dec 3, 2010
I was able to gather a value from a gridview based on a selected checkbox. However, I would like to be able to grab multiple values instead of just one. I tried using a for loop to gather my information and populate labels as a test. However, that caused an error. This is the code I currently have to use.
foreach (GridViewRow gvr in GridView1.Rows)
{
if (((CheckBox)gvr.FindControl("CheckBox1")).Checked)
{
lblTest.Text = gvr.Cells[1].Text;
}
}
How to gather multiple values and populate other labels? the other labels are labeled accordingly as lblTest2 and lblTest3. I currently am gathering my data from a gridview and only want to pull the StaffID from gvr.Cells[1].text.
View 28 Replies
Apr 27, 2010
I want to insert Data Rows into Gridview from web page and I want to send the Inserted Row to Database table.
So I have 3 columns to insert the row.
I added itemtemplate & fotter template with textbox control for each column Inside Templatefield.
I added two buttons [Insert & Cancel buttons ] in fotter template to insert the row in Gridview.
After debugging the page I can't see gridview in my webpage. i can see only EdItdatatemplate items only.Why ?
Can you look at my code & me to insert the records in gridview..
.aspx page,
[Code]....
.cs
[Code]....
View 7 Replies
Aug 12, 2010
I'm trying to collect the checked boxes values in a data list. Need to collect the checked value (ie "1") and the data key value (cdID) together in an array to then insert into DB. Here's the Datalist:
[Code]....
Here's my attempt(which isn't working too well):
[Code]....
View 7 Replies
Jul 12, 2010
i have a check box list control that is used for showing related files to some post.
what i want to do is set the databound items "checked" to true by default
then,
if a user unchecks some item and clicks the save button. then the selectedindexchanged will fire and i will do some logic.
what i have done is.
--Set All Databound items to "checked" --
[code]....
in the end i want the item that was unchecked to be removed (all other items will remain checked). but even before that, when the user control is loaded all the files that were bounded are being deleted by the index change event.
View 3 Replies
May 7, 2015
i showed two column (Electronics,Photoshop) but i have six. i want to update their checked or unchecked condition in database (0,1) how do i do?
<asp:CheckBox ID="CheckBox1" runat="server" Text="Electronics" />
<asp:CheckBox ID="CheckBox2" runat="server" Text="Photoshop" />
<asp:CheckBox ID="CheckBox3" runat="server" Text="VideoEditing" />
<asp:CheckBox ID="CheckBox4" runat="server" Text="Gaming" />
<asp:CheckBox ID="CheckBox5" runat="server" Text="Coding" />
<asp:CheckBox ID="CheckBox6" runat="server" Text="Miscellaneous" />
View 1 Replies
Oct 20, 2012
I am having gridview and i have check box for each row. There are 2 buttons ,accept and reject outside the gridview. If I click accept button, all the checked rows fields value should change to accept and if i click reject button all the checked rows column value should change to reject. There are 3 columns only one column will change.
View 1 Replies
Aug 4, 2010
i use this to select one checkbox to isselected column how i convert this to multi checkboxlist to single column i use many ways more than 3 days without success
private void BindCheckBoxList()
{
DataTable dt = new DataTable();
SqlConnection connection = new SqlConnection(GetConnectionString());
try
{
connection.Open();
string sqlStatement = "SELECT * FROM boby";
SqlCommand sqlCmd = new SqlCommand(sqlStatement, connection);
SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd);
sqlDa.Fill(dt);
if (dt.Rows.Count > 0)
{
CheckBoxList1.RepeatColumns = 4; // set the number of columns in the CheckBoxList
CheckBoxList1.DataSource = dt;
CheckBoxList1.DataTextField = "Name"; // the items to be displayed in the list items
CheckBoxList1.DataValueField = "Name"; // the id of the items displayed
CheckBoxList1.DataBind();
//Setting the Selected Items in the ChecBoxList based from the value in the database
//to do this, lets iterate to each items in the list
for (int i = 0; i < dt.Rows.Count; i++)
{
if (!string.IsNullOrEmpty(dt.Rows[i]["IsSelected"].ToString()))
{
CheckBoxList1.Items[i].Selected = Convert.ToBoolean(dt.Rows[i]["IsSelected"]);
}
}
}
}
catch (System.Data.SqlClient.SqlException ex)
{
string msg = "Fetch Error:";
msg += ex.Message;
throw new Exception(msg);
}
finally
{
connection.Close();
}
}
private void Update(string name, bool isSelected)
{
SqlConnection connection = new SqlConnection(GetConnectionString());
SqlCommand cmd;
string sqlStatement = string.Empty;
try
{
connection.Open();
sqlStatement = "UPDATE handymen SET IsSelected = @IsSelected WHERE Name = @BizName";
cmd = new SqlCommand(sqlStatement, connection);
cmd.Parameters.AddWithValue("@Name", name);
cmd.Parameters.AddWithValue("@IsSelected", isSelected);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
catch (System.Data.SqlClient.SqlException ex)
{
string msg = "Insert/Update error";
msg += ex.Message;
throw new Exception(msg);
}
finally
{
connection.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BindCheckBoxList();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string str = string.Empty;
for (int i = 0; i < CheckBoxList1.Items.Count; i++)
{
if (CheckBoxList1.Items[i].Selected)
{
str = CheckBoxList1.Items[i].Text;
Update(str, CheckBoxList1.Items[i].Selected);
}
}
//ReBind the List to retain the selected items on postbacks
BindCheckBoxList();
}
View 3 Replies
Feb 11, 2010
Is it possible to add values from different database rows to a dropdownlist?
I'm currently trying to add both ItemSizeSmall and ItemSizeMedium, but through trial and error I can still only add one row from the database. I want the dropdownlist to display "Small" and "Medium" etc.
I guess my primary question is: How do I create a database with product size attributes?
I apologize if this thread should be in another forum, but if the dropdownlist can display two database rows I'll settle with that solution.
Could the database look like this:
table1: product
PK: productID
table2: productAttribute
PK: productID
PK: attributeValueID
table3: attributeValue
PK: attributeValueID
FK1: attributeNameID
table4: attribute
PK: attributeNameID
name
If this is right: How do I make the dropdownlist display the different sizes?
View 6 Replies
May 15, 2010
i got my checkbox control in each row.actually my problem is i bound checkbox in a gridviw and i need those checkbox are checkd if database values are match.i do it like below
[Code]....
but problem is only one checkbox is checked.in page_Load i bind gridviw in ROwDatabound event i check Duecode in another table.so i need only matching checkbox should be checked.
View 4 Replies
Feb 1, 2011
Using a class component, an Object data source and a formview I am successfully pulliing data from a SQL database. In some cases the rows contain one or more Null values and I would like them to be ignored completely. My simple code follows:-
<%# Eval("add_1") & ","%>
<%# Eval("Add_2") & ","%>
<%# Eval("Add_3") & ","%>
OUTPUT:-
Rose Cottage, 123 New Road, Margate,
View 2 Replies
Jan 24, 2011
I want to name the headers of the ListView control acording to values of the first rows of a table in the database. This I want to do because the number of columns varies for each cutstomer and also the name of the column.
View 10 Replies
Dec 23, 2015
I have a gridview inside which there are 4-5 checkboxes. In that gridview, I have 10 rows too. So, Now what i want is.
IF I check, 2 checkboxes and don't check remaining checkboxes. how to save the value of the checked checkboxes value as Y and unchecked checkboxes value as N into the database.
Below is the HTML of the checkboxes here:-
<cc2:Grid ID="GrdRights" runat="server" FolderStyle="../Styles/Grid/style_12"
AllowSorting="False" AutoGenerateColumns="False" AllowColumnResizing="true" AllowAddingRecords="false"
AllowMultiRecordSelection="true" OnRowDataBound="GrdRights_RowDataBound" ViewStateMode="Enabled"
PageSize="100">
<ClientSideEvents OnClientSelect="FunMonthList" />
<ScrollingSettings ScrollHeight="400px" />
[Code] .....
View 1 Replies
Mar 9, 2011
I am currently trying to create a web from that takes multiple lines and inserts them in to multiple rows in sql. So basically On the Web form It will have the following info
Store No = "28" Activity = "Bake Cake" Date = "3/3/11"
Store No = "28" Activity = "Eat Cake" Date = "3/6/11"
Store No = "28" Activity = "Sell Lemonade" Date = "2/3/11"
Store No = "28" Activity = "Bake Fudge" Date = "3/30/11"
Store No = "28" Activity = "Eat Cookies" Date = "5/3/11"
Currently I am using this script to insert values into SQL:
[Code]....
View 4 Replies
Oct 22, 2010
I am having trouble inserting rows from a DetailsView. I am using a profiler, and I can see that 18 parameters are being passed in to my procedure where there should only be 10.
Here is the markup, and it is followed by the query that is sent to my database:
[Code]....
View 2 Replies
Sep 10, 2010
Using checkboxes, can the row of record(s) be inserted into a database? I am populating a Gridview. Done. A checkbox field has been added, when the user selects one or more rows, a submit button (which is not working) needs to inserting those records into a table. The insert statment will work outside of the page but is not working using the scenario I jut described. Is this task as I have outlined doable?
View 13 Replies
May 27, 2010
I have a situation where I want to show the selected records out of total records for a product of an employee
1) There is a checkbox list bind to <List> of objects from object datasource (For total items in list)
2) Now I want to check the selected items for a particular record in this list
3) For this purpose I have another list of <List> selected items returned by data access layer (For selected items for that employee )
4) How do I bind the selected objects with the total items list ?
5) In spaghetti coding model it was all too easy just by binding the checkbox list with a sql data source and running a for each on form load
View 5 Replies
Dec 13, 2010
code for inserting rows by button click on table or grid
View 5 Replies
Sep 28, 2010
I'm creating an quiz application which queries the database and extracts the questions and choices. I use dynamically created controls such as a checkbox list and fill the values dynamically. How do I do this? Right now I have these functions:
array_random_init(); this creates a 10 element integer array from 1-20 - extract_question(i): this extracts a question indexed at i in DB, I created the controls and set the appropriate text in this function. - validate_question(i); this is called by button_click and validates the question i according to DB.
I understand I have to recreate the controls in Page_init on postback, but what should it look like? Do I need to add "if IsPostBack" in page_init, or do I create the controls in page_init() and reset their properties in page_load when I use extract_question(i)? Also, I cannot seem to clear the selected boxes on postback, I added page directive "enableviewstate=false" but it doesn't work.
View 2 Replies
Apr 8, 2010
generating logic for follwing:An option to add a range of computers based on tag numbers, for instance, user input 800101 and 800110 would add computers SYS800101, SYS800102, SYS800103, SYS 800104, SYS800105, SYS800106, SYS800107, SYS800108, SYS800109, and SYS800110. Currently the app adds a single computer at a time.Here I am using ASP.NET using C# and my backend in active directory. I had made the following code and the problem is when I enter the range like given above only the first computer in entered in the list and does not give me any error.
[Code]....
View 4 Replies
Nov 18, 2010
have a form where I insert record via DetailView control. I have some string fields. For each string field (nvarchar in sql) I have defined the Default Value in the SQL SERVER (2008) as ''. Also I have added to each InsertParameter of the DetailsView a DefaultValue="".Yet still, if the user enters no value for one of the string fields, NULL is inserted into the table.
View 4 Replies
Jun 8, 2010
I am using Stored Procedure as my Insert/Update command in a FormView. The sp returns a value which I will need to use. How do I retrieve the value after doing an insert / update?
View 4 Replies
Nov 17, 2010
I am working on a page where the user first selects a state from a drop down, then a city from a checkbox list (eventually able to select multiple cities, but have to figure out how to do one first). The checkbox list is dependent upon the state selected. I would like the selected value of the checkbox to be submitted into the ListingLocation table of the database. In the code I have written I have included a label that displays the id value of the selected box when submitted just to make sure that the checkbox is providing the correct value. For some reason when I select a state and then check a city and click submit, no value is written into the database. The label text changes to the number I want entered into the database, so it is generating the correct number, but not submitting. I have included my code below.
<script runat="server">
View 3 Replies
Jul 18, 2010
I am trying to delete multiple rows using a checkbox in a Gridview. When someone checks the checkbox and then click on button Delete that the rows is chosen will be deleting.
GUI:
[Code]....
when i click on button Delete : Error: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
View 5 Replies
Nov 29, 2010
I have a gridview with two checkbox columns (Freeze & Display) with 10 rows, when i check the Freeze checkbox in 5th row, then all the rows from 1st to 5th row will get checked, and then "Display" checkbox will get automatically checked and get disabled for the first 5 rows. Then when i uncheck the 3rd row Freeze checkbox, then the row below from 3rd to 5th row should get unchecked. Is this functionality can be implemented.
[Code]....
View 5 Replies
