i 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 Replies
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.
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.
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 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 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'm currently working on a small project and therefore created a gridview, including one bit column which has been linked with a checkbox in both the itemtemplate as the edititemtemplate (autopostback = true).Databinding for these two checkboxes has been linked (two-way) to the bit column.Now I want to display the gridview to end-users. They should be able to just click on the checkbox so they value in the database column gets changed as well (as I want to run update queries behind it), but not passing via the command column 'EDIT'.=> problem I'm having now is that the bit column in the database doesn't get updated.
View 3 RepliesI 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]....
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.
Here is my code. I just wanted to update one column. Why is everything getting NULL put into it?
[Code]....
[Code]....
how to get hidden column value in gridview in asp.net
View 3 Repliesdear all im working in website in arabic lang "RTL" and im using datapager and i want numbers appears frm RTL "right to left"
View 3 RepliesFor dates, we have AJAX Calendar control.However, for time input, what kind of assistance we can get from ASP.Net ?The only way I can use is dropdown list but it is not so good.
View 4 Repliesi create stored procedure to link my table and select data from multiple table then i create dataset and set this dataset as datasource for report in this report i use chart control but and i set the darg th column i want to be draw in data fileds but the only avilable value for this column must be aggregation function when i try to change it to be =Fields!Result.Value it didn't ,also i set point lable check box to be visible and i set the data label to be =Fields!Result.Value it works why? also i create the same report in report builder it work correctly....why?
note that when i prees at the arrow beside value fileds the follownig fields are available?
but when i press this arrrow when trying to set the data label the following fields appear ? the same report with the same data and i set the value filed to = fields!Result.value it work correctly?
I have a calendar control that sits inside a gridview and when i insert into the sql db it inserts the defaults of 111900, how can i insert Null instead of the default date.
Protected Sub lnkSubmitDental_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles lnkSubmitDental.Click
Dim userlogon As String = Split(Current.User.Identity.Name, "")(1)
[code]...
Assume in my table named school has a column named StudentNo
I try this script
select * from school where StudentNo <> 'AA'
I just wondering why this where clause "where StudentNo <> 'AA' always return false when StudentNo is null?
I have two entity in database: Laboratory & City, which has a relation.
In grid I want to show list of laboratory, so if I have BoundFields, binding works good:
[Code]....
Binding not working, and I see nothing in field with City.Id.
How to write custom required filed validator (or) JavaScript for the following Issue
For example
I've a Radiobuttonlist & Textbox
- One
- Two
- three
- four
- None of the above
If I select One/Two/Three/Four from Radiobuttonlist I must enter some comments in the Textbox else If I select "None of the above" No need to enter comments in the Textbox How?
im making a details page but i want to add another filed on the detailsview i want the url of the page to have 2 parameters, one for the datasource of the detailsview and one for the field i want to add how can i accomplish that? for example:
accountd.aspx?id=12&ammount=50,00
and then the detailsview will have the details of account 12, and one more field that has value 50,00
