Here's my GridView control:
[Code]....
And here's my FormView control:
[Code]....
The problem is, when I click on the GridView item, the formView control does not show the detail.
I have an "Edit" page that uses a FormView bound to an EntityDataSource. The page is called with the ID field of the record to edit in the query string: "EditEmployee.aspx?ID=10". The EDS the FormView is bound to is using: AutoGenerateWhereClause=true and a QueryStringParameter. Below the FormView I have a ListView that contains some child records of the FormView. The ListView is bound to a seperate EDS and also uses the (same) QueryStringParameter.
The problem I am having is when this ListView attempts to Insert or Edt a column I receive an error because I don't have the ID field (EmployeeID) of the parent bound anywhere in the ListView (and obviously, it is setup as a ForeignKey so it fails, like it should). Any advice on the best way to get this ID (EmployeeID) column bound in the ListView? There are many things I can do in code behind, but I would like to solve this in the markup if possible. I can move the ListView so that it is inside of the FormView if necessary.
Im making a Master details web page ASP.NET. I have one aspx page with all the items in a listview, then a link to another page to show the details view, but I dont want to use a asp:detailsview control becasue it generates a table, and I want a more complex layout. I want work each property of the item, but I dont know how. I want to do in LINQ. This is my very bad aprox: I need an orientation of how to get ONLY one item from the LinqDataSource on the page load and not to query the database everytime I need a column. I dont need biding because I only need to show data, not insert, not update, not delete...
View 2 RepliesI'm trying to setup is a News module with article listing paging and article detail paging. I have a GridView with paging that lists my articles just fine. In that list, some article titles have links that direct to an article detail page by passing in the articleID to the details page. I was able to setup my details page, which uses a DetailsView control, to use paging by using an ObjectDataSource with pageIndex and pageSize parameters from the querystring. Once on my detail page, I can use my navigation arrows to move through Next and Previous articles just fine.
No matter which article I click in my article list, my detail page always starts with pageIndex 0 and thus not the article I clicked on. I understand why that is because it's going by pageIndex value instead of articleID. What I need it to do is, set the detail to whatever articleID i pass in, then allow me to navigate Next and Previous to THAT particular article instead of starting me off from pageIndex 0.
[Code]....
I am using a GridView and a DetailsView to establish a master to detail form, the idea is to let user select a record on Gridview and Detailsview will load selected record for editing. Here is declaration for the ODS and Detailsview.
[Code]....
this is working fine when I select a record from GridView and edit/update it in DetailsView. But it's not working so well when I insert a new record using DetailsView, because after insertion the selected record remains as the record selected in GridView.
I use Gridview along with Formview for master/detail viewing. When I change sorting in gridview selected index changes, too. I mean, eg first top record is still selected but it's another id. What I want is to keep id of selected record, in case of need changing a page
[code]....
I am using the multiview which on one view has my gridivew and the other has my detailsview. My gridview is a template gridview and I have a button for edit and another for delete.What I want to do is when either the user clicks the edit or delete buttons that the appropriate record is selected and the multiview view is changed to the detailsview showing the selected record.My datasource is microsoft's object container datasource NOT the objectdatasource and I am using model view and controller design pattern in my coding.
View 2 Repliesi have a datagrid that i want to be able to select a row and be able to edit the details of the row selected. Im connected to an sql azure db.
View 1 Repliesi am working on project where i have one master table "PURCHASE_ORDER" with fields
order_no as primary key
vendor_id
order_date
and i have a detail table called "PURCHASE_ORDER_DETIALS" with fields
sno,order_no,item,qty,rate.
i am supposed to create a master detail form
where i am supposed to accept an order from an vendor with multiple items.
i.e the form shoud accept one master record and multiple detail records and then either save all of them or discard all of them(both master and multiple detail records).
I've been experimenting with using EF (asp.net 3.5 sp1) with a master detail page. Using northwind as the database, I'm simply trying to have categories as master and products as detail. I have read everything I could find on the net about the where condition and it still fails with this error as soon as I click the select link in the master grid:
Microsoft JScript runtime error: Sys.WebForms.PageRequestManagerServerErrorException: A property with name 'CategoryID' does not exist in metadata for entity type 'WebAppEF01.Products'.
What strikes me is that the CategoryID column is not exposed by the EF model. That's been rolled up into the navigation element 'Categories' I suppose...but on the surface this seems to create the problem I've running in to. I've tried turning off the autogeneratewhere clause but didn't have success. The code for this page follows below.
[Code]....
I am new in crystal reports. I want to show main detail relationship in crystal reports like this
Main Records
CustomerID CustomerName ContactNo City
1 Shaiwal 7388898### Varanasi
Detail Records
CustomerID OrderID Quantity UnitPrice
1 1 50 500
1 2 30 1000
1 3 60 700
1 4 80 5000
So here is the situation - there is data on master records - its a hierarhical view - something like (ID, IDParent, Title) and detail data - (ID, IDMaster, Details)
And like to build UI using an TreeView - binded with master data - and an GridView - binded with detail data.
Question is witch property to use to create the master/detail chain between Datasources - oh, I've forgot to tell I'm using an ObjectDataSource?
I have a gridview that displays some records....i have added a new column to it called Edit....now when i click the edit link it should take me to a new page where i can edit that particular record only.....how do i go about it? I am using forms and no inbuilt ASP.NET controls except gridview....so i need to write queries for the same.....plz post code if possible
View 14 RepliesI do a gridview code that when displaying the information that come from the database is not showing any error at all, but is not displaying the right picture. The problem, I think, is that the (Eval("....") is not reading the values that are coming from the DataKeysNames. Due to this the right pictures are not displayed. But in another column, just for testing purposes I was able to display the values from DataKeysNames with the Eval. So I do not know what is going on and to make worse browser is not giving me any error. So, this is the line that is not processing, reading or executing well:
ImageUrl='<%# IIF( (Eval("TUDTIWasItemUpgraded")) = "Yes", string.Format("~/Images/ItemUpgradedTo.gif"), string.Format("~/Images/ItemNoUpgradedYet.gif") ) %>'
And this is the complete code for the GridView
<
asp:Panel
ID="DownlineUDTIGameClassifiedsViewPanel"
runat="server"
>
<asp:GridView
ID="DownlineUDTIGameClassifiedsViewGridView"
runat="server"
AutoGenerateColumns="False"
DataKeyNames="AutoNumber,TUDTIWasItemUpgraded"
DataSourceID="DownlineUDTIGameClassifiedsViewSqlDataSource"
CellPadding="4"
ForeColor="#333333"
AllowPaging="True"
PageSize="100"
OnDataBound="DownlineUDTIGameClassifiedsViewGridView_DataBound">
<FooterStyle
BackColor="#00693E"
Font-Bold="True"
ForeColor="White"
/>
<RowStyle
BackColor="#FFFBD6"
ForeColor="#333333"
/>
<PagerStyle
BackColor="White"
ForeColor="#333333"
HorizontalAlign="Center"
/>
<SelectedRowStyle
BackColor="#FFCC66"
Font-Bold="True"
ForeColor="Navy"
/>
<HeaderStyle
BackColor="#00693E"
Font-Bold="True"
ForeColor="White"
/>
<AlternatingRowStyle
BackColor="White"
/>
<PagerSettings
Mode="NextPreviousFirstLast"
Position="TopAndBottom"
/>
<Columns>
<asp:BoundField
ItemStyle-HorizontalAlign=Center
DataField="TUDTIGenerationNumber"
HeaderText="Generation"
SortExpression="TUDTIGenerationNumber"
/>
<asp:BoundField
DataField="TEnterDate"
HeaderText="Enter Date"
SortExpression="TEnterDate"
/>
<asp:BoundField
DataField="TItemTitle"
HeaderText="Listing Title"
SortExpression="TItemTitle"
/>
<custom:LongTextField
DataField="TListingComment"
Width="400px"
Height="75px"
HeaderText="Listing Comment"
HtmlEncode="false"
/>
<asp:TemplateField
HeaderText="Picture">
<ItemTemplate>
<asp:ImageButton
ID="ThumbNailImageButton"
runat="server"
Width="75px"
PostBackUrl='<%# string.Concat("~/Classifieds/DetailPage.aspx?AutoNumber=",Convert.ToString(Eval("AutoNumber")),"&FlagForm=NoSubmitted")
%>'
ImageUrl='<%# IIF(System.IO.File.Exists(Server.MapPath(string.Format("~/UploadedImagesClassifieds/{0}{1}",
Eval("AutoNumber"), "Pic1.jpg"))), string.Format("~/UploadedImagesClassifieds/{0}{1}", Eval("AutoNumber"), "Pic1.jpg"), "~/UploadedImagesClassifieds/NoPicture.gif") %>'
/>
</ItemTemplate>
<ItemStyle
HorizontalAlign="Center"
/>
</asp:TemplateField>
<asp:TemplateField
HeaderText="Item Upgraded To">
<ItemTemplate>
<asp:Image
ID="XItemUpgradedToPicture"
ImageUrl='<%# IIF( (Eval("TUDTIWasItemUpgraded")) = "Yes", string.Format("~/Images/ItemUpgradedTo.gif"),
string.Format("~/Images/ItemNoUpgradedYet.gif") ) %>'
runat="server"
Width="150px"/>
</ItemTemplate>
<ItemStyle
HorizontalAlign="Center"
/>
</asp:TemplateField>
<asp:TemplateField
HeaderText="Testing">
<ItemTemplate>
<asp:Label
ID="Label1"
runat="server"
Text='<%# Eval("TUDTIWasItemUpgraded") %>'
>
</asp:Label>
</ItemTemplate>
<ItemStyle
HorizontalAlign="Center"
/>
</asp:TemplateField>
<asp:TemplateField
HeaderText="Item Upgraded To">
<ItemTemplate>
<asp:Image
ID="ItemUpgradedToPicture"
ImageUrl="~/Images/ItemUpgradedTo.gif"
runat="server"
Width="150px"/>
</ItemTemplate>
<ItemStyle
HorizontalAlign="Center"
/>
</asp:TemplateField>
</Columns>
</asp:GridView>
I am using a Datalist and a Listview in a Master/Detail relationship. Each time a DataList item is bound, a Listview is loaded dynamically. I have provided the relevant Layout and Item templates. It is worked fine for one item. But for more than one item, it will raise the following error: "An item placeholder must be specified on ListView 'ItemListView'. Specify an item placeholder by setting a control's ID property to "MyLayout$itemPlaceholder". The item placeholder control must also specify runat="server".
Despite having set up the item placeholder.
Here is the code-behind:
protected void NodeDataList_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)[code].....
The Layout template:<asp:PlaceHolder ID="itemPlaceholder" runat="server"></asp:PlaceHolder>
I made my own master-detail pages using a listview. Rather than url, I use a listview event to set a session variable and response.redirect to the detail page, which on Page Load, loads the data from the database using the session variable, where it can then be edited. The details page is basically just text boxes and dropdownlists, but I used some third party controls and it all looks really sharp.
Here is the corner I pained myself into. Several dependent dropdowns on the master page filter the main listview. If I go back to the master page using response.redirect, the user would have to use the dropdowns again just to get back to where they were before they went to the details page. This is just not going to work.
To further complicate things, I wanted the master page to have paging on it. So if a back button reloads the page, they would have to set the dropdowns again, and page through the data again if needed. Egads.
The closest I have come to working is using a javascript back back button, but this fails after some postbacks on the details page (that are needed). And of course, the master page isn't refreshed when you go back to it (but I could probably live with that).
I try to use gridview with hyperlink button. once I extract field and put it into gridview there's a field which is TIME(eg. 10:20:00 PM) causes the link not to show out. Is there any way to encode the URL base on the TIME field. Here is my code.
[Code]....
I have a gridview inside update pannel and i enabled sorting for the grid if i click to sort a column it does postback and then the grid doesn't show in anather way i have item template column inside of the grid and i am using a button to call a function ,if i click on this button it do the function but the grid doesn t show after the post back
View 4 RepliesI would like to make the datagrid bound column to redirecting to the details page .
For example , when my mouse over certain row of bound column in datagrid , it will change the colour to blue . Also , I can click anywhere of the row and the will redirect to the detail page .
Notes : I do not want to use hyperlink column and do not want to fix the text for every row. I want to use datafield, CommandName and CommandArguement.
I'm trying to set paging on my gridview but when i click on a page it doesn't work. It return a blank page. Here's my code:
[Code]....
Behind code:
[Code]....
I have two tables. One table containing 1 master record and the other table containing multiple records per 1 master record. I want to only display in a gridview (or whatever is best) the master record AND its assocated detail records IF certain fields in the detail records are there. I have been trying to figure out how to do this but I am still a bit of a newbie and I don't how I can do this.
View 9 Repliesarticle on binding to a list and I've got that working fine on one view. But what I'm stuck when doing it off a master record. Everything seems to work except that when I look in the database the detail records previous associated with the current master have their Foriegn key to master set to Null and a new set of detail records have been inserted. I've got a really simple form for this object
[Code]....
The form collection comes back with the expected prefixes:
[Code]....
And the Controller.UpdateModel(master) binds all the properties correctly. But when I call dbContext.SaveChanges it issues the follow sql from sql profiler (psuedo code)
[Code]....
I've got a work around that works but it's pretty hackish and I'm currently not matching up the keys so it's dependent on everything coming back in the right order. Plus I've got to include all the fields that I want updated.
[Code]....
I thought that entity framework's code first was the culprite but I've unit test that and it works fine. I've got a feeling that UpdateModel is somehow removing and re-adding the children. Has anyone else got this to work? Of course, I could throw in the towel and parse the indexed field names myself, but I'm so close!
I have a link button in my gridview. It is populating correctly; however, being I am populating the values in the gridview using "Eval()" method I don't know how to get the value of the selected Link Button (which is only selected by a user actually clicking
the Link Button).
The user can click on the text directly (instead of showing the "Select" auto created). I want to be able to capture the item they have clicked on's Text property.
Example:Column 1
Value1
Value2
Value3
When the click on "Value2" I want the text property to be stored in a string variable (In this case the text would be "Value2"). In the past I have captured this through GridView.SelectedValue; however, I am not using autopopulate selected button so I need to do this manually and I am unsure as to how I will do this.
Here is my code for HTML and I have not created any code for C# (I want to capture the item using C# in my Grd_Tables_SelectedIndexChanged Event)
[code]....
So I followed Scot Mitchell's tutorial from asp.net/learn on adding a checkbox column to be able to select multiple entries and delete them with the click of a button. When I make my selection and click the button it works on the database end, as the desired entries are deleted. However, the entries remain on the page after it reloads. if I refresh the page it's updated properly but I'd like it to automatically update after the button is clicked.
Also, I tried his method for adding check/uncheck all buttons to the top of the gridview and they don't seem to be working either.
Here's the code behinf from the gridview page:
[Code]....
Im using Visual Web Developer 2010 , ASP.NET and VB
Im using the "ASPNETDB.MDF" database for membership and others ,
1-- i created a gridview in my masterpage
2-- Connected to to " ASPNETDB.MDF" and "asp_Users Table"
3 -- Selected all
4-- My Select the Field "UserName"
Now im trying to get the On-line Users .
Im having a problem , becouse i can't see it when i debug the page, i changed the font , background color , i havent got any erros , what i need to do ?