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]....
i got a problem to update my database which i bounded to datagrid. The problem is, i want to update my database only by clicking one update button at the bottom.. when the user click it, all the fields will be updated to database.
View 3 RepliesThis 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 just developing my web design skills.
I have a Datagrid with 2 textbox template columnsand two checkbox template columns. I have two other Textbox controls and two CheckBox controls. I have an Add button.
I want to be able to use the add button to update Datagrid Record inserting the Textbox control texts and the Checkbox Control status.
I have take a datagrid view and now i want to update the records as the database is been normalized i need to enter the multiple rows at once. How you I convert the datagrid to enter the data so that it would be easy for me to update the records?
View 1 RepliesFrom 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>
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.
This code works fine if i use this inside ssercontrol > panel and i have a checkboxes in table when no checkbox is checked its works fine .... but if i disabled and checked any of the textbox then this doesn't work .... in usercontrol why ? i didnt understand ..
<script type="text/javascript" language="javascript">
function checkboxChecked(){
var allInputs = document.getElementsByTagName("input");
for(var i=0; i<allInputs.length; i++) {
var chk = allInputs[i];
if(chk.type == "checkbox" && !chk.disabled && chk.checked) {
return true;
}
}
alert("OOps! You haven't selected all available checkboxes");
return false;
}
</script>
I have a datagrid and there is a checkbox which is template in each row. Suppose I am in CheckedChanged event of one of the checkboxes. Is there any way I can tell in which row of the datagrid that check box is in?
View 3 Repliesi m having one datagrid...that have one check box field...whenever i check the check box that time that row will be inserted in database...but check box value is not set true value...it always return false value...i m using C# asp.net 2003 version
View 2 RepliesI have a BING MAP in web app. which is of JavaScript or Jquery. And also I have a DataGrid in same page. Data Grid is populated with Address ROWS. A check box is also there as ItemTemplate for DataGrid.
Now after dataGrid binded with data source, and when user clicks on check box, that particular address should show on BING MAP.
My question is,
How to invoke a JavaScript function when user checks checkbox in data grid. Which data Grid events suits my scenario? Also can I do this on client side without going to server side and call JS function?
I have a project in VB.NET which is working fine which essentially has a Datagrid that has a TemplateColumn included which is a column of Checkboxes. The code to declare the datagrid is here...
<asp:datagrid id="dgDates" OnItemCommand="gridEventHandler" BorderColor="Black" BorderWidth="1px"
CellPadding="3" runat="server" AutoGenerateColumns="False" HorizontalAlign="Left" AllowSorting="True"
OnSortCommand="SortData" OnItemDataBound="gridItemDataBound">
<HeaderStyle Font-Underline="True" Font-Bold="True" HorizontalAlign="Center" ForeColor="Black"
BackColor="#D4D0C8"></HeaderStyle>
<Columns>
<asp:BoundColumn DataField="strParameterName" SortExpression="strParameterName" HeaderText="Parameter Name"></asp:BoundColumn>
<asp:BoundColumn DataField="dtParameterValue" SortExpression="dtParameterValue" HeaderText="Parameter Value"></asp:BoundColumn>
<asp:TemplateColumn HeaderText="Constant" SortExpression="blnStatic" ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<asp:CheckBox ID="cbStaticRolling" Checked="False" Runat="server" AutoPostBack="true"></asp:CheckBox>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
as you can see the Checkbox has Autopostback="true" but there are other things on the page which produce postbacks as well.
My Page_load has this in it, being called on every load of the page, postbacks included...
Dim strGUID As String
strGUID = Session("strGUID")
dgDates.DataSource = SqlHelper.ExecuteDataset(ConfigurationManager.AppSettings(Web. [Global].CfgKeyConnStringADMIN), "dbo.spRptGetSchedulingDates", strGUID)
dgDates.DataBind()
intNumberOfDates = dgDates.Items().Count
as well my code behind has the following code for the gridItemDataBound
Protected Sub gridItemDataBound(ByVal sender As System.Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs)
'hide the intRptSchedulingDatesID for each row in the checkbox's content style variable
If (e.Item.ItemType = ListItemType.Item Or e.Item.ItemType = ListItemType.AlternatingItem) Then
CType(e.Item.FindControl("cbStaticRolling"), CheckBox).Style("Content") = CType(e.Item.DataItem, System.Data.DataRowView).Item("intRptSchedulingDatesID")
End If
End Sub
everything you see sbove is working perfectly fine...in the sense that when I click one of the checkboxes, the page_load fires, the gridItemDataBound fires on DataBind() and when all is done, the checkbox retains the value that the user clicked the checkbox.
With all this exact same code converted to C#....the events all fire in the same order, but the checkbox selected value always clears...any thoughts??
I have checkbox in datagrid. I m getting the right data from database. As my database is oracle, I m unable to boolean. so, I m using char value to store checkbox value.I m getting the right checkbox value but when I m trying to update checkbox, its just post back but it is not storing correct value.
I have a datagrid which retrieves particular columns from an SQL database table. I also have a checkbox appended on to each row, so that selections can be made against rows of the users choice (i.e. select photos to add to favorites).
How can I code this (in VB.NET) so that these checkboxes are processed sequentially? I have heard an "array" might be best for this, but don't know how to code it. Essentially, I want the VB.NET to look through the datagrid list and to process only those rows with checkboxes checked, by applying some SQL based on these selections.
I 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.
[Code]....
how to proceed ?? in this case ??
I am making checkbox in datagrid, no matter what I try, I cannot get the right result from checkbox. Even I check or not check the checkbox, the result is false. It is like somehow the result is always the default value of the checkbox.
Here is code:
private void OrderButton_Click(object sender, System.EventArgs e)
{
CheckBox x;
foreach ( DataGridItem dgItem in DataGrid1.Items)
{
x = (CheckBox)dgItem.FindControl("OrderCheckBox");
this.ALERT(x.Checked.ToString());
}
}
And here is my html:
[Code]....
Im basically listing a set of facilities in a datagrid. Like so:b Projectorcb Laptopcb TelevisonIn roomview, a check appears where a facility is availble in a room. This part works fine.The user can then edit the facilities, by clicking on the check beside each facility. When the update button is pushed I need to record the value of the checkbox, however I cant get the value of the checkbox.eres my codebehind:
[Code]....
I have an AJAX accordion from the ajax control toolkit on a page with a datagrid inside on of the panels. I have a custom itemtemplate for the one column to create a multiline textbox when I click edit on the row. When I click update on the row, the original content of the textbox gets rendered into the textbox. It is supposed to update and go back to the literal not the textbox. When I put the DataBind() into a !IsPostBack, it doesnt get rendered when I click on the accordion pane.
[Code].....
I have a page that has a datagrid on it and using inline update functionality and when I click the edit link, update text and click update link it updates fine but I put an email function in and I see two emails being sent. why it runs twice?
HTML Code:
<%@ Page Title="Courses" Language="VB" MasterPageFile="~/themes/admin.master" AutoEventWireup="false" CodeFile="courses.aspx.vb" Inherits="admin_courses" %>
<asp:Content ID="Content1" ContentPlaceHolderID="cphHead" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="cphHeader" Runat="Server">
</asp:Content>
[code]....
how to delete and update in datagrid on OnDeleteCommand and OnUpdateCommand.
View 1 RepliesI am using the following code to update the data in my datagrid.
But when I click update the value is updated in the database but it still shows old value in datagrid.
If I refresh the page after that then datagrid shows the updated value.
Code On Update Command:
protected void MySQLDataGrid2_UpdateCommand(object source, DataGridCommandEventArgs e)
{
string newData;
TextBox aTextBox;
aTextBox = (TextBox)(e.Item.Cells[0].Controls[0]);
newData = aTextBox.Text;
decimal comm = Convert.ToDecimal(newData);
string UpdateHiveCommission = "Update tbl_HiveCommission set Commission = '" + Convert.ToDecimal(newData) + "'";
MySqlConnection objMyCon3 = new MySqlConnection(strProvider);
objMyCon3.Open();
MySqlCommand cmd3 = new MySqlCommand(UpdateHiveCommission, objMyCon3);
cmd3.ExecuteNonQuery();
objMyCon3.Close();
MySQLDataGrid2.EditItemIndex = -1;
MySQLDataGrid2.DataBind();
}
I have datagrid, View details button on the datagrid. If I click on the button, It will redirect to another page with all the details. I have update button and return button on that page. If I click on update, It will update data in the database. If I click on the return button, It will return to previous page which has datagrid but I want the update details in the datagrid. I have a big doubt, how to store that datagrid so that we can retrieve data on return button
View 7 RepliesI have a site which displays data form a MSAccess 2003 database in a DataGrid. For simplicity sake the data is products ie an ID, Name, Description and a value representing the amount in stock.I want to allow the user to update the stock field via the datagrid but not be able to change any of the other fields. Is this possible?
View 5 Replies