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
Similar Messages:
Jan 27, 2010
[Code]....
[Code]....
View 1 Replies
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
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
Nov 14, 2010
I have Gridview like that:
[Code]....
I bind data to GV in this way:
[Code]....
No problem with that. Now, I“d like to update the database with the dropdownlist in gridview, I wrote a method in this way:
[Code]....
The problem is when I click on the edit button there is nothing in the dropdownlist, it“s empty
View 6 Replies
May 11, 2010
I've been googling for 2 days for the solution, but I couldn't find something useful. The problem is that I have GridView that is connected to the SQL database and that is how it is being populated. I added EDIT and DELETE buttons in the columns, but as far as I can see the event which handles them is empty.
[Code]....
View 11 Replies
Feb 8, 2011
I have an app where i have a GridView connected to a DropdownList....The selectedIndexChange determines what the gridview shows. Then have coded in the row editing event the ability to change the information in the row. MY ISSUE- cant take the new information changed in the row and update it in the database. I have a row updating event that im trying to figure out how to attach it to my stored proc and the newly edited row
View 12 Replies
May 31, 2010
I'm just wondering if anyone has come across a good, easy method for updating a SQL Server 2000 DB table using the edit feature in GridView. The catch here is that I need it to encrypt, send to database, then decrypt when the page calls it to be displayed. I have successfully implemented an insert method using FormView with encryption. For some reason, I just can't seem to figure out the edit/update.
View 1 Replies
Dec 18, 2010
I have created a simple application to edit data in an access database using gridview but its not working , the results are shown correctly , but when i click update nothing happens..
Here is my code
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" EnableModelValidation="True" DataKeyNames="id" >
<Columns>
<asp:CommandField ShowEditButton="True" />
<asp:BoundField DataField="id" HeaderText="id" InsertVisible="False"
SortExpression="id" />
<asp:TemplateField HeaderText="NAME" SortExpression="NAME">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("NAME") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("NAME") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="FATHER_NAME" HeaderText="FATHER_NAME"
SortExpression="FATHER_NAME" />
<asp:BoundField DataField="MOTHER_NAME" HeaderText="MOTHER_NAME"
SortExpression="MOTHER_NAME" />
<asp:BoundField DataField="CLASS" HeaderText="CLASS" SortExpression="CLASS" />
<asp:BoundField DataField="gram" HeaderText="gram" SortExpression="gram" /
<asp:TemplateField HeaderText="Remark" SortExpression="Remark">
<EditItemTemplate>
<asp:DropDownList ID="PS" runat="server" SelectedValue='<%# Bind("Remark") %>'>
<asp:ListItem>PASS</asp:ListItem>
<asp:ListItem>FAIL</asp:ListItem>
<asp:ListItem>APPEARED</asp:ListItem>
<asp:ListItem>NOT APPEARED</asp:ListItem>
<asp:ListItem></asp:ListItem>
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("Remark") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>"
ProviderName="<%$ ConnectionStrings:ConnectionString2.ProviderName %>"
UpDatecommand = "update [REGULAR] set [NAME] = ?, [FATHER_NAME]=?, [MOTHER_NAME]=?, [CLASS]=?, [gram]=?, [Remark]=? where [id] = ?"
SelectCommand="SELECT [id], [NAME], [FATHER_NAME], [MOTHER_NAME], [CLASS], [gram], [Remark] FROM [REGULAR] WHERE (([CLASS] = ?) AND ([SCHCD] = ?))">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList3" Name="class"
PropertyName="SelectedValue" Type="String" />
<asp:ControlParameter ControlID="DropDownList1" Name="schcd"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
View 1 Replies
Aug 24, 2013
how to change gridview cell value for a checked row without affecting any changes in database for ex if a row contains quantity of item 6 i want to change it value to 5,4 upto 0 that is on click event of delete quantity button i have identified row with a checkbox in grid view.
View 1 Replies
Oct 24, 2012
I have gridview in which i had enabled edit update function. i want to insert current date when ever a user edits the row. my web is in asp.net, vb code, and database is in sql
View 1 Replies
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
Aug 26, 2010
I am working with a formview edititemtemplate. Currently in my page load, i have some stuff that would show or hide certain panels based on dropdownlist values. These dropdown values get binded during page load. I need to be able to change the values/dropdowns, without rebinding the old data, and updating the visibility of the panels based on predefined rules.
I have experimented with putting my formview.databind() in page load if isnotpostback, in prerender, in prerender if isnotpostback. I have tried my rules (ex if ddlState.selectedvalue = "DE" then pnlDelaware.visible = "true") in the page load, and the page render. I'm just not sure how to get the stars aligned here. The closest i have come is having the databind in the pageload if notispostback, and the rules in the prerender. However I get an error "dropdownlist has a SelectedValue which is invalid because it does not exist in the list of items.
View 4 Replies
May 7, 2015
My query is to access the true/false value of checkbox in gridview.
I bind data into gridview where i used a checkbox in itemtemplate and bind the value with database field with checkbox Checked Property.
here in below code active is field where i stored the checkbox value True/False.
<ItemTemplate> <asp:CheckBox ID="cb_active" runat="server" Checked='<%# Eval("active")%>' /> </ItemTemplate>
View 1 Replies
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
Jul 14, 2010
have a gridview with a bunch of checkboxes. I would like to restrict the selection based on a value I get back from the database. I am able to do this on the serverside but it is very cluncky. Is there a way I could do that using javascript and ajax or just a more elegant way to approach this. The gridview is in a usercontrolMy code right now -
[Code]....
My selectioncount code is as follows - Protected Sub selectionCount(ByVal sender As Object, ByVal e As EventArgs)
View 4 Replies
Dec 3, 2010
I am running into a problem getting a value from my Grid View based on the selected checkbox. I have a grid view that is populated by database based on search criteria. However once that Grid View is populated, I would like to be able to select multiple ID's from that view. My coding experience isnt the greatest as I am still fairly new to all of this.
<asp:GridView ID="GridView1" runat="server" DataSourceID="ObjectDataSource1"
View 3 Replies
Feb 16, 2011
I am trying to implement a gridview with some checkboxes to allow users to select the rows that they would like to insert into a file selected from a dropdown list. am working on being able to select the rows from the grid but not having much success. I can get it to recognise each selected row but when I place them in a dataset it only stores the last checked gridrow. It's probably something simple that I'm missing y code is
protected
void Insert_ButtonClick(object
sender, EventArgs e)
[code]...
View 3 Replies
Dec 19, 2012
i am using template field display image based on condition in table field. i have field nameĀ verify i used to store yes or no value if it is yes then display image else noting to display in gridview
View 1 Replies
Jun 3, 2010
I hav a prob of checkboxes' checks not being registered...as explained below :
I have a gridview which is being populated using datasets.
[Code]....
I have added a column of checkboxes it using a TemplateField
[Code]....
And I am using a button to count the number of checked checkboxes.
[Code]....
I am viewing the value of session variable under at check.aspx
The Problem is that no matter how many checkboxes I check they are always counted as 0. The 'check' just doesnt get regsitered in the gridview.
After quite certain testing, a few things are clear
The checkboxes are being discovered by the counting loop fine.If I mark a cell as checked in the dataset before binding, then that check does get registered and thus is counted. Any thing I am missing ? Do i have to update something ?
View 2 Replies
Mar 10, 2011
Im trying to input the value in the table into the checkboxes but i keep getting an error that states: "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index"When i do a quick on this part of the code :"DirectCast(GridView1.Rows(i).FindControl("DescriptionA1"), Label).Text", i get "Run-time exception thrown". This is my first time trying something like that, i have search for solutions but now im more confused than ever.
[Code]....
View 3 Replies
Jul 8, 2010
save the Mulitple checkboxes in Gridview in once. I want to save only those rows which are checked.. not the once which are not checked. There is a row in gridview which has four checkboxes in each row, so i want to save the row in which either or all of the checkboxes are checked and ignore the once in which anyof checkbox is not checked.
View 4 Replies
Feb 23, 2010
I really hope I'm missing something, but I cannot for the life of me figure out a simple way to do the following: I have a database with a list of Ids, Names, and a bit field representing a boolean. Example:
Id | Name | Active
21 BoB 1
43 Ron 0
23 Tom 1
All I want is to list the names on my webpage, with check boxes beside them, and when I click the checkbox the database automatically changes the status... that's it. A checkedlistbox control would be amazing, but it doesn't seem to exist in web form. The problem with checkboxes is asp:checkbox doesn't have a "value" field anymore. So when I'm handling CheckedChanged event, I have no way of knowing what the Id of the changed entry is. I have seen a couple things online that require searching through control hierarchies to find some Id somewhere in your dataset, but that does not make sense.There MUST be a way to do something like this:
[Code]....
At this point I think it's easier to use 2 list boxes, 1 that lists people where Active=0 and one that lists people where Active=1 and then an OnSelect event that moves them between each other. That's how easy checkboxes SHOULD be.
View 3 Replies
Jul 21, 2010
How to do bulk edit/update with checkboxes in GridView control where in the selection of editting a row needs to have some info brought from db for validation on update?
View 10 Replies
Aug 3, 2010
In datalist, I hve populated Grdiview according the Category Id. Inside Gridview , I hve checkboxes. Now i want to get the selected checkboxes names to be insrted into the database. how to get access of those checkboxes inside of Gridview.
View 9 Replies
