Forms Data Controls :: Automatically Set Page Index On DetailsView After Insert

Aug 13, 2010

I wonder if there is a clevcer way of setting the correct page of a DetailsView after inserting new data? I have a DetailsView bound to a LinqDataSoure. Now, if I use this DetailsView to insert new data, everything works fine, except the fact that the DetailsView switches back to the "old" page index after leaving InsertMode.

This is somehow understandable, because it can't know which index the new entry will have, but unfortunately neither do I. So I was looking to the LinqDataSource_Inserted event where I can get the new Entry, but because the DetailsView.SelectedValue is read only, I can't just set it to the new entry. So. I might have to use the PageIndex property, but then I would need to know the index of the new Item, which I don't have either.

So, my only idea know is to store some information from the new entry, wait until everythings bound again, loop through the DetailsView to find my new entry an set it's index for PageIndex. But also here I have two problems:

1) The new entry (e.Result from LinqDataSource_Inserted) has not yet filled it's primary key, as this is of course created in the DB, so it's very difficult to identify the new entry properly
2) I don't know how to access each DetailsView page information without actually making it the active page.

So, my question, is there a clever way of doing this? In the past, I've been using SqlDataSource. Although the problem is basically the same, I could solve the two major problems by 1) Insert with Stored procedure which gives the new primary key back and 2) run through

"(((System.Data.DataRowView)MyDetailsView.DataItem).DataView.Table.Rows[i].ItemArray[0])"

to compare the keys. Both I can't get to work with LinqDataSource.

View 5 Replies


Similar Messages:

Forms Data Controls :: Gridview And Detailsview Link / How To Get This To Automatically Display On Page Load

Apr 30, 2010

I have an issue that I've spent quite a bit of time trying to solve. I have a Detailsview and a Gridview that I have linked using the ID field, It has now been decided that they want to have individual pages for each Unit. I have this working for the most part, however the detailsview is not being displayed until I hit select the row in the gridview.

How do I get this to automatically display on page load?

View 10 Replies

Forms Data Controls :: Automatically Update Gridview / Refresh Page When Insert In FormView

Jul 29, 2010

i want my gridView to be refreshed so i can vies the new records when i insert to formview.

Now i have to go to another address and back to se the updated record.

i cant even press f5 because then it just duplicates the record with the same text from the formview even if the fields in the formview are empty.

There is got to be a code for this!?

View 2 Replies

Forms Data Controls :: DetailsView EmptyDataTemplate After Insert Defaults To Empty Insert Screen

Jan 27, 2010

In 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.

View 2 Replies

Forms Data Controls :: Insert DetailsView Dont Show Read-only Data After Insert?

May 7, 2010

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 Replies

Forms Data Controls :: Link Multiple Detailsview To Page From One Master Detailsview?

Sep 3, 2010

I am trying to arrange the information from a SQL record into a 3 column by 3 row table to fit the form presentation that I want. I have placed on the page 3X3 table and then tried to place a detailsview in the first cell for the first picture called P1dv.

I have place a detailsview in the last cell that would control the paging of information called Controldv. I need to fiqure out how to link P1dv paging to Controldv page action. I am using visual web dev. 2005. I am not updating or editing these are read only views.

example of what i need the form output to look like:

picture1 picture2 picture3

name1 name2 name3

Contact1 contact2 contact3

what i ave coded as of now:

[Code]....

View 1 Replies

Forms Data Controls :: Index Out Of Bound In Formview During Insert?

Apr 27, 2010

I have a stored procedure and a function. I am connecting my FormView to the function and I am trying to insert a new record. I am not sure if the problem is the stored procedure, the fucntion or the FormView.

Stored Procedure:

[Code]....

Function:

[Code]....

FormView:

[Code]....

View 7 Replies

Forms Data Controls :: DetailsView - Go To New Record After Insert?

Apr 18, 2010

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 Replies

Forms Data Controls :: DetailsView - INSERT Default Value

Mar 23, 2010

I 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 Replies

Forms Data Controls :: Insert A New File Using DetailsView?

Mar 13, 2010

1- 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.

View 6 Replies

Forms Data Controls :: Can't Insert From A Dropdownlist Within A Detailsview?

Oct 18, 2010

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)

View 3 Replies

Forms Data Controls :: Cannot Insert Value Of Bound Dropdownlist In Detailsview

Apr 25, 2010

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]....

View 2 Replies

