Web Forms :: Save (Insert) Values Of Multiple CheckBoxes To Database?
May 7, 2015Save (Insert) values of multiple CheckBoxes to database in ASP.Net
View 1 RepliesSave (Insert) values of multiple CheckBoxes to database in ASP.Net
View 1 Repliesi 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" />
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();
}
i am devalope one webpage it contain one textbox and two listboxes in that user can enter textbox value and select multipule selected values fromlistbox in that how to store database values into one record (i.e database contain 3cloumns in that store in column1:20(textbox value) and clomun2:4,3,5(selected listbox values ) and column3:4,5(selected listbox values)).in that i am using wcf service for inserting method how to pass multipule selected values into services in c
View 1 RepliesI needed to redesign the input page. I have in place individual checkboxes to represent fferent selections. For the database, the result for these checkboxes are in a seperate table. The insert only works for the first table which are textboxes. The information is not getting stored for the checkboxes. I have it separately eventually the checkboxes will be used for a search feature. For example, the information of the company, phone, address are getting inserted into the database but the checkboxes refering to the business is not being stored. What am I doing wrong with my code? Am I missing "true" for the checkboxes? The following is my code:
[Code]....
I have grid view in ASP.Net 3.5. I need to add multiple blank rows in a gridview and then have to save them in database. How can I do that in most simplest way?
View 7 RepliesShould I use the SQL Server bit data type or a simple varchar where the user would enter "yes" or "no"? More importantly, how wold I go about checking these checkboxes in the listview based on the values stored in my sql server database?
View 5 Repliesi want to know how to add checkboxes in listview (e.g: Approve / Dissapprove) and save it to database. i need to submit today
here is my code:
For Each item In ListView2.Items
Dim chk1 As CheckBox = item.FindControl("CheckBox1")
Dim chk2 As CheckBox = item.FindControl("CheckBox2")
[Code]......
I am developing a Jobsite website. There are two options for resume posting on website
1. A resume format in which jobseeker can insert values in all the fileds which are normally exists in a resume.
2. Jobseeker can upload the resume.
in first point Jobseeker has to fill form through controls, everything is fine but the problem is with one field named "Language Proficiency". How do I set Language Poficiency field in database and how do I get values from checkboxlist. Is there only one checkboxlist or three.
How to store salted password in db and retreive and match it when user try to login?
View 1 Repliesprotected void SaveEmails(object sender, EventArgs e) {
for (int i = 0; i < this.Emails.Count; i++) {
string constr = ConfigurationManager.ConnectionStrings["ConString2"].ConnectionString;
string sqlStatment = "INSERT INTO [Emails] ([From],[Subject],[Body],[Date]) VALUES (@From ,@Subject,@Body,@Date)";
using (SqlConnection con = new SqlConnection(constr)) {
using (SqlCommand cmd = new SqlCommand(sqlStatment, con))
[Code] ....
I want to store attachments also... How to store attachments....
i need to insert multiple rows at a time into database table(sqlserver) from datatable or gridview. Actually iam looping through the rows of gridview and inserting each row. Is there any method to insert entire table of rows at a time into database table. Both datatable columns and database table coulmns are similar.
View 2 RepliesI have a website project in asp.net (c#). I created some text fields and dropdownlists. the user fills the text fields etc.., the dropdownlists gets data from database (.mdf) and when the user clicks on the <submit> button, I want save all the values from textfields, etc.. in my database table. How can I do this exacly ? I get the values for ddl from database with this method, [URL]
View 7 RepliesI have a string array that contains comma seperated values. I want these values to show into ListView using DataRow and DataTable.
For understanding purpose I have below sample code:
string[] cookie_IDs = ehscookieData.Split(',');
Now I have to show all the values of cookie_IDs[] into ListView using DataRow and DataTable.
My Code to be fired During Button
protected void Button2_Click(object sender, EventArgs e) {
foreach (Control ctl in Dynamic.Controls) {
if (ctl is TextBox) {
TextBox tb = (TextBox)ctl;
using (SqlConnection con = new SqlConnection(_connStr)) {
[Code] .....
PlaceHolder
<asp:PlaceHolder ID="Dynamic" runat="server">
</asp:PlaceHolder>
I am not able to find the TextBox inside Placeholder. The Ids are also randomly Generated. I debugged it but the code comes out of foreach loop .
i am integrate payment gateway in website.
1firstly user fill the form and proceed for teansaction , i want after completing process when transaction is complete then user data is save in database.
how can i do it ?i'm totally lost .
i'm using vb.net 2005 and sql server 2005
When user upload new documents then this document goes for approval to supervisor and for this i use dropdowns ...when I use dropdown the exact result not occur and now i wat to approve/reject through checkboxes...
Here is code:
<table class="CSSTableGenerator" border="0" cellpadding="0" cellspacing="0" id="results">
<asp:Repeater ID="Repeater2" OnItemCommand="Repeater2_ItemCommand"
runat="server" onitemdatabound="Repeater2_ItemDataBound">
<HeaderTemplate>
[Code] ....
Now I want to use checkboxes, how I replace dropdown checkboxes in html and also in asp.net ....
I want to enter multiple contacts in a web form. That is..if a click on any "Add" button, it should display another textbox to enter, after it shold save multiple contacts to the database...
View 3 RepliesI am new in asp.net..My Problem is i have 3 textboxes..
in first text box i enter A1,
Second Textbox i enter 3,
Third Textbox i enter 5
after button click i want to store
A1B1,A1B2,A1B3 as per second textbox i enter 3
A1C1,A1C2,A1C3,A1C4,A1C5 as per Third Textbox i enter 5
how to generate the above rows and how to save in database
I am refering below url:
[URL]
how to select items in dropdownlist if i bind it from database.
Once i select some items and save in database , after that i want items selected when page reloads that items bind in dropdown.
I am fairly new to ASP.NET C#, I have a vehicle table which stores basic info about the vehicle, then a vehicle options table that stores the options available on the table.
I have a checkboxlist control on my form and I am populating the list items from the database. I am trying to loop thru the items to determine which ones the user has selected. After determining which ones are selected I need to add rows for each item selected to the vehicle options table.
[Code]....
[Code]....
how to upload datas from c# to sql database....which means i want to save textbox values to sql column..
View 1 RepliesI have a listbox inside a formview in a details page(master/details). The values for the listbox will come from a lookup table and when the user select one or more values it should be inserted in a table. The process sould be like the following:
The user will select one or multiple values and click on a Select button. Then a label should show the selected values. Then the user will click on the Insert button in the formview to insert it in the database.
I am at my wits end (again).
(reservation system, guest signs up and at the same time checks checkboxes to indicate their wishes)
[Code]....
[Code]....
[Code]....
I am trying to insert 8 different selected values from a CheckBoxList into 8 different columns of a database. As it now, I am only able to concatenate all 8 selections into a single string in one column. But this is not what I want to do. In my DB I have Column1, 2, 3, 4, 5, 6, 7, 8. Is there any way of getting this done?
View 5 Replies