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;
}

doesn't work....

View 3 Replies


Similar Messages:

ADO.NET :: Can't Pass DataReader Values

Nov 1, 2010

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();
}
}

View 5 Replies

ADO.NET :: Check For Null Values From DataReader

Feb 16, 2011

I have the following code

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..

View 3 Replies

Web Forms :: Values Of 1 Field In 4 Columns On UI / Display As Checkbox Values On UI?

Feb 8, 2010

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?

View 3 Replies

Forms Data Controls :: Setting Checkbox Value In A GridView?

Jun 17, 2010

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?

My codebehind is in VB.

View 12 Replies

Vb.net - Retrieve Inserted Checkbox Values In Checkbox On Page Load?

Dec 30, 2010

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]

View 1 Replies

Datareader Vs Dataset - Get The Number Of Rows From The Datareader?

Nov 15, 2010

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?

View 1 Replies

Forms Data Controls :: Setting Checked Value In Normal HTML Checkbox In A Repeater Control?

Jan 10, 2011

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]...

View 3 Replies

Data Controls :: Insert Values Of Multiple CheckBox Values To Database

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

Setting Value Of Checkbox Programmatically In VB.NET?

Jul 23, 2010

I can check the value of a checkbox in a GridViewRow:

isChecked = CType(row.FindControl("chkSelect"), CheckBox).Checked

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.

View 1 Replies

Setting Checkbox Value From Database?

Apr 8, 2010

In a itemtemplate in a listview control, how can I set the value of a checkbox to the 'IsActive' bool value being returned from my database?

<asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# (bool)Eval("IsActive") %>' />

View 5 Replies

C# - Already An Open DataReader Associated With This Command - When I'm Not Using Datareader

Jul 28, 2010

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)

View 2 Replies

Setting The Default Unchecked Value Of A Checkbox?

Feb 24, 2011

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.

View 2 Replies

Web Forms :: Setting The Properties Of USerControl From Values In C#?

Dec 15, 2010

I have some user controls which have properties which need to be set from a form on the page

<uc1:MyPlugin
ID="MyPlugin2"
runat="server"
Property1="Hi"
Property2="0" Property3="<%=Property3%>"
Property4="<%#Property4
%>"
/>

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

View 3 Replies

Web Forms :: How To Get Values Of Selected Checkbox Of Checkboxlist

Jan 6, 2011

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.

View 10 Replies

Web Forms :: How To Take Values From All Pages Which Has Some Checkbox Checked

Apr 11, 2012

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

View 1 Replies

Web Forms :: How To Store Checkbox Values In Database

May 7, 2015

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 ??

View 1 Replies

Forms Data Controls :: Setting CheckBox Control Text Property In A Repeater Control

Mar 17, 2011

I have a checkbox in a repeater control. How to get the User,Administrator,Security Admin as the checkbox Names ?

private string[] AvailableRoles = { "User", "Administrator", "Security Admin" };

Repeater_Roles.DataSource = AvailableRoles; Repeater_Roles.DataBind();
[code]....

View 3 Replies

Forms Data Controls :: Setting Values Before An Update In Detailsview Not Working?

Nov 23, 2010

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:

protected void set_update_date(Object sender, EventArgs e)
{
TextBox tbdate = (TextBox)DetailsView1.FindControl("TextBox_update");

[code]...

View 2 Replies

Forms Data Controls :: Getting Null Reference On Labels That Im Setting The Values To?

Mar 23, 2010

Why would i be getting NullReferenceException if im setting the labels with values?In my page_load i have the following:

Label hireMess = (Label)FormView1.FindControl("hireMess");
Label hireEnd = (Label)FormView1.FindControl("hireEnd");
HyperLink hyptry = (HyperLink)FormView1.FindControl("hyptry");

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:

[Code]....

View 5 Replies

Forms Data Controls :: Setting Default Values For A Column In A Girdview?

Jan 31, 2011

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.

gridview template code is as follows...

[Code]....

Empty data template code is as follows...

[Code]....

View 4 Replies

Web Forms :: How To Loop Through Checkbox And Insert Values Into Database

Jan 23, 2011

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]....

View 7 Replies

Web Forms :: Getting Values Of A Form Contains MULTIPLE CheckBox Controls

Jan 8, 2010

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.

<asp:CheckBox ID="chkbx12" OnCheckedChanged="chkLayout_CheckedChanged" Checked="true" AutoPostBack="true" runat="server" Text="Select" Font-Names="Arial" />

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

View 2 Replies

Forms Data Controls :: Get Checkbox Values In A Gridview?

Nov 30, 2010

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

View 1 Replies

Web Forms :: How To Display Selected CheckBox Values In TextBox

May 7, 2015

How to merge two the checkbox value to textbox asp.net

chekbox1

chekbox2

UPT , BLU

View 1 Replies







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