I have a gridview with a checkbox field. I would like for the user to be able to the row with a single click of the checkbox instead of having to click the edit button. How can I accomplish this?
[Code]....
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
Below is my database structure
idnamework
1manojdevelopingcheck box
2munatesting check box
3kanakadatabase check box
Here I want to assign the above database work to my team members. When I check the above check box and press assign button ,it shows in another page means the gridview selected row shows in another grid in another page .
And once i check any check box and assign , automatically the checked row vanished from my grid view.
I am using your post on the use of check boxes with the gridview control. I need to be able to update each row checked.
View 1 RepliesI have a gridview on my page. I have a checkbox in each row of this gridview. For each checkbox in the gridview, I'd like to update my table accordingly, but I don't want them to have to hit a submit button every time they check the checkbox. I want them to check all the boxes they need to and at the end, they should hit one submit button.
View 12 Replies[Code]....
The select and update statements in my stored procedures are as follows:
[Code]....
Update tblNewArticle set Review_Status=@Review
[Code]....
I want to select all checkBox in Gridview when click to header checkBox.I have created design such that CheckBox is not available to header of Gridview.It is in other table. Below is design of gridview.
[Code]....
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].....
on page load I fill a repeater with checkboxes. I use a separate tablelist (subcatID & userID) to check if chkbox is checked or not.
On pageload and works fine (according boxes are checked):
[Code]....
When submitting the adapt button .. nothing happens and I can't figure out why ..
[Code]....
I am very new to updating the datasource using ObjectDatasource. I have a checkbox on click of update the update method triggers but though teh check box is checked, the value is updated as false.
<asp:TemplateField HeaderText="IsPrimary" SortExpression="IsPrimary">
<EditItemTemplate>
<asp:CheckBox runat="server" ID="chkIsPrimary" Checked='<%# Eval("IsPrimary") %>' />
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Remarks">
<EditItemTemplate>
<asp:TextBox ID="txtRemarks" runat="server" SkinID="longTextBox" TextMode="multiLine"
Text='<%# Bind("Remarks") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>......................
in a grid view i have a checkbox column ,which is making checked based on the char value from the SQL DB.
In SQL DB field type is char(1).
My requirement is , need to pass "Y" if checkbox is true ,and "N" if checkbox is false.How to pass that parameter in an update statement.
How it is possible?I used the parameter like as follows.But it is giving me an error when i click update.Groupid parameter is working perfect.The error is coming from the "HPermission" parameter.
<asp:BoundField DataField="GroupID" HeaderText="GroupID" InsertVisible="False" ReadOnly="True" SortExpression="GroupID" />
<asp:TemplateField HeaderText="Hud" >
<ItemTemplate>
<asp:CheckBox ID="chkStatus1" runat="server" AutoPostBack=false
Checked='<%# Convert.ToBoolean(Eval("HPermission").ToString().Equals("Y")) %>'
/>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
UpdateCommand="exec [dbo].[GridUpdDel] @GroupID,@HPermission,'UPDATEPERMISIION',0,'',''" >
<UpdateParameters>
<asp:Parameter Name="GroupID" />
<asp:Parameter Name="HPermission" />
</UpdateParameters>
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.
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]....
<asp:TemplateField>
<ItemTemplate>
<asp:CheckBox ID="chkRDR1" runat="server"/>
</ItemTemplate>
</asp:TemplateField>
=========================================================================================
Dim checkbox As CheckBox = CType(row.FindControl("chkRDR1"), CheckBox)
table a
a1 a
1 qw
2 asa
i have two grid views
gridview1 has check box[a1] and one value[a](in total two columns) with objectdatasource1 for datareferencing from database
another gridview2 has to select only the selected/checked value of gridview1 of checkbox1
I want to update multiple rows of gridview (only price field. for that i have added textbox) on click of update button which is outside of gridview.I have done following way
<asp:LinkButton ID="lnkUpdate" CssClass="BlueButton" runat="server" OnClick="lnkUpdate_Click">Update</asp:LinkButton>
[Code]....
Up to this its working fine but when no textbox updated then no need to go in for loop so i am looking for confiramtion before updating rows please help me how to do that becausei am less aware with javascript. another problem is textbox value disappear when page index changed how i can retain that values.
[Code]....
When i try to update a row using the update functionality of Gridview it updates all the rows rather then updating that specific row which is in edit mode.
[Code]....
anyone got idea on how to create a gridview with checkbox?
View 3 RepliesI have Grid view on my WebForm, a Checkbox placed in a Grid view,i have 70 field/column values right below grid view,when ever i select the GridView Checkbox ,entire record should be displayed in field/column values.How can i acheive this please provide
I'm a little bit confused. I'm trying to pass in some values to the associated database table from a gridview.I have a databound gridview fetching values from a database, on each row a checkbox is generated to each item in the list. For exapmple, the gridview fetches data from the table "Interests" and prints it out on the page, and the visitor is supposed to check in those checkboxes that corresponds to his/hers personal interests.When clicking submit, the Table UserInterests in DB gets the values:
UserID = 1 (gets a unique ID from a previous step)
InterestID = 45 (Shopping)
UserInterestID = (auto increment)
What i need help with is how to check if the Checkboxes is checked or not, and how to pass in the true or false to the db.I have read Step 2 in this tutorial, and it seems like my solution will be somewhat similair to this:http://www.asp.net/Learn/data-access/tutorial-52-cs.aspxKnow it's a tricky question when not knowing the structure of the project, but i'll be glad for some pointers and tips!
I have a gridview with autogenerated fileds in Rowdatabound i am adding checkbox using stringwritter then when i try to get checkbox value using Findcontrol it shows me an errorBelow the code samples which i have used .aspx
<asp:GridView ID="GridView1" runat="server"></asp:GridView>
.CS
[Code]....
There is a GridView with a Checkbox field on the page. And there is a button on the same page. There is a field which is related to the checkbox in the sql. Is there any simple way to update the sql? Not row by row.
View 2 Repliesin my project i use chekbox list...but while m get update from gridview i can't get chek chekbox.
SqlConnection Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ims"].ConnectionString);
Conn.Open();
DataSet ds1 = new DataSet();
string querry = "Select po_tax from purchase_order where po_id='" + Request.QueryString["po_id"] + "'";
// ds1 = obj1.SelectQuery(querry);
SqlCommand cmd = new SqlCommand(querry,Conn);
cmd.ExecuteNonQuery();
SqlDataReader rdr;
rdr = cmd.ExecuteReader();
if (rdr.Read() == false)
{
//No Records
rdr.Close();
Conn.Close();
Label3.Text = "No record found";
return;
}
else
{
CheckBoxList chkbx = (CheckBoxList)form1.FindControl("CheckBoxList1");
rdr.NextResult();
if (rdr.IsClosed == false)
{
while (rdr.Read() == true) [problem ocures here. it does not executes i.e does not go inside curly braces. why?]
{
ListItem currentCheckBox = chkbx.Items.FindByValue(rdr["po_id"].ToString());
if (currentCheckBox != null)
{
currentCheckBox.Selected = true;
}
}
}
rdr.Close();
//string[] items = returned_value_from_db.Split(',');
string[] items = sb.ToString().Split(',');
for (int i = 0; i <= items.GetUpperBound(0); i++)
{
ListItem currentCheckBox = chkbx.Items.FindByValue(items[i].ToString());
if (currentCheckBox != null)
{
currentCheckBox.Selected = true;
}
}
}
Conn.Close();
can i add commandname or commandargument to a checkbox-control in a gridview?
View 5 Replies