I've posted this some place else but have not heard from anyone and hoping I get better luck here.
Note: Sorry about the formating, not sure what happened.
[Code]...
[Code]...
[Code]...
[Code]...
I have a formview with both edititem template and item template as following:
<asp:FormView ID="PFTFormView" runat="server"
DataKeyNames="PFTId"
EnableModelValidation="True" Width="90%"
OnItemUpdating="PFTFormView_ItemUpdating"
onmodechanging="PFTFormView_ModeChanging" >
<EditItemTemplate>
<table>
<tr><td class="style1">PFTId</td><td class="style3"><asp:Label ID="lblPFTId" runat="server" Text='<%# Eval("PFTId") %>' /></td></tr>
<tr><td class="style1">Last Name</td><td><asp:TextBox ID="txtPFTLastName" runat="server" Text='<%# Bind("PFTLastName") %>' Width="200px" /></td></tr>
<tr><td class="style1">First Name</td><td><asp:TextBox ID="txtPFTFirstName" runat="server" Text='<%# Bind("PFTFirstName") %>' Width="200px" /></td></tr>
<tr><td class="style1">Home</td><td><asp:TextBox ID="txtPFTHome" runat="server" Text='<%# Bind("PFTHome") %>' Width="200px" /></td></tr>
</table><br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True"
CommandName="Update" Text="Update" />
<asp:LinkButton ID="UpdateCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel" Text="Cancel" />
</EditItemTemplate>
<ItemTemplate>
<table>
<tr><td>PFTId</td><td><asp:Label ID="lblPFTId" runat="server" Text='<%# Eval("PFTId") %>' /></td></tr>
<tr><td>Last Name</td><td> <asp:Label ID="lblPFTLastName" runat="server" Text='<%# Bind("PFTLastName") %>' /></td></tr>
<tr><td>First Name</td><td><asp:Label ID="lblPFTFirstName" runat="server" Text='<%# Bind("PFTFirstName") %>' /></td></tr>
<tr><td>Home</td><td> <asp:Label ID="lblPFTHome" runat="server" Text='<%# Bind("PFTHome") %>' /></td></tr>
</table><br />
<asp:LinkButton ID="EditButton" runat="server" CausesValidation="False"
CommandName="Edit" Text="Edit" />
</ItemTemplate>
</asp:FormView>
on my code behind, I have:
Sub PFTFormView_ItemUpdating(ByVal sender As Object, ByVal e As FormViewUpdateEventArgs)
Dim PFTObj As New PFT
Dim PFTDST As New Data.DataSet
Dim newPFTLastName As String = DirectCast(PFTFormView.FindControl("txtPFTLastName"), TextBox).Text
Dim newPFTFirstName As String = DirectCast(PFTFormView.FindControl("txtPFTFirstName"), TextBox).Text
PFTObj.PFTLastName = newPFTLastName
PFTObj.PFTFirstName = newPFTFirstName
PFTObj.PFTHome = DirectCast(PFTFormView.FindControl("txtPFTHome"), TextBox).Text
If PFTObj.UpdatePFT(Session("PFTId")) Then
Me.lblErrorMessage.Text = "PFT Update Successfully"
Else
'
Me.lblErrorMessage.Text = "PFT Update UnSuccessfully"
End If
PFTDST = Nothing
PFTObj = Nothing
end sub
The problem is:
PFTObj.PFTLastName = newPFTLastName
PFTObj.PFTFirstName = newPFTFirstName
PFTObj.PFTHome = DirectCast(PFTFormView.FindControl("txtPFTHome"), TextBox).Text
are not returning the updated value from the form.
I have a FormView that I user for updating a record. There is a link button that when fires should perforom the updating via BLL and DAL. I am not using built-in ODS and I will not condsider using it. I have all my grids and formviews populated manuualy by calling methods that fetch the data from the database. For instance my details view is populated like this:
protected void DlMembers_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName.ToString() == "Select")
{
DlMembers.Visible = false;
lblError.Text = string.Empty;
lblError.Visible = false;
fvMemberDetail.Visible = true;
fvMemberDetail.ChangeMode(FormViewMode.Edit);
MemberBLL getMemberInfo = new MemberBLL();
int Ident = Convert.ToInt32(e.CommandArgument.ToString());
fvMemberDetail.DataSource = getMemberInfo.GetMemberByIdent(Ident);
fvMemberDetail.DataBind();
}
if (e.CommandName.ToString() == "DeleteSelected")
{
DlMembers.Visible = true;
lblError.Text = string.Empty;
lblError.Visible = false;
fvMemberDetail.Visible = false;
fvMemberDetail.ChangeMode(FormViewMode.ReadOnly);
}
What I want to do if to capature my linkbutton on click event and do this (except that the runtime never reaches this method):
protected void MemberInfoUpdating(object sender, EventArgs e)
{
TextBox id = (TextBox)fvMemberDetail.FindControl("txtIdent");
if (id.Text != string.Empty || id.Text != "")
{
TextBox txtFN = (TextBox)fvMemberDetail.FindControl("txtFN");
TextBox txtLN = (TextBox)fvMemberDetail.FindControl("txtLN");
DropDownList ddlAddress = (DropDownList)fvMemberDetail.FindControl("ddlAddress");
TextBox txtEmail = (TextBox)fvMemberDetail.FindControl("txtEmail");
TextBox txtHPhone = (TextBox)fvMemberDetail.FindControl("txtHPhone");
TextBox txtWPhone = (TextBox)fvMemberDetail.FindControl("txtWPhone");
TextBox txtMPhone = (TextBox)fvMemberDetail.FindControl("txtMPhone");
DropDownList ddlPos = (DropDownList)fvMemberDetail.FindControl("ddlPos");
DropDownList ddlIsAdmin = (DropDownList)fvMemberDetail.FindControl("ddlIsAdmin");
bool blIsAdmin = false;
if (ddlIsAdmin.SelectedValue == "True") blIsAdmin = true;
TextBox txtComments = (TextBox)fvMemberDetail.FindControl("txtComments");
MemberBLL updateMemberInfo = new MemberBLL();
bool UpdateOK = updateMemberInfo.UpdateMemberByIdent(
txtFN.Text,
txtLN.Text,
ddlAddress.SelectedValue,
txtEmail.Text,
txtHPhone.Text,
txtWPhone.Text,
txtMPhone.Text,
blIsAdmin,
txtComments.Text,
Convert.ToInt32(ddlPos.SelectedValue),
Convert.ToInt32(id.Text));
}
else
{
//Display error - no user id cannot update record
}
}
The linkbutton looks like this:
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True"
OnClick="MemberInfoUpdating" Text="Update" />
I am making a message module in asp.net with database of sql. i have made a gridview and enabled selecting. and a form view is synchorised with grid view on selecting. i am writing update sql but could not get a way to take data on Gridview or Formview to compare the record in sql database.
this is my page view
[Code]....
This my vb code
I have a web page with a gridview & formview (master/detail relationship) combo. On page load the gridview shows all records from a SQL table. On my page I have a button that when clicked shows the formview in Insert mode to allow users to add a new record to the data. I have also added a column to my gridview that has a link. When a user clicks this link it hides the gridview and shows the formview in edit mode with the detail from the record selected from the gridview.
In my formview I am using a listbox control to allow users to select multiple values. The choices in the listbox are populated by a SQL data table. I have successfully written code to post the selected listbox values to my SQL data field during Insert. When the user selects a record to edit I have code in the databound event to select values in the listbox from the choices based on the value in the sql data field. This works as well. My problem is that I cannot figure out the correct code to update my SqL data when a user is editing the record and makes changes to the selected listbox value. I have included my design code for my listbox in my formview edittemplate and also my behind code that I have attempted.
<td
style="width: 454px">
<asp:ListBox
ID="lbox_ConstructionType"
runat="server"
DataSourceID="SqlDataConstructionTypes"
DataTextField="Construction_Type"
DataValueField="Construction_Type"
SelectionMode="Multiple"
Width="144px"></asp:ListBox>
<asp:TextBox
ID="tbox_Ctype"
runat="server"
Text='<%# Bind("ConstructionTypeID") %>'></asp:TextBox></td>
[Code]....
I have this problem everytime I change the select command to a custom command, and I do not know what is causing it.
My Formview will not update when i hit the update button, page refreshes but I get the same info, not the updated info. I set up my DataSource to CRUD only one table, then change the select statement just for the ItemTemplate of the Formview, leaving the rest, but it will not update
I have a Formview binded in the code file to a generic list. Now, upon editing of a record, I wish to access the Keys and NewValues out of the FormViewUpdateEventArgs parameter of the ItemUpdating event handler method. From what I've tried and searched over the internet as of now, I've come to know that updated values are only available if the Formview is set a data source control on the markup page else they'd be null. Is this true?
Secondly, at this moment I am casting the sender object to formview and individually filling each object property by using FindControl method to find and retrieve values present in the controls. Is this the best way to do this task? As an example, this is what I am doing atm:
FormView currentForm = (FormView)sender;
ListObject.ID = new Guid(((HiddenField)(currentForm.FindControl("hdnID"))).Value);
ListObject.Name = ((TextBox)(currentForm.FindControl("txtName"))).Text;
I am using a stored procedure for a sqldatasource to update a formview. I believe that I am passing the Obligation_Status value correctly to the stored procedure but the oblgation status field is always updated AS NULL in the database. Does anyone know what I am doing wrong?
[Code]....
[Code]....
One of the fields on my formview is a dropdownlist. When I go into edit mode the dropdownlist gets set to the correct value and works fine up to this point. Problem is I just can't see how to get the newly selected value of the dropdownlist to persist to the database when update is clicked. The DDL is a category list and I want to allow changing of the category for each record. Like I said I have it working so it displays the correct category for the record but if I change the DDL (change category) the new selected value doesn't get updated in the database. It just keeps using the binded value that was originally assigned to the selected value of the DDL. see code snippit
[Code]....
The above snippet is how I am binding the DDL. Now to not bore you with a ton of code paste I use various events of the formview to make sure the value displayed in the DDL is correct for the record that I am viewing at the time. All that works just fine. Where I need some pointers is the when I enter edit mode and change the DDL from say fire to ice it isn't getting persited to the database, all other info in the record gets updated just fine but the DDL never changes. I have tried several angles to getting this working and TBH my brain is yelling BREAK TIME.
why my formView control is not updating?
[Code]...
[Code]...
I have a 4 formviews present on a page. Three are updating to the DB without issue when the update link button is clicked. One is not. I have the DataKeyName set and still it doesn't save.
[Code]....
I want to bind an object to a form view.
[Code]....
Now, is it possible to generate a new object on update, without getting and reading each textbox with findcontrol?
I have a strange issue with the FormView. After working through some issues getting the update to work (as this is my first experience with FormViews) I now have a new issue. After I perform an update, and the FormView updates and returns to read mode, if I hit F5 (refresh) the FormView performs another update to the datasource, despite the fact it is read-only mode and none of the fields on the screen are editable.
I would think that a refresh in read mode for the FormView after an edit would simply refresh the data from the database, not perform another update. Again, the FormView is in Read Only Mode, but a refresh is creating another Update event (which I can debug and see if I break in the ItemUpdating event). This only happens after I perform an edit, not when the page initially loads.
I have an access database where when the record is updated I would like to automatically check a box and update the date to the current date in an Access 2002-2003 database. I've tried this for several days without any resolution and can't find anything that works on the net. ...I'm new at this.
I'm using VWD 2005 Express and Expressions Web 3.
Here is a short version of the code.
[Code]....
I have a GridView or DetailsView and its bound to a CslaDataSource.I noticed that the "Object_Select()" event is fired automatically with every time the page is loaded or refreshed.How I can perfrom mnaual biding between the DetailsView Control and CslaDataSource ?I want to control binding via code using the DetailsView.DataBind() method in certain cases only.
View 4 RepliesI would like to ask if it is possible to access data on a master FormView from a nested detail FormView.
I have a main form (master) with several tabs (detail) and would like to display a label with text from main form that is hidden by the tab at the moment of editting. My asp page looks like this.
[Code]....
Is it possible to get the value of the label CompanyTextLabel from CompanyTextBox using just ASP.NET expressions or something similar without writing c# code in .cs file?
I would like to display a gridview in which:
I want to create 2 columns and 5 rows and want to give heading to those 2 columns and would like to manually enter the values in the rows, how ? (I don't want to connect this gridview with the database)
I have a manual binding to a grid view. After that, I found out the Grid_View.Columns.Count still give me 0.
I tried to set this:
AutoGenerateColumns="False"
After I set this value, the gridview become empty. Wonder if the False causing the column count to be 0.
[Code]....
I have a manually binded gridview, which I set AutoGenerateColumns=False. I then tried to set AllowSorting=true at runtime, but it wont work.
My gridview are created during runtime.
I have a gridview which uses an EditItemTemplate and an ItemTemplate for an 'Effect' column. The ItemTemplate simply displays the bound data using a label control. The EditItemTemplate defines a databound DropDownlist control which contains all the possible selections.
The gridview also contains a bound 'State' column which gives the State of each row. I have already been able to access this field in the gridview_RowDataBound event, so far using the value to decide whether to re-colour a row or not. What I would like to do is use this value to determine whether to use the ItemTemplate or the EditItemTemplate for each row.
Effectively I want to be able to decide whether to display just the data (For an Approved row) or display the DropDownList and allow the user to make updates (For an In Work row). I have searched for information on this issue online but have not found a lot, so I presume that my approach is not possible.
I have created a GridView, but the DataSet is created manually.Do I loose the built-in sort functionality of a Gridview? ....because I'm getting an unhandled exception when I try and click on the header now to sort. So I assume the answer is YES.
View 5 RepliesI go this code that can so a manual sorting on grid view. The code works fine for "ASC", when I wanted to sort the field to DESC, it never works. Second, it also failed when I switch to another page. Case 1: By default, the column is sorted DESC, then I switch to ASC, works fine, then I switch to DESC, it failed (remain at ASC).Case 2: By default, the column is sorted DESC, then I switch to ASC, works fine, then I switch to other page, it failed (remain at DESC on new page).
[Code]....
I've been trying to marry up the listview and the Data pager with my own, Database class that pulls the information from the database.
I can display the information ok no problem, fortunately this time I know what the problem is, but I cannot figure out a way around the problem.
In my Page_Load event I fill out the listview accordingly:
[Code]....
The problem lies in the postback, I need to figure out a way get the information as to what state the DataPager is in so I could update the Query accordingly.
I know there is a StartRowIndex avaialbe but this does not get updated in the Page_Load event.
I have GridView that is bound to an ObjectDataSource and within that GridView I have CheckBox, DropDownList, TextBox and Label controls. All the controls except the CheckBoxs are working like a champ or normal display and Delete (Insert is handled outside the GridView, it works also). The CheckBox values are passed into the update method for the ObjectDataSource as type byte. Without doing any custom coding the CheckBoxs were always unchecked (regardless of the data being 1 or 0) and when I edit a row in the GridView and saved the values the CheckBox controls would always be 0 even if the check boxes where checked. After searching web I found a suggestion to change the binding on the CheckBox controls from, Bind("Monday") to this, CheckUncheck(DataBinder.Eval(Container.DataItem, "Monday")) with CheckUncheck being a method to make 0 or null = false and 1 = true. This seemed to the do the trick and it set the CheckBoxs correctly in the DataGrid, I was giving myself high-fives, until I tried to update a row.
When doing the update, as with my first attempt, it would always set the CheckBox values to 0, thus ignoring the checked property of the CheckBox. So I search the web again and found a suggestion to handle the update manually, due to the binding being one way. So I created a myUnhappyGrid_RowUpdating event handler and changed all the columns in the GridView to template so I could do the old school .FindControl on them and grab the values. Once I was able to grab the values from the row to be updated I added them to the ObjectDataSource .UpdateParameters and called ObjectDataSource.Update() and it worked, kind of. Now came the next trial, it did the update into the database just fine and I was happy, until. I finished stepping though the code. As I stepped through the code the update on the ObjectDataSource got called two more times, thus undoing what I had just spent hours fixing. First, is the road traveled the right way to do it? Second, if I am on the correct road how can I suppress the additional two updates that follow my manual .update call on the ObjectDataSource?
I implement a manual sorting codes. It works only for ASC sorting. If you try to sorting gridview again by the same field it does not work. I mean how to solve for the sorting function for DESC
my codes for sorting
[Code]....