Update SQL Server From GridView With A Checkbox
Feb 3, 2010
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 Replies
Similar Messages:
Apr 1, 2011
in 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();
View 1 Replies
Jun 3, 2010
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]....
View 4 Replies
May 5, 2010
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
View 2 Replies
Jan 27, 2014
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.
View 1 Replies
May 7, 2015
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].....
View 1 Replies
Mar 11, 2010
I 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
Dec 6, 2012
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 Replies
Dec 29, 2010
[Code]....
The select and update statements in my stored procedures are as follows:
[Code]....
Update tblNewArticle set Review_Status=@Review
[Code]....
View 6 Replies
Jun 12, 2012
bool isChecked = ((CheckBox)Gridview1.Rows[e.RowIndex].Cells[e.RowIndex].Controls[0]).Checked;
if (isChecked)
{ chk = 1; }
else
{ chk = 0; }
cmd.Parameters.Add("@check", SqlDbType.Int).Value = chk;
in the above code if i unslect the check box i get ischecked value=false & chk value=0 but on updating in sql tbl the value does not chnage.
View 1 Replies
Apr 29, 2010
I am using a GridView and a TemplateColumn in GridView, Now on selction of checkBox (header Template) I need to run server side function. When I am trying using chkSelectAll_CheckedChanged thenit is not executing also I am calling client side code on click of checkBox (header Template), which is used to select all checkbox in item template.Code Part of GridView (.aspx)
<asp:TemplateField HeaderText="Select">
<ItemTemplate>
<asp:CheckBox ID="chkDomain" runat="server" AutoPostBack="true" OnCheckedChanged="chkDomain_CheckedChanged" />
[code]...
View 4 Replies
Aug 20, 2010
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]....
View 9 Replies
Jun 29, 2010
I am dynamically binding a typed list to a GridView control.
The Grid View Control is in an asp.net page that is wrapped in an asp:UpdatePanel (Ajax).
The first column contains a checkbox control.
Only one checkbox may be checked in this column.
If the user checks a checkbox, all other checkbox must be unchecked.
I am trying to achieve this using client-side script without success.
In the handler for the GridView's RowDatabound event, have attempted to add an attribute to the CheckBox contained within the cell.
[code]....
View 2 Replies
Jul 25, 2010
I have GridView1 and SqlDataSource1. I use EnableEditing to GridView1. This is Code of GridView
<
asp:GridView
ID="GridView1"
Width="100%"
runat="server"
AutoGenerateColumns="False"
BackColor="White"
BorderColor="#3366CC"
BorderStyle="None"
BorderWidth="1px"
CellPadding="4"
DataKeyNames="DoctorID"
DataSourceID="SqlDataSource1">
<RowStyle
BackColor="White"
ForeColor="#003399"
/>
<Columns>
<asp:BoundField
DataField="DoctorID"
HeaderText="DoctorID"
InsertVisible="False"
ReadOnly="True"
SortExpression="DoctorID"
/>
<asp:BoundField
DataField="DoctorName"
HeaderText="DoctorName"
SortExpression="DoctorName"
/>
<asp:BoundField
DataField="City"
HeaderText="City"
SortExpression="City"
/>
<asp:BoundField
DataField="Str"
HeaderText="Str"
SortExpression="Str"
/>
<asp:BoundField
DataField="StrRegion"
HeaderText="StrRegion"
SortExpression="StrRegion"
/>
<asp:BoundField
DataField="StringLevels"
HeaderText="StringLevels"
SortExpression="StringLevels"
/>
<asp:BoundField
DataField="Streat"
HeaderText="Streat"
SortExpression="Streat"
/>
<asp:BoundField
DataField="Email"
HeaderText="Email"
SortExpression="Email"
/>
<asp:BoundField
DataField="Mobile"
HeaderText="Mobile"
SortExpression="Mobile"
/>
<asp:BoundField
DataField="HomePhone"
HeaderText="HomePhone"
SortExpression="HomePhone"
/>
<asp:BoundField
DataField="ClinicPhone"
HeaderText="ClinicPhone"
SortExpression="ClinicPhone"
/>
<asp:BoundField
DataField="Fax"
HeaderText="Fax"
SortExpression="Fax"
/>
<asp:BoundField
DataField="address_details"
HeaderText="address_details"
SortExpression="address_details"
/>
<asp:BoundField
DataField="Expr1"
HeaderText="Expr1"
SortExpression="Expr1"
/>
<asp:BoundField
DataField="VisitPlaceStr"
HeaderText="VisitPlaceStr"
SortExpression="VisitPlaceStr"
/>
<asp:CommandField
ShowEditButton="True"
/>
</Columns>
<FooterStyle
BackColor="#99CCCC"
ForeColor="#003399"
/>............
View 1 Replies
Jul 4, 2010
i have a datagrid in which i display a list of complaints lodged by some people. the fields displayed include Call Status, Call RefNo , Details Etc.. i have added a checkbox. the admin should be able to check complaints that he has read and then click on "Mark as read" and then the status of the complaint should change to "Pending" from "New" or from 0 to 1.
[code]....
View 4 Replies
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
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
Apr 15, 2010
I'm working on a simple demo project so that I can learn some things about ASP.NET's AJAX capabilities. My problem is that I can't seem to get an UpdatePanel to work properly with a CheckBox inside of it. Here is the markup I'm using in my .aspx file:
[Code].....
View 1 Replies
Apr 24, 2010
In Edit mode, when I check unchecked items, the Update works correctly, but when I clear the checked items, the items are still true in the database. My textboxes and dropdown lists all work as expected. The related code is below. Why won't the cleared checkboxes write to the db? When I set a breakpoint in the ContactRecordOnUpdating method, the values for the unchecked checkboxes are true (which is undoubtedly why they are written to the db that way).
[Code]....
View 3 Replies
Feb 24, 2010
I have a check box, RequiredFieldValidator and textbox that have editmask extender I want to change the control properties programmatically when I check the check box but the problem that nothing happened when I check it.
I made the control post back and I added triggers.
when put break point and go with code step by step will go through the code but nothing change.
<asp:UpdatePanel ID="UPanelContacts" runat="server">
<ContentTemplate>
<asp:Panel ID="PContactsInfo" runat="server" GroupingText="Personal Information"
BorderStyle="Dotted" Style="position: absolute; top: 103px; left: 221px; height: 468px;
width: 811px; margin-top: 69px;">
<asp:TextBox ID="txtHomePhone" runat="server" Style="top: 147px; left: 543px; position: absolute;
height: 22px; width: 128px" AutoPostBack="True" ></asp:TextBox>
<cc1:MaskedEditExtender ID="txtHomePhone_MaskedEditExtender" runat="server" CultureAMPMPlaceholder=""
CultureCurrencySymbolPlaceholder="" CultureDateFormat="" CultureDatePlaceholder=""
CultureDecimalPlaceholder="" CultureThousandsPlaceholder="" CultureTimePlaceholder=""......
View 10 Replies
Aug 9, 2010
From a user perspective, I can list of users in a grid with some associated checkboxes. When I click on a checkbox, I want to update the database straight away. No buttons involved.
I am new to MVC.
I am trying to work out if I can do this by using a BeginForm that wraps around each checkbox. It appears not, but how can clicking on a checkbox cause a POST?
Or maybe I can use a JQuery click or change event on the Checkbox? But in a grid the id for the checkbox is repeated, and I cannot get it to work even with 1 row of data.
The code below does not work. If I can get it to work, I need to send an AJAX post to call the method on the controller with the Model.UserId and the checkbox value;
<tr>
View 4 Replies
Jan 27, 2011
Using C# and sql server. I have a gridview which is populated using a sql query. I have 5 columns in the gridview ( projectid,project name,description,date,status). I'm using the Edit/update option that is available in the gridview to edit/update a user selected row. When I use this Text boxes appear. I want to have a drop down list for status instead of a text box with values Started,Inprocess,Complete, Inhold.
View 3 Replies
Oct 4, 2010
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]....
View 3 Replies
Aug 2, 2010
I have a simple Textbox for entering password and the checkbox named Show passowrd beside it. Textbox mode is Password by default. These controls are in the table and I am using Update panel on top of the table. My application framework is 2.0 and I am Using ASP.NET 2.0 AJAX Extensions.
Now When i write some text in the textbox and check the Showpassword chekbox then the checkbox event is not getting fired. when Second time i click it then the event is fired and text in the textbox is removed and the textbox mode is set to the SingleLine. This functionality I am achieving by writing a code in the CS File.
When I remove the Update panel then the event is fired correctly everytime, but when usign Update panel and some text in the textbox then i have to check the checkbox twice for the desired functionality.
View 3 Replies
Jan 4, 2011
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>......................
View 2 Replies