I have a field "Active" which can contain either 1 or 0. In the aspx form, I am displaying it in a checkbox in gridview. If the database value is 1, I should have the checkbox as checked, otherwise it should be unchecked. How can this be done.
View 3 Replies
i got my checkbox control in each row.actually my problem is i bound checkbox in a gridviw and i need those checkbox are checkd if database values are match.i do it like below
[Code]....
but problem is only one checkbox is checked.in page_Load i bind gridviw in ROwDatabound event i check Duecode in another table.so i need only matching checkbox should be checked.
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>
when i checked the checkbox in parent gridview, all checkbox in child gridview will be checked.
how can i select the checkbox of child gridview checkbox in the when i select the checkbox from the parent gridview?
code behind
protected void OnCheckedChanged(object sender, EventArgs e)
{
[Code].....
Im using the following code to get the gridview rows that are checked and then add the values to the database.Its all works correctly unless apart from when i check the row at the top of the gridview where when i check the checkbox it doesnt even change to checked so i cannot add that row into the database.
[Code]....
[code]....
It works on Internet Explorer but I have few users who started to use apple's snow leopard and event is not at all firing on those browsers.
I believe some browsers have different JavaScript implementation
If I check the header checkbox all the items are getting inserted If i deselt some of the items its not taking it.
If I deselect some items it must not insert inot the checkbox
<asp:TemplateField HeaderText="StateName">
<HeaderTemplate>
<asp:CheckBox ID="checkAll" runat="server" onclick = "checkAll(this);" />
</HeaderTemplate>
<ItemTemplate>
<asp:CheckBox ID="CheckBox2" runat="server"/>
[Code] .....
Here I have two gridview controls and both controls have some data. And gridview1 has checkbox1.
My question is I want compare both gridview1 and gridview2
And if the gridview2 row data is present in gridview1
I want to make if compared row is same.In that row's checkbox1.checked=true.
In my gridview in header section i have checkbox when ckeck all checkbox get checked/Unchecked bt when i added update panel to gridview postbback gone bt ckeckall not functioning properly the script i use is..
<script type="text/javascript">
$(document).ready(function() {
$('[id$=chkHeader]').click(function() {
$("[id$='chkChild']").attr('checked', this.checked);
});
});
</script>
Im developing an ASP Web application and have a Gridview which I have set as follows:-
[Code]....
At this point alls good.
I have a field in the selected table that returns an integer which relates to a Table on a Seperate Database.
Is it possible, when the grid is being filled to check a fields value and set anothers columns value depending on the vale?
ie First Row Column 1 value is 1 so set Column 2 to "Sunny"
Second Row Column 1 value is 2 so set Column 2 to "Cloudy"
how can i checked the checkbox in parentGridview whenever i checked a checkbox in childGridview?
View 1 RepliesI use 2 columns,
1. Branch name --> uses checkbox
2. Sub Branch Name --> uses Checkboxlist
both column data are fetched from database the table luks like this
1. (checkbox) Branchname1 (checkboxlist) ALL Subbranchnames
2.(checkbox) Branchname2 (checkboxlist) ALL Subbranchnames
etc....
if i select checkbox of branch 1 all my subbranches checkbox list should be selected and viceversa
same for branch2
I am using a javascript code which in which if i select a branch name everything in my page is selected including branch2 n its corresponding subbranch..
i have a grid as
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
ShowHeader="False" CellPadding="7">
<Columns>
[Code].....
i am able to find the clicked cell but failed to check the checkbox.
I have a grid view with two columns A and B. Column A has Checkboxes and Column B has numeric values(int). When user checked checkboxes the checked checkboxes column B have to added and displayed in a Label.
View 1 Repliesi have gridview with page index 1,2,3,....... & having 5 records per page with 2 columns. i want to check checkbox from one page & also from 2nd page. for ex when i click on 2 checkboxes in 1st & change pageindex, again select one checkbox & again change pageindex to 1st then 2 checkbox in 1st page must be checked i.e their value must persist.
View 5 RepliesI have followed this article: [URL] ....
I have added textbox and checkbox in nested(child) gridview....
I have been stuck on this for a while and I can't seem to get it to work despite looking for answers in books and all over the web, so I hope perhaps you all can help me figure this out...
Here's what I'm trying to do....
I have some information in a simple product database displaying in a gridview table. One of the columns is a row of checkboxes indicating whether the item has been discontinued or not. When the row gets updated, it needs to update the checkbox value in the database.
1. It needs to be disabled until the row is getting edited.
2. Send the string value of 0 or 1 to the database when the row is updated.
Here's the code for the sql datasource and the gridview part in question...
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:sqlDataMaster %>"
ProviderName="<%$ ConnectionStrings:sqlDataMaster.ProviderName %>"
SelectCommand="SELECT ID, ProductName, ListPrice, Discontinued FROM Products"
UpdateCommand="UPDATE Products SET ProductName=@ProductName, ListPrice=@ListPrice, Discontinued=@Discontinued WHERE ID=@ID"
DeleteCommand="DELETE FROM Products WHERE ID=@ID">
<UpdateParameters>
<asp:Parameter Name="ID" Type="Int32" />
<asp:Parameter Name="ProductName" Type="String" />
<asp:Parameter Name="ListPrice" Type="Double" />
<asp:Parameter Name="Discontinued" Type="Boolean" />
</UpdateParameters>
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
<asp:Parameter Name="ProductName" Type="String" />
<asp:Parameter Name="ListPrice" Type="Double" />
<asp:Parameter Name="Discontinued" Type="Boolean" />
</DeleteParameters>
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AutoGenerateColumns="False" AllowSorting="True"
DataSourceID="SqlDataSource1" CellPadding="3"
GridLines="Vertical" BackColor="White" BorderColor="#999999"
BorderStyle="None" BorderWidth="1px"
DataKeyNames = "ID">
<Columns>
<asp:CommandField ShowSelectButton="True" ShowEditButton="true" ShowDeleteButton="true" />
<asp:BoundField DataField="ID" HeaderText="Product ID" SortExpression="ID" ReadOnly="true" />
<asp:BoundField DataField="ProductName" HeaderText="Product Name"
SortExpression="ProductName" >
<ItemStyle HorizontalAlign="Left" />
</asp:BoundField>
<asp:BoundField DataField="ListPrice" DataFormatString="{0:c}"
HeaderText="Unit Price" SortExpression="ListPrice" />
<asp:TemplateField HeaderText="Discontinued" ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<asp:CheckBox id="Discontinued" runat="server"
Checked='<%#Convert.ToBoolean(Eval("Discontinued")) %>' />
</ItemTemplate>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="#DCDCDC" />
</asp:GridView>
Here's a live version for you to look at...
http://homeworksite.mythandmagicstudios.com/homework4/proj3/default.aspx
I am posting this in the webforms section as I don't think I was clear on my last post. I am trying toinsert a gridview checkbox value to a database when I click the submit button. I have looked at dozens of examples but can't seem to put it together and I know this must be pretty simple.
View 28 Repliesi 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].....
I am using following code on SelectedIndexChanged of Dropdownlist in GridView for filling txtCallCompletion.Text. When i am selecting first time it is coming correct and i am changing value of txtCallCompletion then i am selecting second checkbox then previous checked checkbox's txtCallCompletion value will be same as it is.
how to solve this issue in gridview checkbox i already checked.
[code]....
Using Checkbox I m inserting gridview data into database. But I couldn't fill checkbox checked from database.
View 1 RepliesI was trying to find out if there are any check boxes checked in the datagrid, if non of them is checked it should show me an alert to select atleast one.
My problem starts when there is paging in datagrid...
not able to check the entire datagrid at a time in itemDataBound event for the checked check boxes.
how to set checkbox status Checked in gridview when in detabase column "type = Y" and when "type =N" that time checked is uncheked on rowdata bount of gridview
View 1 RepliesHere's part of my markup
<asp:TemplateField HeaderText="Approval" Visible="false">
<InsertItemTemplate>
<asp:CheckBox ID="Approved" runat="server"/>This must be checked to allow the insert.
</InsertItemTemplate>
Here's my code
[code]....
I have a datagrid which is bound to a stored procedure in the code behind. This works fine. But the datagrid contains a checkbox which I need to be default checked. First I didn't bind the checkbox and just used:
<ItemTemplate> <asp:CheckBox ID="chkSelection" Runat="server" Checked= "true" /> </ItemTemplate>
but they show as unchecked. then bound it using:
<ItemTemplate>
