Forms Data Controls :: Changing A Checkbox To A Template Field Causing It To Pass A Null?
Jan 1, 2011
I've got a details view control on a page. One of the columns, from the database table, is a bit field. It is not nullable, and that's the way it has to be. Also, in most cases, when inserting data, it will be true (1) be default. I've found in testing, when inserting data, that it was false, for some reason. So, I changed the column to a template field and went to the InsertItemTemplate for that column, and changed the checkbox Checked property to True, instead of the default False. However, it has really screwed up the page because now it won't save anything at all! When I try saving something using the details view, it does show the checkbox as being checked, but man, once I try saving it I get an error message back from the database saying that the column doesn't allow for nulls.
Huh??? How in heck can the column on the page have a value (it is checked), but when it goes to save something it fails? Furthermore, before I converted this field to a template field, it worked perfectly. I tested several other insertions, and they all worked. But when I converted it to a template field, it stopped working? What's that about? I even tried setting the default value for the Checked property of the checkbox back to False, but that still doesn't work, it still wants to pass in a null. What's going on here? Why is it that converting a field to a template field, which was working perfectly fine before I made the convension, stop it from working at all?
View 4 Replies
Similar Messages:
Aug 12, 2010
When I change my insert update and delete buttons to template field....they do not work properly anymore. I get a "Cannot insert a Null Value into...blah blah blah, error.
View 2 Replies
Jun 11, 2010
I'm trying to remove a GridView Row if the user has checked a checkbox in that
[Code]....
row (the checkbox is in a template field), but I'm unable to actually remove that row from the GridView. Here's what I have, I think I'm getting the row index incorrectly...
View 5 Replies
Dec 22, 2010
have situation here. On checking checked checkbox inside template field on grid view. This my codethis code suppose to be update into mysql when checkbox of each row being checked. Mean only update database which row has being checked, other wise the data inside database not being updated.What happen now once button being click, code above will be executed, but all the data being update not considering the checked checkbox only.
[Code]....
[Code]....
View 6 Replies
Jun 10, 2010
I just wrote something small up with a GridView databound to the products table of the northwind database to play around with the control. I added a template field and put a checkbox in it, ProductID, ProductName, and UnitCost. I can successfully loop through the GridView and find the rows that have the checkbox checked, and can get ProductName for each row, but keep erroring out on ProductID and UnitCost. It's probably something small, but I just cannot figure it out.Here is what I have so far:
[Code]....
My code behind, where I handle a button click event to get all values in rows w/ selected checkboxes:
[Code]....
Can I not use row.Cells[i]? The only thing Intellisense gives me that makes any sense is 'rows.Cells[i].Text'... not sure what else to do.
View 6 Replies
Jun 15, 2010
I've created a databound gridview inside the gridview's RowDataBound I use the RowSpan property to merge cells. The grid ends up looking like this for example....
Data Data Data Button
Data Data Button
Data Data Data Button
Data Data Button
Data Data Data Button
The button is generated using a Template Field and is a standard ASP:Button. If I click a button in an unmerged row everything works as expected. If I click a button in a merged row...the sender object on the command comes back as null and no matter what I try I can't seem to fix it or get a reference to the button.
sender.CommandArgument
for example returns and empty string.
View 3 Replies
Nov 9, 2010
I have 5 gridviews, all of of them have a Checkbox template field. I already did SUM of a specific column in the gridviews and displayed the Total in the gridview footers.
There is a submit button on the page as well.(this is not in a template column in the gridview)
what i do is select some rows in the gridviews by ticking the checkbox. Then I click on the submit button and the values change in the database and page refreshes with the new Total in the gridview footers. Any row that was ticked. the checkbox for that row in the gridview gets disabled. so cannot change the value again.
Now i want a way to show a popup with a SUM of those rows that are ticked recently and the SUM of already ticked and disabled rows before the values change for the ticked rows in the gridview when the submit button is clicked.
View 8 Replies
Jul 31, 2013
i am implementing a update query module.i am displaying all fields from a table for a term searched. well now i am implementing update option for the record which are displayed, i have like 70 columns in my table, and i want to know how to restrict some selected fields to be only read only while the form can be updated ?Like if user select to update a record then some selected field such as "Timestamp, UID etc some selected fields" remains READ ONLY !
View 1 Replies
Sep 9, 2010
I have a gridview which the columns are created programmatically.
When a button is click i will clear all columns and add the columns that I want. Im adding a boundfield which is not a problem. When I add a template field, I must add also the item template which is my problem.
How can I add a item template in the template field I created which is binded in my datasource. Also what event handler should I use to do this.
Here's the part of my code:
[Code]....
Someone know how can I bind a label item template from the datasource. The label item template should be firstname + middlename + lastname.
If im not doing it programatically, it will be just concatenating eval(). But how can create item template and bind it programmatically?
View 3 Replies
Dec 4, 2010
Setting up the editItem template of a gridview. I have a template field with a dropdown list for editing. When the gridview goes into edit mode the dropdown list is displayed with all the right options but the current value of the field (pre-editing) is not the selected value of the dropdown list? How do I make that happen? I have a couple fields where the editItem template will use a dropdown list and I'm sure a user will not realize those values have changed and they will just edit what they intended to edit and save the changes, inadvertently also making changes to other fields.
View 3 Replies
Apr 22, 2010
I am using a GridView Control to display multiple fileds with 0's and 1's.
I am using template fields where CheckBoxes are used.
Where exactly and how do I apply the Logic to get a checked CheckBox when field Value=1 and unchecked CheckBox when field Value=2 .Also some times to be able to write a YES where fieldValue=1 or NO where filedValue=0
Do I apply this logic using asp or C#? How?
View 2 Replies
Apr 1, 2011
I have a DetailsView on the page and I have made one of the fields a TemplateField. In the EditItemTemplate and InsertItemTemplate I have a DropdownList that is databound to a table in my Sql Server database. I wanted to add an initial value to the DropdownList
namely "- select -" .
I set the AppendDataBoundItems property to true and added the initial value as a ListItem.Markup of the DropdownList
<asp:DropDownList ID="DropDownList_HP" runat="server"
AppendDataBoundItems="True" DataSourceID="SqlDataSource_HP" [code]...
This works fine for new input. The problem is however that the database already has records that were entered through a Windows Application and many of these records has a null value in this field and exceptions are thrown when I tried to open these records
and the system tried to set the SelectedValue of the DropdownList.After some more searching I found this help
http://msdn.microsoft.com/en-us/library/ms366709.aspx
So I changed the ListItem in the DropDownList markup to the following:
<asp:DropDownList ID="DropDownList_RefHospDV4" runat="server"
AppendDataBoundItems="True" DataSourceID="SqlDataSource_RefHosp" [code]...
This now solved the problem of opening a record where the value is null in the database, BUT now the RequiredFieldValidator is not validating anymore to make sure that a databound item is selected for this field and not the initial value "- select -". So basically now it is not checking anymore to see if valid input has been entered for the DropDownList and it accepts "- select -" thus it acts as if the field is not a required field anymore.
In short what is required is that I want to make sure that the user enters a valid selection in the DropDownList, but it must also cater for old records that do not have this field entered yet so that those old records can be opened in the DetailsView .Opening Old records (with null in that field):When these old records are opened in the DetailsView the DropDownlist should show "- select -" when the value in the database is null.
Saving records (old or new records):When saving the record in Insert mode or Update mode the RequiredFieldValidator should show that a valid input is not selected if the DropDownList is still on "- select -".
View 1 Replies
Sep 13, 2010
I have a checkbox template field in a grid view control. I want to execute some code when a checkbox is checked or unchecked - how do I do this? Which event is fired?
View 1 Replies
Aug 14, 2010
First off, sorry if this is in the wrong section. I have a gridview that loads from a SQL database. It has three columns, the first being a template column with a checkbox, the second being a name from the database, and the third being a field from the database related to that name. (the third column is empty). I want to be able to click on the check box in each row, and automatically have the third column populate with data that the user can select from a drop down list at the top of the screen or something. I am using VB, and I basically just need a way to make this checkbox, add a value from somewhere into the database. (Also, I know that I can just use Edit in the gridview to change data, but there will be a long list, and that way gets quite time consuming) I hope this makes sense, if not I can try rewording it.
View 5 Replies
Jan 31, 2011
I'm using listview with datapager.
when I'm trying to change the page if an item is in edit mode, the item with same row number in other page is opening in edit mode.
View 4 Replies
Dec 6, 2010
I am trying to edit data using checkbox value. Firstly, I created popup window which using querystring some data from main page. In popup window, I want to change the checkbox value. For example, I made setSpare column and given the value to show bit data type such as 0 or 1 using checkbox(false or true). If some data has non setSpare(means 0), it wil lbe come out uncheckbox. If I want to check it and clicking submit button, It was not change. I am going to show the code below.
public partial class AddSpare : BasePage
{
string ObjectId;
protected void Page_Load(object sender, EventArgs e)
{
ObjectId = Request.QueryString["ObjectId"];
displayComInfo(ObjectId);
}
protected void displayComInfo(string ObjectId) // it informed relative data on web through using DB.
{
string query = "usp_ShowComputerList";
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SCSConnectionString2"].ConnectionString))
{
SqlCommand cmd = new SqlCommand(query, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter paramobjectId = cmd.Parameters.Add("@ObjectId", System.Data.SqlDbType.Int);
paramobjectId.Value = ObjectId;
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
ModelTxt.Text = dr["Model"].ToString();
ModelTxt.ReadOnly = true;
ComputerTxt.Text = dr["ComputerName"].ToString();
ComputerTxt.ReadOnly = true;
userTxt.Text = dr["UserName"].ToString();
userTxt.ReadOnly = true;
ntTxt.Text = dr["NtLogon"].ToString();
ntTxt.ReadOnly = true;
HDDTxt.Text = dr["HddSize"].ToString() + "GB";
HDDTxt.ReadOnly = true;
RAMTxt.Text = dr["MemorySize"].ToString() + "GB";
RAMTxt.ReadOnly = true;
SerialNoTxt.Text = dr["SerialNo"].ToString();
SerialNoTxt.ReadOnly = true;
TextBox1.Text = dr["Spare"].ToString();
inputChkSpare.Checked = (bool)dr["Spare"]; //(bool)dr["Spare"] display false or true.
dr.Close();
}
}
}
catch (Exception ex)
{
MessagePanel1.Type = MessageType.Error;
MessagePanel1.Text = MessagePanel1.Text = "This is an error." + ex.Message;
}
}
protected void okBtn_Click(object sender, EventArgs e)
{
string query = "usp_SetSpare";
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SCSConnectionString2"].ConnectionString))
{
SqlCommand cmd = new SqlCommand(query, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter paramobjectId = cmd.Parameters.Add("@objId", System.Data.SqlDbType.Int);
SqlParameter paramspare = cmd.Parameters.Add("@spare", System.Data.SqlDbType.Char);
paramobjectId.Value = ObjectId;
if (inputChkSpare.Checked == true) // if I change the check box, it does not bring the changed value. It will bring the above value(already displayed thing)
{
paramspare.Value = "1";
}
else {
paramspare.Value = "0";
}
conn.Open();
cmd.ExecuteNonQuery();
cancelBtn.Value = "Close";
okBtn.Enabled = false;
MessagePanel1.Type = MessageType.Information;
MessagePanel1.Text = "This computer is spare from now.";
}
}
catch (Exception ex)
{
MessagePanel1.Type = MessageType.Error;
MessagePanel1.Text = MessagePanel1.Text = "This is an error." + ex.Message;
}
}
View 2 Replies
Nov 11, 2010
I'm putting together a page that allows the user to enter a new record in an SQL table. A bunch of the fields in the table are bit datatypes. I want to use CheckBoxes to correspond to the bit datatype columns in the SQL table.
How do I bind the checkboxes to the SQL table columns?
Here's what I have, not sure if this is right:
[Code]....
View 1 Replies
Jan 6, 2010
I have a gridview control
i add template column dynamically to gridview
like this in a function in AddColumns button clickevent
gv.Columns.Clear()
Dim chkCol As New TemplateField
chkCol.ItemStyle.Width = 20
chkCol.ItemStyle.HorizontalAlign = HorizontalAlign.Center
gv.Columns.Add(chkCol)
2)
and in row databound event i added checkbox control to this template field. like this
Protected Sub gv_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles gv.RowDataBound
If e.Row.RowType = DataControlRowType.DataRow Then
Dim chkbox As New CheckBox
chkbox.ID = "chkSelect"
e.Row.Cells(0).Controls.Add(chkbox)
End If
End Sub
HERE I WANT TO GET CHEKC BOX IN btnok click event
Protected Sub btnOk_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnOk.Click
Dim linkId As String
Dim summary As String = ""
'Enumerate the GridViewRows
For index As Integer = 0 To Me.gv.Rows.Count - 1
'Programmatically access the CheckBox from the TemplateField
Dim cb As CheckBox = CType(gv.Rows(index).Cells(0).FindControl("chkSelect"), CheckBox)
If cb IsNot Nothing Then
If cb.Checked Then
linkId = Me.gv.DataKeys(index).Value
End If
End If
Next
Me.Page.Title = linkId
End Sub
But here i am not getting Check box even i used find control. how i get checkbox
View 8 Replies
Oct 20, 2010
I want to populate a detailsview cell by a value from a drop'dn list(based on values from another table).
View 4 Replies
Feb 10, 2011
<Columns>
Template field is not working in 4.0?
View 1 Replies
Mar 10, 2010
I'm trying to figure out what I'm doing wrong with my code. If I use the code below in a non-masterpage aspx page with <head><body><div> tags it works with no problem. Code that works:
[Code]....
View 2 Replies
May 18, 2010
I have a template field in a Details View which is a dropdown selection of values.While I can get the value of the textfields in the DetailsView by using: DetailsView1.Rows(i).Cells(1).Text.ToStringI don't know how do extract a value from a dropdownlist2 contained in the DetailsView.
View 4 Replies
Dec 28, 2010
I have a Details view where I want to have a multi-select value, with the choices driven from another table.I need to iterate through the check-boxes in the list, and I do that by using a DetailsView1.FindControl("MyCheckBoxList") to find the check box list.The challenge I'm having now is that if I name the CheckBoxList differently in each of the templates (Item, Edit, Insert), then they each need a separate handler to find the control and iterate through the checkboxes. I can't find a method to fire a handler
View 2 Replies
Mar 10, 2010
I ran into this problem I'm sure someone else has similar encounter with, but just couldn't find a solution for it!
I want to disable few entries in the dropdownlist that's in the template field, depending on the value in BoundField when the gridview is being populated.
Below is my attempt:
[Code]....
JobStatus is the dropdownlist in the template field, and Status is the boundfield. In run time, the bolded line causes below exception: Object reference not set to an instance of an object. which I think is wingeing about null variable. Perhaps the templatefields are created after RowDataBound event?
View 2 Replies
Dec 1, 2010
I'm not sure how to do this, but I did read a lot of post and searched for it.
Protected Function GetTotal(ByVal DonTotalQty As Decimal, ByVal DonValue As Decimal)
View 5 Replies
