MVC :: Create A Details View That Also Contains A List?

Mar 30, 2011

How would i create a details view that also contains a list?

My aim is to have a details view that displays information about a person and then have a list on the same page that displays facts about that person.

Currently, my details view is working fine. I just need to add the list part. The details view inherits Models.MyViewModel which is a custom class as the details come from multiple tables.

View 1 Replies


Similar Messages:

Web Forms :: Set Value Of Drop Down List To Value Of Label In Details View?

May 4, 2010

I have a details view that's part of a master/details scenario. When a record is selected it shows the details view. The Pay Status field is a label at this point, when the details view is in read only mode. But then when the edit button is clicked the Pay Status is a DDL that has it's items list populated declaratively.

I want the DDL to default to the text value of the label. This will be hourly or salary. This way if the user doesn't change it's value it will push the correct value to the db.

I tried something with the PreRender event but couldn't get it to work out. Below is what i have so far I wasn't sure how to assign the text property of the label or bind to the label to get the value and set that for the DataTextField.

[Code]....

[Code]....

View 3 Replies

.NET Model-View-Presenter And List Versus Details?

Jan 26, 2010

In Model-View-Presenter what is the correct pattern to do a page that:
a) contains a grid for browsing a list of items

b) an alternate mode for editing single items .maybe you are toggling between two asp:panels.

Do you just make the presenter smart enough to do two types of presentations?
Make 2 presenters?

I'm new to this pattern and want to do it correctly. I understand how I would do this functionality on two pages. Just not sure what is the accepted practice when the browse and detail exist on the same page.

View 1 Replies

AJAX :: Can A Details View In The Modal Pop Up Control Be Style Like A Regular Details View

May 12, 2010

I'm thinking of using a modal pop up control that would have a details view in it. I currently have a details view that uses CSS Friendly control adapters with the CssSelectorClass attribute. Can I use the CSS friendly CssSelectorClass property with a details view in the modal pop up and style it as I'm currently doing with my Details View?

View 1 Replies

Forms Data Controls :: Add DropDown List In Details View Update?

Nov 10, 2010

I want to add a drop down list so that on update a user has to select something from a list rather then free text

ive googled and come across loads of info on this but i cant get anything to work

this is my aspx code so far, its the Description column i want to set as a drop down list

[code]....

View 8 Replies

Forms Data Controls :: Showing User Details With List View?

Nov 26, 2010

Here is my scenario.There is a users table and each user has multiple addresses(one to many) and I want to dispalay them like the image provided below

using listview only.I am really stuck with the deign of the page.There is a show and hide feature also.I can use only list view that is my requirement.

[code]....

View 2 Replies

Forms Data Controls :: Dropdown List Not Passing Info To Details View?

Jan 12, 2010

'm using a textbox to get the first 5 letters of the name.

An sqldatasource then finds the people who have names > than the five letters and picks up their ID numbers as well as their names.

After that I use a second sqldatasource to get one individual from that dropdownlist's persons name and id number and then using a detailsview I display that person.

Well both sqldatasouces work fine but it just does not pass the ID number when I debug it.

View 9 Replies

Forms Data Controls :: Drop Down List Values Are Lost When Cancel Is Clicked On Details View?

May 12, 2010

I have a detailsview which includes a drop down list bound to an array. However, when I click on the cancel button the dropdownlist values disappear. I have tried to solve the problem by rebinding the values back into list on the cancel command event, but this has made no difference. Does anyone know how to solve this?

View 2 Replies

Forms Data Controls :: How To Refresh The Dropdown List In The Details View After The Gridview Item Has Been Deleted

Nov 16, 2010

I have a dropdown list within a details view that allows me to set 1 or many categories to a perticular record(in this case a photo). The select command in this case only displays those catetegories that are not already attached to the selected photo.

all works well and as you select a category and add it to the database the category is removed from the dropdown list and is added to a gridview which shows all categories that photo is stored with.

My Problem is that when i delete the category from the gridview the dropdown list does not delete with said deleted item unless i do a "click in URL bar and press enter" to totally refresh the page.....

