Using a class component, an Object data source and a formview I am successfully pulliing data from a SQL database. In some cases the rows contain one or more Null values and I would like them to be ignored completely. My simple code follows:-
I have a question, I have a Gridview with the field Description, quantity, Price per Unit, How can I compute (Quantity)*(Price per Unit ) = () on the gridview?
I have a typical gridview/formview master control setup. When I try to update or insert I don't get any errors but it also doesn't work. When I try to insert data all I get are null values and when I update, none of the values are updated. The formview looks like its working, but just doesn't. The primary key is an identity and it auto-increments by one.
The new values entered by a user are lost when a error occurs.
I tried to solve this by catching the error in the item updated event as per the code below
[Code]....
however the data in the form gets set back to the original values.
It seams as though the object data source is rebinding the form. How can i determine if this is the case? Is there a way to stop the datasource from rebining?
I am having a formview control with paging enabled. It's a simple page used for viewing pictures. (It's from the personal web site starter kit with some modification)
[Code]....
I would like the formview to pass not only the pageindex value but also the Next or previous picture's unique ID called in my case PictureID?
I've been spending two days on this. My page formview is in a tab container and I need it to update, insert and display data. Insert and display are ok as long as the default mode is Insert. The problem here is edit mode, it's able to get values from the db(oracle) and display them in edit mode, but when I click save, any values I typed out on the textboxes do not get captured. When I call on my db update class, it just sends old db values. Here is the process: formview shows data selected from gridview, then an update button is clicked to edit the data. there is also a SAVE button to send updated data to db. Example: description textbox = "test", then I type out a different value, and in debug mode, the textbox.text still shows "test" after clicking save.
I have a formview on a web page, set to insert mode as default. The form view is bound to a SQLDatasource. This datasource has a custom query written to select the details for this formview. The query joins two tables to provide relevant detail and not just an ID for one of the elements on the form view.
The first tabe contains information regarding projects and the second table contains detail regarding Resources. First table has the following definition:
In web config file I have add key values specified.
In the formview I have labels on edit , item and insert mode that I want to display all the time by getting those values from web config. I'm able to do that with no problem but when I change the modes between edit to insert or item view, I lose those label values until I hit the "select" twice from the Gridview, those values re-appear. Below is the snippet of the code. What do I need to do to retain the category values all the time?
I have a listbox inside a formview in a details page(master/details). The values for the listbox will come from a lookup table and when the user select one or more values it should be inserted in a table. The process sould be like the following:
The user will select one or multiple values and click on a Select button. Then a label should show the selected values. Then the user will click on the Insert button in the formview to insert it in the database.
I 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?
To me this should be much easier, but I can't seem to retain the values that are put in the Insert template upon a validation failure or when the sql fails. This will prevent the user from having to retype everything agin in the event of a failure.
As you can see I am using the Sub Insert_Click and not using an insert through the wizard. so the fields are unbound textboxes on the form. There are 2 dropdowns that provide choices for the other fields.
I pasted in the code using the text only option becuase the format was getting messed up. I probably need more background on why the fields are blanking out.
I have a formview that use the formview iteminserted event. The information inserts into the formview fine, but all cells blank out after the insert. How can I make it so I can show all the values I have inserted show up in the formview after the inteminserted event?
I am displaying selectable rows in a gridview. The selected row uses a stored procedure to display all the fields in a formview when the Select button is clicked.
Only a small subset of the fields in the selected row are editable. When I click the Edit button only the EditItemTemplate fields show up, the read-only fields from the ItemTemplate disappear. I want the read-only rows to remain visible with the editable rows.
If I include the read-only fields in the EditItemTemplate, I get an error when I click Update on the FormView. The error states that there are too many parameters being passed to the stored procedure to update fields. How can I continue to show the read-only fields with the editable fields on the FormView and avoid getting the input parameter error on the stored procedure for the Update command?
I have a page with a FormView on it. The page is strictly for adding records to a Table. I have the FormView bound to an EntityDataSource and everything works greate except for one thing.
I want to initialize a date field in the FormView to today's date. So, in my page_load event I have:
if (!Page.IsPostBack) { //Initialize SetupDate to today. TextBox setupdate = (TextBox)fvJob.FindControl("txtSetupDate"); setupdate.Text = DateTime.Now.ToShortDateString(); }
The first time this page loads, the txtSetupDate field is initialized.
Although, and subsequent loads of the page doesn't initialize the Text Box. I step through the code in the debugger and I can see that the code is executig, but something (the FormView bind?) is "clearing" the Text Box.
I am using an ObjectDataSource in my FormView for INSERT.
Data inserts correctly to my backend SQL table, however as i am posting back a success/fail message to the same page, i have noticed that after a successful INSERT if it hit the Refresh button the INSERT is doubled up.
How can i stop a user pressing the Refresh button and doubling the INSERT?
Is there a setting somewhere or can i stop this programmatically within my ObjectDataSource_Inserting method perhaps?
I 'm trying to use a gv with a modal formview to edit the row details
my first problem is: i can't get the Gv data keys there are actually two but i im trying to go one at a time. the data keys will be 1=rideid & 2=rideleg ... the combination of these two fields make all rows unique.
Secondly: after the row has been edited i need to change the data source so it can be saved in a second table.
these are the errors i'm getting with the code below
Error 65 The best overloaded method match for 'System.Web.UI.WebControls.ParameterCollection.Add(string, string)' has some invalid arguments
Error 66 Argument '2': cannot convert from 'object' to 'string'
I am trying to validate data using the OnItemUpdating event on a FormView control. The event is fired when I click the update button but
e.OldValues["txtDate2"].ToString() in the function returns a null value. What am I doing wrong here ? ValidateForm(Object sender, FormViewUpdateEventArgs e) { string val = e.OldValues["txtDate2"].ToString(); }