Forms Data Controls :: Show Checked Checkboxes In Gridview From Database

Mar 4, 2010

I have situation where I have to show checked CheckBox in a GridView. I have three tables

1) Menu Items ( Fields: menuID, menuName, menuLink, .....)
2) User Types (Fields: userTypeID, userTypeName, ...)
3) User Menus (Field: menuID, userTypeID )

I have a screen to add new Menu Items where I am showing a Grid That has two columns

1) CheckBox and
2) User Type

I have to check CheckBox in order to Link that User Type with the Menu Itme. I am done with Add Screen. Here is the Code:

(aspx)
<asp:GridView
ID="gridView_UserTypes"
runat="server"
AutoGenerateColumns="False"
DataKeyNames="userTypeID"
Width="60%"
EmptyDataText="">
<HeaderStyle
CssClass="gridHeader"
Wrap="false"
/>
<AlternatingRowStyle
CssClass="gridAlturnateRow"
/>
<RowStyle
CssClass="gridRow"
/>
<Columns>
<asp:CheckBoxField
DataField="userTypeChecked"
HeaderText="Select"
ReadOnly="false"
Visible="true"
/>
<asp:TemplateField
HeaderText="Select">
<ItemTemplate>
<asp:CheckBox
ID="userTypeSelector"
runat="server"
/>
</ItemTemplate>
<ItemStyle
HorizontalAlign="Center"></ItemStyle>
</asp:TemplateField>
<asp:BoundField
ItemStyle-HorizontalAlign="Left"
DataField="userTypeName"
HeaderText="User Types"
HeaderStyle-Wrap="false"
ReadOnly="True"
SortExpression="userTypeID">
<ItemStyle
HorizontalAlign="Left"></ItemStyle>
</asp:BoundField>
</Columns>
</asp:GridView>
(Code Behind)
foreach (GridViewRow row in gridView_UserTypes.Rows)
{
// Access the CheckBox
CheckBox cb = (CheckBox)row.FindControl("userTypeSelector");
if (cb != null && cb.Checked)
{
// First, get the UserTypeID for the selected row
int userTypeID = Convert.ToInt32(gridView_UserTypes.DataKeys[row.RowIndex].Value);
if (selectedUserTypeIDs == "")
{
selectedUserTypeIDs = userTypeID.ToString();
}
else
{
selectedUserTypeIDs = selectedUserTypeIDs + "," + userTypeID.ToString();
}
userTypeCount++;
}
}

Now I am passing selectedUserTypeIDs along with other details to my Stored Procedure and adding those UserTypes for newly Added menu. It works fine for me. Now I want to show checked CheckBox in Edit Mode.

View 2 Replies


Similar Messages:

Forms Data Controls :: Find Multiple Checked CheckBoxes In GridView?

Nov 15, 2010

I have a GridView with checkboxes. I want to let the user choose one or several checkboxes. Right now my code only manages to find one of the chosen checkboxes:

[Code]....

How do I change it to find the values from every row that has a checked checkbox?

View 10 Replies

Forms Data Controls :: Count Number Of Checked Checkboxes In GridView?

Mar 4, 2011

I have a GridView with checkboxes. How can I count how many checkboxes are checked?

[Code]....

View 24 Replies

Data Controls :: How To Get RowIndex Of GridView Rows With Checked Checkboxes

Oct 20, 2012

How to get The Rowindex Of Gridview by clicking button outside gridview in ASP.Net?

View 1 Replies

Data Controls :: Disable Other CheckBoxes If One CheckBox Is Checked In GridView

Mar 6, 2014

i want to disable other checkbox if one is selected inside gridview . i want to make that on clientside using javascript or jquery.below is the code