Forms Data Controls :: Insert Record In Nested Detailsview?

Oct 30, 2010

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?

View 5 Replies

Forms Data Controls :: Validating Insert Values In Detailsview?

Oct 26, 2010

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

Forms Data Controls :: Insert Control Into Detailsview Row At Run Time?

Dec 24, 2010

'' 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)

View 4 Replies

Forms Data Controls :: Detailsview In Insert Mode With Objectdatasource

Aug 25, 2010

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?

View 3 Replies

Forms Data Controls :: Set Default Value In Detailsview Insert Mode

Nov 17, 2010

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.

View 4 Replies

Forms Data Controls :: Change Nulls To 0 On Detailsview Insert?

Nov 19, 2010

I'm looking to find some command or control that will change fields in a detailsview insert a 0 if there was no data inserted into them. Some example code from my boundfield is:

<asp:BoundField DataField="Assignment_Travel_Time"

View 3 Replies

Forms Data Controls :: Insert Command Not Using Selected Value From DDL In A DetailsView?

Oct 8, 2010

My web form contains a detailsview control that I have added a templated field to with a DropDownList in the InsertItemTemplate. The DetailsView default mode is 'insert. My detailsview is attached to a sqldatasource that has a stored procedure in the db to handle the insert. When I enter data in the fields and select insert all values from the detailsview are written to the table except for the selection that was made in the dropdownlist. I am using the ddl.selecteditem.value to populate my variable however when the insert method is envoked it doesn't send my value. The DDL value that I am capturing does not need to be written to the table it is just a flag for some variables that need to be set at the stored proc level. How do I get the DDL selected value to be sent with the insert statement?

Here is my code behind:

Protected
Sub
DropDownList1_SelectedIndexChanged(ByVal sender
As
Object,
ByVal e
As System.EventArgs)
Dim temp
As DropDownList
Dim AccessLevel
As
String
temp = AddUserDetailsView.FindControl("DropDownList1")End
Sub
AccessLevel = temp.SelectedItem.Value
Label1.Text = AccessLevel

View 2 Replies

Forms Data Controls :: Detailsview Disapears When Clicking Insert Button?

Feb 1, 2010

I have got a detailsview in my webpage that inserts an item into a database when I click the insert button.

Once this button is clicked, the detailsview dissapears. Why it does this I don't know.

Some of my code:

[Code]....

View 3 Replies

Forms Data Controls :: DetailsView - Set Textbox Text When Going To Insert Mode?

Jan 19, 2011

I guess I'm not sure exactly how or where to do what I need.

First off - here's what I need - - when the user clicks on the NEW button in the detailsView, I have the User.Identity.name captured in a variable and I need to set one of the textboxes (InsertItemTemplate) named 'txtNew' to that name.

I've tried using the ModeChanging (and ModeChanged) event:
Dim
dv As
TextBox =
CType(DetailsView1.FindControl("txtNew"),
TextBox)
If (e.NewMode =
DetailsViewMode.Insert)
Then ....

However, no matter what, 'dv' always shows as 'Nothing', so I can't change the text of it.

Where do I put the logic and what am I missing?

View 2 Replies

Forms Data Controls :: GridView Paging After - Insert Record From DetailsView

Jun 23, 2010

GirdView and DetailsView in defautl.aspx. When i insert a new record using detailsview it works and gridview is updated. But i want jump to the right page in gridview after importing the record. How can i highlight the new row imported record in Girdview. I use ajax so gridview and detailsview are in updatepanel.

View 4 Replies

Forms Data Controls :: Get Identity Of Inserted Record Using Detailsview.insert()

Dec 6, 2010

This would seem to be quite a trivial task, however I am having trouble retrieving the identity of the record inserted using the detailsview.insert() in the code behind. It would seem that detailsview.DataKey.Value would contain this value, but it is null after the insert is performed.

View 4 Replies

Forms Data Controls :: Assign A Value To A Field In DetailsView After Insert Or Cancel?

Jun 10, 2010

A TemplateField of a DetailsView can be assigned a value easily at any of many event handlers such as Load, PreRender, etc. when the page is loaded. However, after Insert or Cancel is clicked, all the fields are cleared. I cannot figure out how to assign a value to the field again in code-behind.

View 4 Replies

Forms Data Controls :: Can Use ASP Buttons To Handle Insert And Update For DetailsView

Apr 7, 2010

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







Copyrights 2005-15 www.BigResource.com, All rights reserved