Web Forms :: Setting Checkbox Values Through Datareader
Feb 3, 2011
I have a form with a checkbox list, the values of which are value = "1" value = "2' ...etc (amount of boxes not fixed). These values correspond to an id field in a database and are stored when a new user is entered. When reloading this info I want to populate the checkboxes according to how the user originally checked them.
What is the correct way to do this?
while (reader.Read())
(
i = Convert.ToInt16(reader["Id"]);
CheckboxList1.Items.FindByValue[i].Selected = true;
}
Why can I not call the global variables CatCode and CompanyName which are equated in the first procedure GetCompanyCatID And use their new values in the second procedure UpdateCompanyCounts as parameter values. When I hard code them code their values at the end of the GetCompany CatID procedure the following procedure updates properly.
string CatCode; - delcared global string CompanyName; - delcared global protected void GetCompanyCatID() { LinkID2 = Request.QueryString["linkid"].ToString(); string L_ID = LinkID2; SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString001"].ConnectionString); SqlCommand cmd = new SqlCommand("GetCID", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@L_ID", L_ID); try { con.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { if (reader["CG_ID"] != System.DBNull.Value) CatCode = (string)reader["CG_ID"]; CompanyName = (string)reader["CG_Name"]; } } } catch (SqlException exc) { } finally { con.Close(); } // ******* HARD CODED to test below update procedure, it works. When commented out the following update procedure does not update. CatCode = "55555" CompanyName = "Test"; UpdateCompanyCounts(); } protected void UpdateCompanyCounts() { LinkID2 = Request.QueryString["linkid"].ToString(); string L_ID = LinkID2; string CatCode2 = CatCode; string CompanyName2 = CompanyName; // string CatCode2 = "23456"; // string CompanyName2 = "TEST"; SqlConnection con2 = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString001"].ConnectionString); SqlCommand cmd2 = new SqlCommand("UpdateCatCounter", con2); cmd2.CommandType = CommandType.StoredProcedure; cmd2.Parameters.AddWithValue("@L_ID", LinkID2); cmd2.Parameters.AddWithValue("@CG_ID", CatCode2 ); cmd2.Parameters.AddWithValue("@CG_Name", CompanyName2 ); try { con2.Open(); cmd2.ExecuteNonQuery(); } catch (SqlException exc) { // ErrorBox.Text += string.Format("Error: {0}<br/>", exc.Message); } finally { con2.Close(); } }
public class ProductDetails { private string _productid; public string ProductID { get { return _productid; } } private string _description; public string Description { get { return _description; } } private string _image; public string Image { get { return _image; } } public ProductDetails(string productid, string description, string image) { _productid = productid; _description = description; _image = image; } } public class DataAccess { private static string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; public ProductDetails GetProductDetails() { SqlConnection con = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand("ProductDetails", con); cmd.CommandType = CommandType.StoredProcedure; string productid = HttpContext.Current.Request.QueryString["productid"]; cmd.Parameters.Add(new SqlParameter("productid", SqlDbType.NVarChar)).Value = productid; con.Open(); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); ProductDetails pro = new ProductDetails( (string)reader["ProductID"], (string)reader["Description"], (string)reader["Image"]); reader.Close(); return pro; } } protected void PopulateControls() private DataAccess da = new DataAccess(); { ProductDetails product = da.GetProductDetails(); if (product.Description == String.Empty) { lblDescription.Visible = false; } else { lblDescription.Text = product.Description; } }
In the last piece i want to check if the Description field is null or empty in order to hide the label control but i get an error if i write: if (product.Description == DBNull.Value) and can only use ring.Empty. But i want to check for NULL values as well..
I hv a filed in db having 60 values. I want them to be displayed as checkbox values on my UI.but i want those checkboxes as 15 values in 1 column.15 in 2nd col.15 in 3rd col.and last 15 in 4th coln. how to do it?
I have a GridView with one checkbox and some fields. Now what I want is to set this checkbox dynamically on the execution of a particular function.
ie..i have a mailsend function in my code.. when this function executes the checkbox in my gridview should be set dynamically.. How do I go about acheiving this?
i have 5 checkboxes in webform and textbox1. when i search the record using the date specified in textbox1 when i enter 11-Dec-2010 in Textbox1 and click on submit button then checkbox1, checkbox2, and checkbox3 will be disabled and unchecked. and after tat when i type 13-Dec-2010 in Textbox1 and click on submit button then checkbox1, checkbox4, and checkbox5 will be disabled and unchecked .....and all the checkbox of 11-Dec-2010 will be enabled for 13-Dec-2010 I M CURRENTLY WORKING IN ASP.NET (VB)
My Datbase structure : ID Name Seats Date 1 Sumit 1,2,3 11-Dec-2010 2 Mili 1,4,5 13-Dec-2010
Example of this is that site have a look to know more : what i want : [URL]
I'm having a method that exports content from the database to excel files. The method taks as paramaters a DataReader param and a int param - the number of rows. For the number of rows i'm using a dataset, wich i fill using the same query as for the datareader. So I'm executing it twice... Is there a way I can avoid that? get the number of rows from the datareader?
i'm attempting to set regular html checkbox's checked value based on if a master asp checkbox is checked or unchecked. The normal html checkbox is located in an asp repeater control that is populated in the page load event. MAIN .ASPX PAGE <asp:CheckBox ID="ChkMaster" runat="server" OnCheckedChanged="ChkMaster_CheckedChanged" AutoPostBack="true" /> [code]...
But what's baking my noodle is trying to figure out how to programmatically set a checkbox to checked.
The scenario is I have some rows in a GridView that are associated to another value in a dropdown. So, when I select the value in the dropdown, I'd like the checkboxes in the GridViewRows that are associated with that value to be already checked.
Problem: The check value is not persisted in the database. There's no field for it. The checkbox on the GridViewRows is an ASP TemplateField.
So I iterate through the rows and would like to check whichever checkboxes I need to based on whatever condition.
I am getting an error that an open DataReader associated with this Command, when I'm not using datareader(though probably executereader() is the same thing) how would I close this if I don't have a datareader present?
using (SqlConnection conn = new SqlConnection(ConnectionString)) { SqlCommand cmd = new SqlCommand("spSelectAllTypes",conn); cmd.CommandType = CommandType.StoredProcedure; [code]...
I just want to be able to databind a bunch of dropdownlist in one open connection. (before I had multiple open and closes for each control)
Is there a way of setting the default unchecked value of a checkbox? Am not using a databound control. This is passing data from a form and would like it to pass false as opposed to null when unchecked.
Property3 and Property4 anre both public properties of the page I am on and the user control
Currently the code complaing about Property3 saying it cannot create an object of Int32 from '<%=Property3%>' and Property4 always gets set to 0 (the default)
I do not wish to use the c# code to set these values as this Plugin will be deployed with a CMS which I have no control over
I am using a checkbox list and a checkbox and i need to pass the values of selected checkbox from checkboxlist and main checbox as well in DB. i have total 6 checkbox and 6 checboxlist.
I want to updated records according to all the checkbox which is checked on page1 page 2 and so on
But right not only first page records get updated not from the all the pages . How to read the checkbox values from all the pages which has all the checkbox checked?
My code is
I have one update button After clicking on update button all the values are getting updated in database and according to that my Gridview will get updated
I want to updated recoreds accroding to all the checkbox which is checked on page1 page 2 and so on 1 I want to updated recoreds accroding to all the checkbox which is checked on page1 page 2 and so on 2
I want store the selected values of checkbox list in database, the checkbocx list is biding to datasource (means i don't know how values there are exactly) ... How can I store the values in one column or different columns knowing that I don't know how values there are ??
Background: I open a page that has a detailsview control using Accessdatasource. It is automatically opened with the row I want to update as I get there by passing the key as a URL parm. The update works for all fields except 2 template fields I added. I added a field for update date and updated by which I want the code to populate in the code behind so the user does not enter it. I have the same login on another page using an insert and it works fine. I cannot figure out what is wrong on the update and I tried everything. The code behind is in the OnItemUPdating event. code behind:
and right below that i have 1 condition to check for and then set the Text value of the 2 labels.hireMess.Text = "It Was Successfully!";hireEnd.Text ="You will be re-directed to your Pool in 10 seconds.";I compared the page to production and eveyrthing is the same and production doesnt have any issues.. not sure why its coming up null.The error comes up for the first label:Object reference not set to an instance of an object. Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.Source Error:
I have a gridview which I use to add items through the footer and the EmptyDataTemplate. There is a date field. I want to set the default of it to the current system date.
can i have the code for getting the values including Images & Data associated with Checkbox control which is checked on submited.i'm using table,in which i have images along with values of measurements.if i'm checking the checkbox means i need to get the value of that particular images and i need to send it to an eamil id.here i need a code for getting values of the image. if any one provide a code for this either for normal tables or ASP tables.
likewise i'm using 12 checkbox in a normal table(i.e <td> ).end of the form,there will be a button which should get verfy the checkbox's and set the correct value.
Protected Sub Button3_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button3.Click 'Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Dim s As String = "Selected items:<br>" Dim i As Int32 For i = 0 To chkbx(i).Count - 1 If chkbx(i).Selected Then ' List the selected items s = s & chkbx(i).Text s = s & "<br>" End If Next Label1.Text = s End Sub Sub chkLayout_CheckedChanged(ByVal sender As Object, ByVal e As EventArgs) If chkLayout.Checked = True Then chkbx(i).RepeatLayout = RepeatLayout.Table Else chkbx(i).RepeatLayout = RepeatLayout.Flow End If End Sub
Is this format is correct.i'm fresher and i dont know realy
I have a number of checkboxes embedded in a gridview. I would like to give users a dropdownlist based on when certain checkboxes have been selected.
I have tried to accomplish this by adding an onlick event to the checkboxes when they are loaded.
[Code]....
In my javascript i try to get the value that was selected. That worsk okay but when i item is de-selected i am confused about how to determine if there are no more selected rows that satisfy the condition i mentioned above.
Below is the javascript i came up with
[Code]....
Is there a way to get the values on a selected checkbox to determine if it satisfies a certain condition for displaying a dropdownlist?
Also, how can i loop through the checkbox items to make sure the conditions are met in order to display the dropdownlist