<html xmlns="http://www.w3.org/1999/xhtml" ><head runat="server">
<title>Untitled Page</title>
<script src="selectedradio.js" type="text/javascript"></script>
<script type="text/javascript"> $().ready(function(){
$("#CheckBox1").click(function(){
$('input[type=checkbox]').each(function () {

[code]....

View 1 Replies

Data Controls :: Check Parent CheckBox When Child GridView CheckBoxes Are Checked

May 7, 2015

how can i checked the checkbox in parentGridview whenever i checked a checkbox in childGridview?

View 1 Replies

Fetch Data From Database Based Country Checkboxes Checked In C#

Mar 12, 2013

I have many country check boxes on page and i want to search data from database based on check boxes checked i.e. user can check check single or multiple checkboxes. So how can i fetch the data/records from database based on same.

View 1 Replies

Forms Data Controls :: Determining What Checkboxes Were Checked On Postback

Aug 25, 2010

i'm using a gridview and has a column of checkbox that is within a template field.

I want to do it in C# but I only found this code in VB

[Code]....

View 3 Replies

Forms Data Controls :: Updating Database Based On Checkboxes In Gridview

Mar 22, 2010

I am binding data in gridview .I have checkbox in gridview

<asp:GridView ID="gv_BankRecon" runat="server" BackColor="#DEBA84" BorderColor="#DEBA84" AutoGenerateColumns="false"
BorderStyle="None" BorderWidth="0px" CellPadding="3" CellSpacing="2" Width="100%"
onrowdatabound="BankRecon_RowDataBound" >
<EmptyDataTemplate>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td style="height: 20px; color: Red;" align="center">
<strong>No data found</strong>
</td>
</tr>
</table>
</EmptyDataTemplate>
<Columns>
<asp:TemplateField ShowHeader="false" HeaderStyle-HorizontalAlign="Left" ItemStyle-HorizontalAlign="Left"
HeaderStyle-Width="5%" ItemStyle-Width="5%" Visible="false">
<HeaderTemplate>
<asp:LinkButton ID="lnkbtn_AutoIdx" runat="server" Text="" CssClass="linkstyle1"
CommandArgument="AutoIdx" OnClick="sort" CommandName="Sort"></asp:LinkButton>
</HeaderTemplate>
<ItemTemplate>
<asp:Label ID="lblAutoIdx" runat="server" Text='<%# bind("AutoIdx") %>' Visible="false"></asp:Label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Left" Width="20%"></HeaderStyle>
<ItemStyle HorizontalAlign="Left" Width="20%"></ItemStyle>
</asp:TemplateField>
<asp:TemplateField ShowHeader="false" HeaderStyle-HorizontalAlign="Left" ItemStyle-HorizontalAlign="Left"
HeaderStyle-Width="20%" ItemStyle-Width="20%">
<HeaderTemplate>
<asp:LinkButton ID="lnkbtn_Payment" runat="server" Text="Payment" CssClass="linkstyle1"
CommandArgument="Credit" OnClick="sort" CommandName="Sort"></asp:LinkButton>
</HeaderTemplate>
<ItemTemplate>
<asp:Label ID="lblPayment" runat="server" Text='<%# bind("Credit") %>'></asp:Label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Left" Width="20%"></HeaderStyle>
<ItemStyle HorizontalAlign="Left" Width="20%"></ItemStyle>
</asp:TemplateField>
<asp:TemplateField ShowHeader="false" HeaderStyle-HorizontalAlign="Left" ItemStyle-HorizontalAlign="Left"
HeaderStyle-Width="20%" ItemStyle-Width="20%">
<HeaderTemplate>
<asp:LinkButton ID="lnkbtn_Clr" runat="server" Text="Clr" CssClass="linkstyle1"
CommandArgument="Reconciled" ></asp:LinkButton>
</HeaderTemplate>
<ItemTemplate>
<asp:CheckBox ID="chkClr" runat="server" />
</ItemTemplate>
<HeaderStyle HorizontalAlign="Left" Width="20%"></HeaderStyle>
<ItemStyle HorizontalAlign="Left" Width="20%"></ItemStyle>
</asp:TemplateField>
</Columns>
</asp:GridView>

when i checked the checkboxes(not all) ,corresponding rows data has to be updating when i click save button which is outside of gridview,Its just same like our gmail delete button.

View 3 Replies

Forms Data Controls :: Checkboxes In Datagrid / Update A Label In The Page With A Value Associated With The Row Of The Checked Checkbox

Aug 26, 2010

This morning I posted a question w.r.t Radio Buttons, but the requirement changed so I'm posing a similar question.

I want to have a checkbox in a datagrid.

Suppose I click on one of the checkboxes and then realize i need to click on another, the screen has to automatically uncheck the previously clicked checkbox and then check the newly clicked checkbox.

In other words I need to clear previously checked checkboxes and check the recently clicked checkbox.

Also, I need to update a label in the page with a value associated with the row of the checked checkbox.

I should not be using a javascript to do this.

View 2 Replies

Forms Data Controls :: Checking Database Value And Checkbox.checked=true In Gridview?

Apr 30, 2010

i have code to update multiple rows in a gridview. What I want is that if the row value is = 1 in the database then the row is checked otherwise it's not. I've put some pseudo code in below to illustrate what I want to achieve.

[code].....

View 3 Replies

Forms Data Controls :: Gridview - Save Selected Values And Checked Boxes In Database

Feb 2, 2010

I have a gridview and users would select some records and would click on the submit button and i will be saving those records into database using a stored proc.... now .... just below the gridview and above the submit button there are few checkboxes by default they wud be checked. How would i save the selected values and the checked boxes in database i wrote the stored proc for the gridview but how would i save the checked checkboxes into the same table.

For i As Integer = 0 To gvSelectScreen.Rows.Count - 1
Dim chkTemp As CheckBox = TryCast(gvSelectScreen.Rows(i).FindControl("cbStatus"), CheckBox)
If chkTemp.Checked Then
ContractNumber = gvSelectScreen.Rows(i).Cells(0).Text
ClientProgramNumber = gvSelectScreen.Rows(i).Cells(1).Text
ClientProgramName = gvSelectScreen.Rows(i).Cells(2).Text
StartDate = CType(gvSelectScreen.Rows(i).FindControl("txtStartDate"), TextBox).Text
EndDate = gvSelectScreen.Rows(i).Cells(5).Text
Dim connStr As String = ConfigurationManager.ConnectionStrings("MainConnectionString").ConnectionString
Dim myCon As New SqlConnection(connStr)
Dim cmd As New SqlCommand("usp_ParametersFromGrid")
Dim dt As New DataTable
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@ContractNumber", SqlDbType.VarChar, 22).Value = ContractNumber.ToString()
cmd.Parameters.Add("@ClientProgramNumber", SqlDbType.VarChar, 22).Value = ClientProgramNumber.ToString()
cmd.Parameters.Add("@ClientProgramName", SqlDbType.VarChar, 100).Value = ClientProgramName.ToString()
cmd.Parameters.Add("@StartDate", SqlDbType.VarChar, 20).Value = StartDate.ToString()
cmd.Parameters.Add("@EndDate", SqlDbType.VarChar, 20).Value = EndDate.ToString()
cmd.Parameters.Add("@RequestID", SqlDbType.VarChar, 50).Value = RequestID.ToString()
cmd.Connection = myCon
myCon.Open()
cmd.ExecuteNonQuery()
myCon.Close()
End If

Now above the submit button as i said, there are few checkboxes and they are checked by default...how would i save the selected item (in the gridview and the checked checkbox values in the same row in the database(sql server)

View 5 Replies

Forms Data Controls :: Get "checked" From Multiple Dynamically Generated Checkboxes?

Nov 16, 2010

I have a table witch i programmatically fill with(multiple) IDs in the first column, options in the second and checkboxes in the third. The table is in a View as it is part of a wizard and is filled on view_Activate.

How can i get the checked property of the checkboxes when i pass to the next view? When i try to do that on view_Deactivate the table is already 0 rows...

I know i can use i checkboxlist(... whose properties i can get on view_Deactivate) but i'd rather use a table as it is easier to layout as i want it(header, columns, alignment,...).

View 4 Replies

Data Controls :: Save Checked Rows From GridView Control To Database?

Oct 17, 2012

I have check box field in grid view and I want to save checked row in sql server 2005.how i can save.

View 1 Replies

Data Controls :: Save Checked Checkbox Values Into Database Which Is Inside GridView

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

Forms Data Controls :: Show Image In Gridview From Sql Database?

Sep 30, 2010

how to show image in gridview from sql database

View 2 Replies

Forms Data Controls :: Checkbox.Checked = False, Even Though Checkbox In The Gridview Is Checked?

May 3, 2010

I have a GridView that I was previously populating via an ObjectDataSource, and this code was working perfectly (ie, when the checkbox was checked Checkbox.Checked = true):

CODE BEHIND:

[Code]....
[Code]....

View 9 Replies

Forms Data Controls :: GridView : Checkbox : Checked Value Is Still False After Checked The Checkbox?

Mar 11, 2011

<asp:TemplateField>
<ItemTemplate>
<asp:CheckBox ID="chkRDR1" runat="server"/>
</ItemTemplate>
</asp:TemplateField>
=========================================================================================
Dim checkbox As CheckBox = CType(row.FindControl("chkRDR1"), CheckBox)

View 2 Replies

Forms Data Controls :: Retrieve Data From Database And Show In Gridview?

Feb 11, 2010

I want to get data from the database and display it in gridview. The gridview should be editable. Meaning the user can add, edit and delete items/rows in the gridview. Everytime the user adds/updates/deletes an item, the gridview is also updated. However, these changes will only be saved to the database once the Save button is clicked.

View 3 Replies

Forms Data Controls :: Check Checkboxes In Repeater Using Database?

Feb 1, 2010

I need a sample how I can check checkboxes in repeater using SQL statement. The checkboxes within repeater are populated fine and are named with ObjectName value from database but I just need to checked those values that are returned by a select statement:

private void CheckUserLocations()
{
// user reference that is currently viewed [code]....

View 8 Replies

Web Forms :: How To Determine If All Checkboxes Are Checked In Code Behind

Feb 17, 2011

I have a page that im using javascript to do a select all / unselect all for my checkboxes on the page. Now i need to determine in the code behind if all of them are checked, im wondering if it would be easier to just set a session or something whenthe select all is checked, but that wouldnt be accurate, because after you select all, you still can uncheck some..

So i need it to check at the time the button is clicked.. there are currectly 30 checkboxes, NOT a checkboxlist.

I tried using the site search but getting an error has occured when i click to search..

View 6 Replies

Web Forms :: How To Get All Checked CheckBoxes In CheckBoxList Control

Nov 30, 2013

I have a checkboxlist control in ASP.NET

<asp:CheckBoxList ID="chkchrges" runat="server">

</asp:CheckBoxList>
 
I am binding in following way
 
  chkchrges.DataSource = objclsChargeMaster
chkchrges.DataTextField = "chrgdcd"
chkchrges.DataValueField = "chrgcd"
chkchrges.DataBind()

And i am trying to get values (value member) of checked checkboxes

I am trying in folllowing way but each time it rerurns false on  

li.Selected
 
For Each li As ListItem In chkchrges.Items
If (li.Selected) Then
Dim XX = li.Value
'' Do something with Value
End If
Next

View 1 Replies

DataSource Controls :: Sending Checked Gridview Row To Database

May 10, 2010

I'm working on a web application in Visual Studio 2008. I'm using gridview to pull data from our database (I'm using a SQL Datasource) . I have a template field with a checkbox function and it allows you to check certain rows and disable them. What I am trying to do is send the enabled rows aka the non selected rows to a seperate table in our database. I'm assuming its just some kind of insert statement but I'm stuck on specifics..I am getting a object reference not sent to an instance of an object error. The line that is higlighted is, cmd.Paramters.AddWithValue("[Wrk_Pgrm_ID]" txt1.Text);

Below is the code i recieved from an earlier thread that I have modified.

[code]....

View 2 Replies

Forms Data Controls :: Trying To Add The Checked Rows Into The Database By Looping Through

May 9, 2010

I am trying to add the checked rows into the database by looping through but im getting this error:

Object reference not set to an instance of an object.

Description:

An unhandled exception occurred during the execution of the current web request. 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]....

Heres my add click event:

[Code]....

View 11 Replies

Forms Data Controls :: Display Checkboxes In Listview - Check On Bases Of Database Values?

May 10, 2010

Should 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 Replies







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