how to refresh the dropdown list in the details view after the gridview item has been deleted?

[code]....

View 5 Replies

Forms Data Controls :: How To Replace Data That Is In Details View, Details View Will Not Save Empty/null Value

Apr 28, 2010

I have a vb.net page that has a editable detailsview. When a user wants to erase the data for a field, they highlight the data, and delete/backspace over it, and click update. However, the original data is still saved. If they are replacing the current data with new data, that works fine and updates/saves correctly. This problem only happens when the current data needs to be removed.

View 6 Replies

Forms Data Controls :: Making A Gridview Show Details With A Details View

Apr 12, 2010

I have on a page a gridview that can be filtered with one text box. I set up the gridview to show select and wanted to then connect a details view so that when you selected a row the entire details would show up. When I run it I get this error. Data keys must be specified on GridView 'GridView1' before the selected data keys can be retrieved. Use the DataKeyNames property to specify data keys.

<%@ Page language="C#" masterpagefile="MainContent.master" title="Electrical Storage" EnableEventValidation="false" %>
<asp:Content id="Content1" runat="server" contentplaceholderid="Content">
<div id="Rightside">
<h2>Search Electrical Storage
</h2>
<li><a href="EStorageResultsAll.aspx">View All Files</a></li>
<li>Specify Projects to View</li>
<br />
<br />
<form>
Search: <asp:TextBox id="Search" runat="server"></asp:TextBox>
(% is wildcard)<br /><br />
<asp:Button runat="server" Text="Search" id="Button1"
PostBackUrl="electrical_storage.aspx" Height="26px" BackColor="#000066" ForeColor="White" Width="129px"></asp:Button>
<br />
<hr />
<asp:GridView id="GridView1" runat="server" AutoGenerateColumns="False" BackColor="#CCCCCC" BorderColor="#999999" BorderStyle="Solid" BorderWidth="3px" CellPadding="4" CellSpacing="2" DataSourceID="AccessDataSource1" ForeColor="Black" Width="820px" AllowSorting="True">
<RowStyle BackColor="White" />
<Columns>
<asp:commandfield ShowSelectButton="True">
</asp:commandfield>
<asp:boundfield DataField="CoID" HeaderText="Co ID" SortExpression="CoID">
</asp:boundfield>
<asp:boundfield DataField="ProjClass" HeaderText="Project Class" SortExpression="ProjClass">
</asp:boundfield>
<asp:boundfield DataField="Project" HeaderText="Project" SortExpression="Project">
</asp:boundfield>
<asp:boundfield DataField="FileName" HeaderText="File Name" SortExpression="FileName">
</asp:boundfield>
<asp:boundfield DataField="FileAddInfo" HeaderText="File Add Info" SortExpression="FileAddInfo" Visible="False">
</asp:boundfield>
<asp:boundfield DataField="FileNumber" HeaderText="File Number" SortExpression="FileNumber" Visible="False">
</asp:boundfield>
<asp:boundfield DataField="BoxNumber" HeaderText="Box Number" SortExpression="BoxNumber" Visible="False">
</asp:boundfield>
<asp:boundfield DataField="Location" HeaderText="Location" SortExpression="Location" Visible="False">
</asp:boundfield>
</Columns>
<FooterStyle BackColor="#CCCCCC" />
<PagerStyle BackColor="#CCCCCC" ForeColor="Black" HorizontalAlign="Left" />
<SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#000066" Font-Bold="True" ForeColor="White" />
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="\Elec1DATABASEStorageElectricalFilesBook.mdb" SelectCommand="SELECT [CoID], [ProjClass], [Project], [FileName], [FileAddInfo], [FileNumber], [BoxNumber], [Location] FROM [FilesWithLocation]
WHERE (([CoID] LIKE '%' + ? + '%') OR ([ProjClass] LIKE '%' + ? + '%') OR ([Project] LIKE '%' + ? + '%')OR ([FileName] LIKE '%' + ? + '%')OR ([FileAddInfo] LIKE '%' + ? + '%')OR ([BoxNumber] LIKE '%' + ? + '%'))">
<SelectParameters>
<asp:controlparameter ControlID="Search" Name="CoID" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="ProjClass" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="Project" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="FileName" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="FileAddInfo" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="FileNumber" PropertyName="Text" Type="String" />
<asp:controlparameter ControlID="Search" Name="BoxNumber" PropertyName="Text" Type="String" />
</SelectParameters>
</asp:AccessDataSource>
<asp:AccessDataSource id="AccessDataSource2" runat="server" DataFile="\Elec1DATABASEStorageElectricalFilesBook.mdb" SelectCommand="SELECT * FROM [FilesWithLocation] WHERE ([SearchString] = ?)">
<SelectParameters>
<asp:controlparameter ControlID="GridView1" Name="SearchString" PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:AccessDataSource>
<asp:DetailsView id="DetailsView1" runat="server" AutoGenerateRows="False" DataSourceID="AccessDataSource2" Height="50px" Width="442px">
<Fields>
<asp:boundfield DataField="CoID" HeaderText="Company ID" SortExpression="CoID">
</asp:boundfield>
<asp:boundfield DataField="ProjClass" HeaderText="Project Class" SortExpression="ProjClass">
</asp:boundfield>
<asp:boundfield DataField="Project" HeaderText="Project" SortExpression="Project">
</asp:boundfield>
<asp:boundfield DataField="FileName" HeaderText="File Name" SortExpression="FileName">
</asp:boundfield>
<asp:boundfield DataField="FileAddInfo" HeaderText="File Additional Info" SortExpression="FileAddInfo">
</asp:boundfield>
<asp:boundfield DataField="PeriodBegin" DataFormatString="{0:d}" HeaderText="Period Begin" SortExpression="PeriodBegin">
</asp:boundfield>
<asp:boundfield DataField="PeriodEnd" DataFormatString="{0:d}" HeaderText="Period End" SortExpression="PeriodEnd">
</asp:boundfield>
<asp:boundfield DataField="FileType" HeaderText="File Type" SortExpression="FileType">
</asp:boundfield>
<asp:boundfield DataField="FileNumber" HeaderText="File Number" SortExpression="FileNumber">
</asp:boundfield>
<asp:boundfield DataField="BoxNumber" HeaderText="Box Number" SortExpression="BoxNumber">
</asp:boundfield>
<asp:boundfield DataField="SearchString" HeaderText="Search String" ReadOnly="True" SortExpression="SearchString">
</asp:boundfield>
<asp:boundfield DataField="Location" HeaderText="Location" SortExpression="Location">
</asp:boundfield>
</Fields>
</asp:DetailsView>
</form>
</div>
</asp:Content>
<asp:Content id="Content2" runat="server" contentplaceholderid="head">
<style type="text/css">
table {
width: 820px;
}
.gridview {
width: 820px;
position: fixed;
}
</style>
</asp:Content>

