DetailsView has 2 properties: AutoGenerateEditButton, AutoGenerateInsertButton for hadling Update and Insert. Is there any way I can use asp:Button or some other buttons to hadle the same tasks?
View 1 Replies
Not sure where I went wrong with this one, but I can't figure it out now... I've got a DetailsView in an UpdatePanel. A dropdownlist controls which person's details are displayed in the DetailsView. I have the DataSource set to an ObjectDataSource, which has select, insert and update methods defined. I also have a method for the ItemCommand, ItemInserting, ItemUpdating and DataBound events of the DetailsView specified.
When I click "New" or "Edit" on the DetailsView I get the open form with either the details for the current person, or a blank form, exactly as I would expect. But when I click the "Update" or "Insert" buttons it does absolutely nothing. I have it running in debug, and have put breakpoints in the ItemCommand, ItemInserting and ItemUpdating methods, right at the top, and it never goes there. The form remains open, and nothing happens. If I click "Cancel", it posts back and goes back to ReadOnly mode.
A couple more minor details that may be important: This page is using a Master page, which is where the ScriptManager is. I'm actually using the ScriptManager from the AjaxControlToolkit. I also have a GridView in this same UpdatePanel, and that has a FileUpload control in it. Because the FileUpload control doesn't work properly without some tweaking, I have to call a RegsiterPostbackTrigger method on page load to link it back to the Master page's scriptmanager. Not sure if that's causing any issues...?
I had this working fine, but then as the page got more complex and I had to change some of the code, at some point it just stopped working and now I can't figure out how to get this working again... I'm happy to post code if necessary, just thought I'd try this first to see if anyone has a quick idea for what to check.
I'm trying to use the DetailsView to make Updates. The problem is that it can't handle empty fields even though the underlying table field allows nulls.
I get a message like this if I change the "State" field to blank when doing an update
The parameterized query '(@Cust_ID int,@Cust_DL nvarchar(7),@DL_State nvarchar(2),@Last_N' expects the parameter '@State', which was not supplied.I'm using an object data source control which is calling the EditCustomer method in my Customer Class. I'm not sure how to fix this.
[Code]....
How can I show data of a table into a page by using Data controls and add insert, update, and delete buttons?
View 2 RepliesIt should be simple, but I didn't found yet how to do it. There is only one user (Admin with user name and passowrd, he has a cookie so I know when he is watching the page) I would like to show him the Update/Delete/Insert button options in my ListView, but to the other users I don't want them to be able doing this kind of things, So it should be hidden from them. How I am doing it in C# code? Showing/Hiding these buttons?
View 3 RepliesI'm struggling with trying to use RIA services from an ASP.NET web site.I created a new web site, added an entity framework model, then added a RIA service that uses that model. I used the DomainDataSource control to bind the ASP.NET controls to the RIA service
View 2 RepliesI have a detailsview which has a button for insert and edit depending on mode plus a cancel button. What I am looking to do, is to use the cancel button to stop any insert or update to the database if clicked.
View 2 RepliesI am using 1 textbox with a Ajax Calendar extender to allow my user's to select a date graphically (exp: 12/15/2009). I have another textbox for the hour and minutes in military time(exp: 15:30). I think i have the code to grab the data from the 2 textbox's and combine them to be inserted into the field (exp: 12/15/2009 15:30). Here is my insert code for the Field:
[Code]....
However unless I make all the fields Nullable the insert fails, on top of that none of the other field that I have selected on the Detailsview Insert or Edit are inserted into there fields. Half of my fields have to be non-null values. So how do I fix this?
I can supply additional vb code and the aspx code if needed.
This is the error I'm getting: Cannot insert the value NULL into column 'Operation_type', table '/GAOSDB.MDF.dbo.BC_Perf_Log'; column does not allow nulls. INSERT fails. The statement has been terminated.'
This is the first non-null column.
I need to get this figured out because I have 30 other web pages that will be utilizing the same approach.
I have a datagrid where i use template columns. In the EditItemtemplate of a column i display a Link button.Now I have one more button which is a EDIT button in the normal EditcommandcolumnI am trying to use Itemcommand to handle the buttonclick in the EditItemTemplate and the normal ONEDIT for the Edit button.Now the problem is, since Itemcommand event considers the post back of even this Editbutton it get fired before the datagrid goes to editmode.So can some one help me with the eventhandling code that will recognize which Buttonclick firest the Itemcommand even of a datagridTo make it very simple, Short and sweet. HOW DO I HANDLE TWO DIFFERENT BUTTON CLICK IN A ITEMCOMMAND EVENT OF A DATAGRID?
View 1 RepliesIn my detailsview, I have an emptydatatemplate set up to allow users to enter new records. The code works. However, once the record is inserted, the detailsview defaults to a standard insert screen. I know this will cause confusion for the users. I would prefer the detailsview to either show in edit mode or a read-only mode. I have used detailsview.changemode and detailsview.currentmode in the custom sub created for the add new button of the emptydatatemplate- neither of which do what I was hoping. It would be even better if when there was no data, it defaulted to the insert screen (which seems like that should be an easy, no-brainer way for .net to function) but it doesn't. Or, I don't know how to accomplish it.
I don't want to force the user to click cancel after inserting an item through the emptydatatemplate just to be able to use the detailsview for other records.
I have a problem with DetailsView linked with Database, DetailsView is Insert/Edit enabled, and adding/ediditng data works, however........ when I add a new record (DetailsView in Insert mode) and press INSET instead going to record I have just created in Read-Only Mode it shows me blank form, it looks that the "linking" field is null.
View 3 RepliesHow can I display edit and new buttons without duplication in a detailsview control? This is a question from a past exam paper for 70-562. Part of the question is below:
"The company CIO assigns a task to you. According to his requirement, you must make sure that the users can insert and update content in the DetailsView1 control. Besides this, you have to prevent duplication of the link button controls for the Edit and New operations. At line 3, which code segment
should be inserted?"
I have GridView control and assosiated DetailView control.
When the record form GridView is seleted, I am showing the details on DetailView.
I have set the Auto generated delete button to true. And now I want to delete the record when someone clicks the Delete button from DetailView control.
Following is the HTML markup for my details view
<asp:DetailsView id="detailsPayments" runat="server" GridLines="Vertical" ForeColor="Black" CellPadding="4"
DataKeyNames="Id" Width="125px" Height="50px" HeaderText="Payment Details"
AutoGenerateRows="False" BorderStyle="None" BackColor="White" BorderColor="#DEDFDE" BorderWidth="1px"
AutoGenerateDeleteButton="True" OnItemDeleting="DeleteItem">
<FooterStyle BackColor="#CCCC99"></FooterStyle>
[Code]....
But not able to sucessful. Getting runtime exception as follows
Stack Trace:
[Code]....
I have a gridview and when i click on the edit button i will get the modalpopup window which is having a popup window i want to update the data in that details view and refresh the data into gridview also.
View 2 RepliesI have made a DetailsView which in DetailsView there is action to add the data, change data and delete the data ..how to save, change, delete data, which is in the DetailsView without saving it in the database?so far I use viewstate, but I do not know how to apply it in DetailsView ..
how to create insert , update , delete . in detailsview without saving in database ..
private void Bindemptydt() {
//Declare a datatable for the gridview
DataTable dt = new DataTable();
//Add Columns to the datatable
dt.Columns.Add("report_id");
dt.Columns.Add("param_field");
dt.Columns.Add("param_label");
[code]....
Is it possible to code DetailsView to go to the new record I've just insertted? Currently it appears to default to the first record, utlimatly I'd like it sorted Last name, first name and upon an Insert it should go to that new record on pageload.
View 3 RepliesI am using DetailsView to INSERT new records. I have a field "Paid Date"(date) that needs to be pre-populated with the current date. 90% of the time, the user will use the default date, however, there are times when the user will need to change the data as needed. I want to add this default in the code-behind. I DO NOT want to use template item.
View 3 Replies1- THE METHOD :
public static int Insertclient(
int Cod_client,
string Nom,
string Tel,
string Adresse)
[Code]....
2- InsertClient.aspx.cs:
using System;
using System.Data;
using System.Configuration;
using System.Collections;
[Code]....
3- Database:
4- clientDetailsView :
5 - My request :
When cod_client already exisits , i want to mention that in result message.
I figure that this should be relatively straightforward, but I still can't get it to work. I have a gridview and a detailsview to set up shifts for students and teachers. I would like to be able to insert new shifts using a detailsview. I will limit the students, teachers and location to items that are in a dropdownlist. The problem is that when I handle the iteminserting event. the e.values collection doesn't contain all of the fields I want to populate. How do I add the new fields to the list. This is my codebehind:
Sub On_Inserting(ByVal sender As Object, ByVal e As DetailsViewInsertEventArgs)
I have a dropdownlist in the edititemtemplate of a detailsview. The dropdownlist is bound with an objectdatasource. The detailsview is bound to a seperate objectdatasource which connects it to the insert method. When the page loads the dropdownlist is bound properly. However, when I make a selection and select insert I get the following error: Could not find a property named 'DeptID' on the type specified by the DataObjectTypeName property in ObjectDataSource 'objCurrentProduct'. I've tried to remove the SelectedValue='<%# Bind("DeptID") %> attribute. I can then insert without an exception being thrown but the selected value of the dropdown is not recognized. Here is the code:
[Code]....
[Code]....
Scenario : I have two database tables with one to many relationship. eg:- City and Related news. So I have a gridview(Gridview1) which lists out all the cities and allows edit, delete of the gridview rows. Now since i wanted to display all news for the city, i have a nested gridview as a column in this Gridview1. This nested gridview displays all the news for the cities. And I have edit, delete buttons for this gridview too - So far, good - works fine.
Now what I would like to do is - To insert a new news item for a city. For this, I attached a detailsview to my nested grid(gridview2), and tried to insert. I need the primary key id of city table from the first grid (gridview1) to insert the news into the second database table and I could not access this value from the parent gridview. My gridview1 does not have datakeyname, it is programatically bound.
Also, When the gridview/detailsview is nested, it does not get listed in the event-handler list. So I cannot use say, detailsview1_iteminserting. I do not how to add this event handler
Has anybody done anything similar? When I started, it looked like a pretty straightforward thing - There must be some way to do this. But I just can't get it to work. How do you usually insert into the child table in a one-to-many relationship? Should i just be using two separate gridviews?
I'm inserting data into a SQL database through a detailsview. When a user inserts an incorrect data type or leaves a required field blank it shoots off to a big error screen. Is there a control that I can use that will allow it to give an error (with a little star or something) that says which field is incorrect without the big error screen?
View 3 Replies'' I try to add an TemplateField to my DetailsView control with calander control, in all modes. but can only add it to cell(0).how can i insert in the middle of the row?
Dim tmpfld As New TemplateField
Dim c As Calendar = New Calendar()
DetailsView1.Rows(0).Cells(4).Controls.Add(c)
i have a detailsview in insert mode and that is bound to objectdatasource. now the class that is attached to objectdatasource is :
[Code]....
here ResturantId value has to be in session or from Dropdownlist and rest of the value from Detailview. So how to assign that value?
How do I set the value of a field in a detailsview to the selectedvalue of a gridview on the same page? I am also trying to set today date as value of another field in the detailsview as well as UserID. I wrote the following codebehind for the date setting:
TextBox tb = (TextBox)DetailsView2.FindControl("TextBoxCreDate");
tb.Text=System.DateTime.Now.ToShortDateString();
TextBoxCreDate is a template field in my DetailsView.
Unfortunately, I get a Object reference not set to an instance of an object. Error message.
