I have a gridview and a detailsview in a page. when the "current record" (the cursor) is pacing along the gridview, the detailsview, which has the same datasource with the gridview, should keep the pace with the gridview.
View 1 RepliesHow to pass the selected detailsview/formview record data to the second webform and populate in the textboxes present in the second web form using c# code or from aspx page?
View 2 RepliesI want users to select a record in the GridView and then have that record open up in the Detailsview. How would I go about getting these two tools to communicate?
View 4 RepliesIs 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 have a webform to take user inputs. i am able to insert the data into database on clicking add button and also able to view the
records in the detailsview which is in the next webform.I have a edit and delete button in detailsview.
Now when i click edit button, i want the selected record from the detailsview to be populated in the first webform where i can update the record. also deleting record using delete button.i am using c# code,datatable and oracle stored procedure here.
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?
Im wondering if anyone knows how to display more than one record on the same page for a detailsview control? I could do with maybe displaying 10 per page but cant see no option for doing this.
View 2 RepliesHow to set my DetailsView to show a specific record for I which catch it's datakey from a text box ??
DetailsView is already bound to a datasource (in this case from an Access database file):
[Code]....
The "SqlDataSource1" uses a connection string "nwind" set in web.config.
I would like to do this in C# (code behind) and I store the "datakey" in a "s" string variable. After this I'm lost..
I want to update a record in a detailsview which contains a decimal value which I would like the field to formatted as currency while editing.
When I try to update the record I get an error about trying to pass a formatted value to an unformatted table column. The ApplyFormatInEditMode is set to true and you are cautioned by intellisense about unformatting befor updating the record. This is databound field.
Is this a simple as x = Val(detailsviewrow(1).tostring) ?
Here the code I am trying :
[Code]....
I have a table that has previous data in it.
I have written a new site around this data
On occation a user will attempt to edit a record in a detailsview and they get this error:
System.ArgumentOutOfRangeException ddlState has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value
This happens to be a list of states.
Is there way to allow the edit so the user can select a valid state from the list?
I have a question on a simple application - menu's which contain 0...x recipies. I have a formview, and in the formview I have a dropdownlist. The query that populates the dropdownlist depends on the formview's current record ID, how do I get that to put into my data source?
Note that I would prefer not to use the RouteParameter that gives the Formview it's ID as the RouteParameter doesn't use the formview's primary key as I'm using the menu name instead
My code is:
[Code]....
<asp:formview id="fvMenu" datakeynames="MenuID" datasourceid="dsMenu" runat="server">
I am currently binding my Detailsview and Gridview together by a "ID" field selectedvalue "1". Which works great except for the fact that I don't want the user to have to go down to the gridview and select the page and then the record to view it in the detailsview.
I have 1 sqldatasource for detailsview and another sqldatasoure for the gridview. Both have the exact same select statement.
I want the gridview and detailsview to automatically display the last record inserted not the first record in the table.
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 RepliesThis 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 RepliesI have a GridView and DetailsView on the same page. If the GridView has data, I can Select a row and it brings up the DetailsView from which I can edit that record or click NEW to create a new record. Without a record to Edit, the New link and the DetailsView control is not visible. What is considered best practices for Inserting the 1st record using a same page Gridview / DetailsView combination?
View 2 Repliesafter a DetailsView (DV) 'Insert' (triggered by a DropDownList (DDL)) the DV shows the first record (in the DDL)!Are there VS2008 means to keep / show the just entered data - again ready with the command row "Edit/Delete/New" enabling me to e.g. "Edit" the just entered data?This DDL/DV scenario works just fine but to show my just entered record I have to leave this page and start calling this .aspx page again in order to see the name in the DDL and, hence, in the DV.I.e. I'm looking for a kind of automatic 'postback' bringing my just entered data back
View 9 RepliesI want to return only the record or records from one table "tblUserInfo" to my details control where the records are related to the currently logged in user. I have a field in the "tblUserInfo" table named "UserName" that contains the value that is displayed as the current user name when the user logs in. My connections string is located in the WebConfig file and is being recogonized by VWD as being a connteciton string.
I have the following Select statement defined and also tried to set the parameter value to pass to the select statement. Obviously I missed something:
[Code]....
The detailsview is used for logged users to add a new item to a table in my sql database. The detailsview default mode is set to "insert".
The UserID is a field in the table in which the user enter the new record.
How can I get the UserID Guid value assigned automatically on pageload to the specific bound field in my detailsview
A few questions regarding detailsview and gridview:
1) when page load, how can I default the detailsview to show the first record from the gridview? SelectedIndex does not have any effect to my detailsview.
[Code]....
2) how can I select a record in the gridview if my table has 2 key fields using below syntax?
[Code]....
I have a web form with a detailsview controlled by a linkbutton in a gridview. When the user clicks the linkbutton, a panel appears with the detailsview inside it. The select statement is created based on the commandargument of the link button. So far, if there is a record associated with the ID passed through the linkbutton, the detailsview displays correctly. However, if the user needs to update this, it jumps to the default record for that detailsview after clicking the standard update link. Without a default ID set, the detailsview does not display at all, as some IDs do not yet have a corresponding record for the detailsview.
How can I get around this issue? Also - is there a way to immediately display an open detailsview for IDs with no record associated yet?
Initially I display all the records in the gridview. Then based on the search I fetch certain records and display it.. When I try to edit any retrieved record, the control automatically tries to edit the first record instead of editing the selected record.. What should I change in the code to make it work?
Here is the code behind
[Code]....
[Code]....
[Code]....
I have some ImageField in my DetailsView and when I changed it to Insert mode then ImageField is also became the textbox that allow you to type something, and my question is how I can make ImageField to be read only when I changed DetailsView to Insert mode?
<asp:DetailsView ID="dvNew" runat="server" AutoGenerateRows="False"
AllowPaging="true" DataKeyNames="ID"
DataSourceID="DataSourceNew" Width="600px" Font-Bold="False" AutoGenerateInsertButton="True" >
<Fields>
<asp:BoundField DataField ="name" SortExpression ="name" HeaderStyle-ForeColor="Black" > </asp:BoundField>
<asp:ImageField DataImageUrlField="Image1Path" NullDisplayText="No Image"
ReadOnly="True" ItemStyle-Height="250" ItemStyle-HorizontalAlign="Center"
ItemStyle-VerticalAlign="Middle" ItemStyle-Width="250" >
</asp:ImageField>
In my code file
protected void Page_Load(object sender, EventArgs e)
{
DataSourceNew.Selected += new SqlDataSourceStatusEventHandler(DataSourceNew_Selected);
}
protected void DataSourceNew_Selected(object sender, SqlDataSourceStatusEventArgs e)
{
if (e.AffectedRows == 0)
{
dvNew.ChangeMode(DetailsViewMode.Insert);
}
}
after i select data from datatabe and store to datatable finally bind to the repeater to display. but grid is always display what the datatable store there is many duplicate data appear in the repeater. i would like to show specifc col once and hidden other name which appears more than 1.
for example in repeater:
section desc seq no
A NT 1
A BT 2
A KK 3
B PP 1
then A appear more than 1. i would like to hidden A except the first record as belows:
section desc seq no
A NT 1
BT 2
KK 3
B PP 1
I have a DetailsView within an UpdatePanel. I programmatically put the DetailsView into edit mode, change the fields then call the UpdateItem method which causes the "must be in edit mode to update a record" exception. Am I missing something blindingly obvious?
[Code]....
Code Behind:
[Code]....
I want to making another dropdownlist visible=false when clicking in dropdownlist on the same detailsview?
View 4 Replies