View 5 Replies

Forms Data Controls :: Details View That's Part Of A Master / Details Be Opened Up In A Modal Window?

Apr 11, 2010

I have a details view that appears when record is selected in a GridView. Can this details view be opened in it's own modal window that would allow me to use the full event model?

View 3 Replies

Data Controls :: Display Details Of GridView Row In Details View

Jan 20, 2014

I have a gridview which display when person start n stop the project if same person do muliple projects it save n retrives eaisly i want to do that when i press select in gridview it give me the all about the person means if ali is working on 2 projects so it give me details like ali firsrt project is this time n date this , second project is this how can i do this ?

View 1 Replies

MVC ::  How To Create The View If I Want To Bind A List<stored_procedure_name>

Feb 26, 2010

When I try to bind code that calls a stored proceure as a List to a view I get :-

The model item passed into the dictionary is of type 'System.Collections.Generic.List` but this dictionary requires a model item of type 'System.Collections.Generic.IEnumerable`

How do I create the view if I want to bind a List<stored_procedure_name>?

View 9 Replies

MVC :: Way To Create A List Type View From A GroupBy Clause

Jan 6, 2010

I can select IQueryable<object-type> data fine from a data repository class and push it into a list type MVC view, but how do I do this and group that data - I don't seem to be able to find any examples on this.

View 9 Replies

C# - How To Dynamically Build A List Of Objects In A Create View

Jul 9, 2010

I have an Employee model that has a Name and Company

I want to be able to build multiple Employees in one CREATE view. I figured I need to create an IList<Employee> and do something like:

<%= Html.TextBoxFor(m => m[0].Name) %>
<%= Html.TextBoxFor(m => m[0].Company) %>
<%= Html.TextBoxFor(m => m[1].Name) %>
<%= Html.TextBoxFor(m => m[1].Company) %>

If a user clicks on "Add another employee", I want the view to make another form for the new employee:

<%= Html.TextBoxFor(m => m[3].Name) %>
<%= Html.TextBoxFor(m => m[3].Company) %>

And continue to add form items (and increment the array index if they click on it again).

Keep in mind that I need to build the form and the list dynamically in the create view. I don't already have a populated list of Employees.

View 1 Replies

Web Forms :: How To Create A List View That Displays Item Circularly

Aug 3, 2010

i need to create a list view that displays items circularly. (that is when the top most item is hiding a new item should appear at the bottom)

View 2 Replies

Forms Data Controls :: How To Create List Or Grid View

Dec 3, 2010

I'm trying to create a list (customized grid) with data pulled from the database and display it to the user in a format that looks very much like a forum thread and replies or posts.Which each of these "posts" I require to have buttons specific to that particular column to edit, delete etc.

View 2 Replies

Forms Data Controls :: How To Create Uniform List View

Feb 2, 2011

I am an ASP newbie and I am trying to create a listview with rows and columns that are the same height on every page, rather than shifting when you click the Next button. Is there a style or something you use when you create the listview?

View 5 Replies

Forms Data Controls :: Create List View To Provide Functionality

Apr 26, 2010

I am trying to create a list view to provide functionality similiar to the pages in this article(will end up being much simpler in my case)

[URL]

Basically I need three columns. Column 1 will be populated on page load with a list of user names and some data. Clicking on a user from column 1 will query for data regarding that user and bring back multiple rows to be displayed in Column 2. Clicking on data from a row in column 2 will return rows to be displayed in column 3. I am just curious as to how some of you guys would approach this. Ive looked at grouping templates and some articles regarding listviews with multiple rows but. Would it be easier to use 3 seperate listviews? Any ideas or articles to point me in the right direction?

View 2 Replies

Forms Data Controls :: Details View Not Showing Data In Master / Details

Jun 26, 2010

I'm trying to get a record to show up in a details view as part of a Master Details. I was able to get this to work by setting the visibility to true for the Details View in the Page Load event. I now want the details view to show up when the Select button is clicked in the GridView's template field using the onClick event for the button. I don't seem to be assigning the correct properties to get this to work though. what property I should use with this? I know I have to get it from the GridView and assign it to the details but haven't gotten it to work. this is the GridView:

[Code]....

View 4 Replies

Accessing Details View Bind Data Before The View Is Rendered

Feb 25, 2011

I have a field in a details view shown below

<asp:BoundField DataField="DTMON_F" HeaderText="Monday Hours From: " InsertVisible="False"
ReadOnly="True" SortExpression="HOURS" Visible="false" />
<asp:TemplateField HeaderText="Monday Hours From: " SortExpression="HOURS">
<EditItemTemplate>
<uc1:TimePicker ID="tpMondayHours" runat="server"/>
</EditItemTemplate>
<InsertItemTemplate>
<%-- <uc1:TimePicker runat="server" ID="tpMondayHours" />--%>
<asp:TextBox ID="txtMondayHours" runat="server" Text='<%# Bind("DTMON_F") %>'></asp:TextBox>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="lblMondayHours" runat="server" Text='<%# Bind("DTMON_F") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>

Before "DTMON_F" is binded to the view I want to cut the string that is returned...Where and how might I do this?

View 1 Replies

Forms Data Controls :: List.aspx:datagridview Change The Links To Parent Table From Details To List?

Sep 29, 2010

The List Page display child Entity using the gridview each row will have link to the parent

How can I change the link so it shows the parent but in list view(using list.aspx) not detailes (detailes.aspx)view

View 1 Replies

State Management :: Grab A List View's Page And Reset The List View When Returning From A Different Page

Apr 12, 2010

I'm having troubles remembering how to grab the list view's state, or page, so that when you leave the list, you can return to the list view page you left on. I have a data pager, and I have hyplerlinks for items in the list view that take you to a file upload or file delete page, and then returns to the list view. It returns to the list view's initial state (first page).

View 1 Replies

Using File Upload In Details View

Jan 4, 2011

I am trying to use a fileupload, to add rows to my gridview on this page. This page is basically a simple admin panel where I can add data to my database. The file upload is used to grab the path of the file and upload the path to the database not the file. The problem is whenever i run my program pick a file, it uploads fine expect the path shows up as true not as the path. the gridview and details view both use the same sqladapater

<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server" />
<br />
<asp:DropDownList ID="DropDownList1" runat="server">
<asp:ListItem>MSD</asp:ListItem>
<asp:ListItem>OPS</asp:ListItem>
</asp:DropDownList>
<asp:Button ID="Button3" runat="server" Text="Department" />
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="New" /> <asp:Button
ID="Button4" runat="server" Text="Cancel" />
<br />
<br />
<div>
<asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional">
<ContentTemplate>
<center> <asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True" AutoGenerateRows="False"
DataKeyNames="ID" DataSourceID="SqlDataSource1" Height="128px" Width="544px" Visible="False" CellPadding="4" ForeColor="#333333" GridLines="None" OnModeChanged="Button1_Click" >
<Fields>
<asp:TemplateField HeaderText="Order" SortExpression="Order">
<EditItemTemplate>
<asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("Order") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Order") %>'></asp:TextBox>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label3" runat="server" Text='<%# Bind("Order") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Department" SortExpression="Department">
<EditItemTemplate>
<asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("Department") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="textboxdepartment" runat="server" Text='<%# Bind("Department") %>'></asp:TextBox>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label4" runat="server" Text='<%# Bind("Department") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="DOC_Type" SortExpression="DOC_Type">
<EditItemTemplate>
<asp:TextBox ID="TextBox5" runat="server" Text='<%# Bind("DOC_Type") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="textboxtype" runat="server" Text='<%# Bind("DOC_Type") %>'></asp:TextBox>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label5" runat="server" Text='<%# Bind("DOC_Type") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" />
<asp:TemplateField HeaderText="Revision" SortExpression="Revision">
<EditItemTemplate>
<asp:TextBox ID="TextBox6" runat="server" Text='<%# Bind("Revision") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="TextBox5" runat="server" Text='<%# Bind("Revision") %>'></asp:TextBox>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="textboxrevision" runat="server" Text='<%# Bind("Revision") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="DOC">
<EditItemTemplate>
<asp:TextBox ID="textboxdate" runat="server" Text='<%# Bind("DOC") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:FileUpload ID="FileUploadDOC" runat="server" Width="384px" Enabled='<%# Bind("DOC") %>' />
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("DOC") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Active" SortExpression="Active">
<EditItemTemplate>
<asp:TextBox ID="TextBox7" runat="server" Text='<%# Bind("Active") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="TextBox6" runat="server" Text='<%# Bind("Active") %>'></asp:TextBox>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label7" runat="server" Text='<%# Bind("Active") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Rev_Date" SortExpression="Rev_Date">
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Rev_Date") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Rev_Date") %>'></asp:TextBox>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("Rev_Date") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True"
SortExpression="ID" Visible="False" />
<asp:CommandField ShowInsertButton="True" ShowCancelButton="False" />
</Fields>
<FooterStyle BackColor="#5D7B9D" BorderStyle="None" Font-Bold="True" ForeColor="White" />
<CommandRowStyle BackColor="#E2DED6" BorderStyle="None" Font-Bold="True" />
<RowStyle BackColor="#F7F6F3" BorderStyle="None" ForeColor="#333333" />
<FieldHeaderStyle BackColor="#E9ECF1" BorderStyle="None" Font-Bold="True" />
<EmptyDataRowStyle BorderStyle="None" />
<PagerStyle BackColor="#284775" BorderStyle="None" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#5D7B9D" BorderStyle="None" Font-Bold="True" ForeColor="White" />
<InsertRowStyle BorderStyle="None" />
<EditRowStyle BackColor="#999999" BorderStyle="None" />
<AlternatingRowStyle BackColor="White" BorderStyle="None" ForeColor="#284775" />
</asp:DetailsView>
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ID"
DataSourceID="SqlDataSource1">
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
<asp:BoundField DataField="Order" HeaderText="Order" SortExpression="Order" />
<asp:BoundField DataField="Department" HeaderText="Department" SortExpression="Department" />
<asp:BoundField DataField="DOC_Type" HeaderText="DOC_Type" SortExpression="DOC_Type" />
<asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" />
<asp:BoundField DataField="Revision" HeaderText="Revision" SortExpression="Revision" />
<asp:BoundField DataField="DOC" HeaderText="DOC" SortExpression="DOC" />
<asp:BoundField DataField="Active" HeaderText="Active" SortExpression="Active" />
<asp:BoundField DataField="Rev_Date" HeaderText="Rev_Date" SortExpression="Rev_Date" />
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True"
SortExpression="ID" Visible="False" />
</Columns>
</asp:GridView>
<br />
</ContentTemplate>
</asp:UpdatePanel>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:CABCIntranetConnectionString %>"
DeleteCommand="DELETE FROM [sop] WHERE [ID] = @original_ID AND (([Order] = @original_Order) OR ([Order] IS NULL AND @original_Order IS NULL)) AND (([Department] = @original_Department) OR ([Department] IS NULL AND @original_Department IS NULL)) AND (([DOC Type] = @original_DOC_Type) OR ([DOC Type] IS NULL AND @original_DOC_Type IS NULL)) AND (([Title] = @original_Title) OR ([Title] IS NULL AND @original_Title IS NULL)) AND (([Revision] = @original_Revision) OR ([Revision] IS NULL AND @original_Revision IS NULL)) AND (([DOC] = @original_DOC) OR ([DOC] IS NULL AND @original_DOC IS NULL)) AND (([Rev Date] = @original_Rev_Date) OR ([Rev Date] IS NULL AND @original_Rev_Date IS NULL)) AND (([Active] = @original_Active) OR ([Active] IS NULL AND @original_Active IS NULL))" InsertCommand="INSERT INTO [sop] ([Order], [Department], [DOC Type], [Title], [Revision], [DOC], [Rev Date], [Active]) VALUES (@Order, @Department, @DOC_Type, @Title, @Revision, @DOC, @Rev_Date, @Active)"
SelectCommand="SELECT [Order], [Department], [DOC Type] AS DOC_Type, [Title], [Revision], [DOC], [Rev Date] AS Rev_Date, [Active], [ID] FROM [sop] WHERE ([Department] = @Department) ORDER BY [Order]" UpdateCommand="UPDATE [sop] SET [Order] = @Order, [Department] = @Department, [DOC Type] = @DOC_Type, [Title] = @Title, [Revision] = @Revision, [DOC] = @DOC, [Rev Date] = @Rev_Date, [Active] = @Active WHERE [ID] = @original_ID AND (([Order] = @original_Order) OR ([Order] IS NULL AND @original_Order IS NULL)) AND (([Department] = @original_Department) OR ([Department] IS NULL AND @original_Department IS NULL)) AND (([DOC Type] = @original_DOC_Type) OR ([DOC Type] IS NULL AND @original_DOC_Type IS NULL)) AND (([Title] = @original_Title) OR ([Title] IS NULL AND @original_Title IS NULL)) AND (([Revision] = @original_Revision) OR ([Revision] IS NULL AND @original_Revision IS NULL)) AND (([DOC] = @original_DOC) OR ([DOC] IS NULL AND @original_DOC IS NULL)) AND (([Rev Date] = @original_Rev_Date) OR ([Rev Date] IS NULL AND @original_Rev_Date IS NULL)) AND (([Active] = @original_Active) OR ([Active] IS NULL AND @original_Active IS NULL))" ConflictDetection="CompareAllValues" OldValuesParameterFormatString="original_{0}">
<DeleteParameters>
<asp:Parameter Name="original_ID" Type="Int32" />
<asp:Parameter Name="original_Order" Type="Int32" />
<asp:Parameter Name="original_Department" Type="String" />
<asp:Parameter Name="original_DOC_Type" Type="String" />
<asp:Parameter Name="original_Title" Type="String" />
<asp:Parameter Name="original_Revision" Type="Int32" />
<asp:Parameter Name="original_DOC" Type="String" />
<asp:Parameter Name="original_Rev_Date" Type="String" />
<asp:Parameter Name="original_Active" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Order" Type="Int32" />
<asp:Parameter Name="Department" Type="String" />
<asp:Parameter Name="DOC_Type" Type="String" />
<asp:Parameter Name="Title" Type="String" />
<asp:Parameter Name="Revision" Type="Int32" />
<asp:Parameter Name="DOC" Type="String" />
<asp:Parameter Name="Rev_Date" Type="String" />
<asp:Parameter Name="Active" Type="String" />
<asp:Parameter Name="original_ID" Type="Int32" />
<asp:Parameter Name="original_Order" Type="Int32" />
<asp:Parameter Name="original_Department" Type="String" />
<asp:Parameter Name="original_DOC_Type" Type="String" />
<asp:Parameter Name="original_Title" Type="String" />
<asp:Parameter Name="original_Revision" Type="Int32" />
<asp:Parameter Name="original_DOC" Type="String" />
<asp:Parameter Name="original_Rev_Date" Type="String" />
<asp:Parameter Name="original_Active" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="Order" Type="Int32" />
<asp:Parameter Name="Department" Type="String" />
<asp:Parameter Name="DOC_Type" Type="String" />
<asp:Parameter Name="Title" Type="String" />
<asp:Parameter Name="Revision" Type="Int32" />
<asp:Parameter Name="DOC" Type="String" />
<asp:Parameter Name="Rev_Date" Type="String" />
<asp:Parameter Name="Active" Type="String" />
</InsertParameters>
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" DefaultValue="MSD" Name="Department"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
Imports System.Data.Sql
Imports System.Data.SqlClient
Imports System.Data
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
DetailsView1.Visible = True
DetailsView1.ChangeMode(DetailsViewMode.Insert)
Dim tbox As TextBox = TryCast(DetailsView1.FindControl("textbox1"), TextBox)
tbox.Text = DateTime.Now.ToShortDateString()
Dim tbox1 As TextBox = TryCast(DetailsView1.FindControl("textboxdepartment"), TextBox)
tbox1.Text = DropDownList1.SelectedItem.Text
Dim tbox2 As TextBox = TryCast(DetailsView1.FindControl("textbox6"), TextBox)
tbox2.Text = "True"
Dim tbox3 As TextBox = TryCast(DetailsView1.FindControl("textboxtype"), TextBox)
tbox3.Text = "S.O.P"
Dim tbox4 As TextBox = TryCast(DetailsView1.FindControl("textbox5"), TextBox)
tbox4.Text = "1"
Dim tbox5 As TextBox = TryCast(DetailsView1.FindControl("textbox2"), TextBox)
tbox5.Text = GridView1.Rows.Count + 1
End Sub
Protected Sub Button3_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button3.Click
UpdatePanel1.Update()
End Sub
Protected Sub Button4_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button4.Click
DetailsView1.Visible = False
End Sub
End Class

View 1 Replies







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