Notifikationer

Markér alle som læst Log ud

ktolbod Nybegynder

28. marts 2006 - 12:50 Der er 7 kommentarer og
1 løsning

Binde Gridview sammen med Formview via templatefield i gridview.

Hey,

Hvordan binder jeg et gridview sammen med et formview i editmode ved hjælp at et link i et templatefield i gridview'et?

Synes godt om

dr_chaos Nybegynder

28. marts 2006 - 13:42 #1

du kan gøre på forskellige måde.

Du kan sætte Formview.Selecteddatakey eller noget i den stil.
Prøv lige at paste din kode.

Synes godt om

ktolbod Nybegynder

28. marts 2006 - 14:24 #2

I bund og grund er mit problem at jeg mangler noget struktur på min side tror jeg.

Jeg har 3 gridviews og 3 formviews.

Et gridview "gridviewArtist", hvor der er en select og en edit knap. Trykker man på Select kommer der nedenunder et gridview "gridviewAlbums" med artistens albums. I "gridviewAlbums" kan man også trykke på select eller edit og trykker man på select
kommer der et gridviewTracks med albummets sange.
Trykker man derimod på edit knappen i f.eks. "gridviewTracks" skal man så kunne redigere sangen via et formview og så fremdeles også med edit knappen i "gridviewAlbums" og ""gridviewArtist".

Lige nu har jeg det hele i en fil, hvor jeg så bruger "FormViewAlbums.Visible = False" til at skjule de forskellige FormViews fra hinanden. Men jeg har på fornemmelsen at det ikke er en særlig optimal måde at gøre det på.

I VWD er min design visning er noget rod pga alle de grids og formvies oven i hinanden.

Jeg ved godt det var noget af en smøre, men håber der er nogen som forstår hvad jeg mener og har en ide til en bedre struktur?

Synes godt om

dr_chaos Nybegynder

28. marts 2006 - 14:27 #3

Jeg tror det er nemmere hvis du paster din kode.
Lyder som om den kan optimeres.

Synes godt om

ktolbod Nybegynder

28. marts 2006 - 14:36 #4

<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="Artist.aspx.vb" Inherits="Artist" title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<div class="ContentDiv">

Add Artist | Add Album

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" Style="z-index: 100;
left: 20px; position: absolute; top: 69px" DataKeyNames="ArtistID">
<Columns>
<asp:BoundField DataField="Artistname" HeaderText="Artists" SortExpression="Artistname" />
<asp:CommandField ShowSelectButton="True" />
</Columns>
</asp:GridView>
  

<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataKeyNames="ArtistID,AlbumID"
DataSourceID="SqlDataSource2" Style="z-index: 101; left: 15px; position: absolute;
top: 180px">
<Columns>
<asp:BoundField DataField="AlbumTitle" HeaderText="Albums" SortExpression="AlbumTitle" />
<asp:CommandField ShowSelectButton="True" />
</Columns>
</asp:GridView>

 
 
<asp:FormView ID="FormView1" runat="server" DefaultMode="Edit" DataKeyNames="AlbumID,ArtistID" DataSourceID="SqlDataSource3"
Style="z-index: 102; left: 236px; position: absolute; top: 72px" Visible="False">
<EditItemTemplate>
AlbumID:
<asp:Label ID="AlbumIDLabel1" runat="server" Text='<%# Eval("AlbumID") %>'></asp:Label> 
ArtistID:
<asp:Label ID="ArtistIDLabel1" runat="server" Text='<%# Eval("ArtistID") %>'></asp:Label> 
MainGenreID:
<asp:TextBox ID="MainGenreIDTextBox" runat="server" Text='<%# Bind("MainGenreID") %>'>
</asp:TextBox> 
SubGenre1ID:
<asp:TextBox ID="SubGenre1IDTextBox" runat="server" Text='<%# Bind("SubGenre1ID") %>'>
</asp:TextBox> 
SubGenre2ID:
<asp:TextBox ID="SubGenre2IDTextBox" runat="server" Text='<%# Bind("SubGenre2ID") %>'>
</asp:TextBox> 
SubGenre3ID:
<asp:TextBox ID="SubGenre3IDTextBox" runat="server" Text='<%# Bind("SubGenre3ID") %>'>
</asp:TextBox> 
AlbumType:
<asp:TextBox ID="AlbumTypeTextBox" runat="server" Text='<%# Bind("AlbumType") %>'>
</asp:TextBox> 
AlbumTitle:
<asp:TextBox ID="AlbumTitleTextBox" runat="server" Text='<%# Bind("AlbumTitle") %>'>
</asp:TextBox> 
AlbumTitleVersion:
<asp:TextBox ID="AlbumTitleVersionTextBox" runat="server" Text='<%# Bind("AlbumTitleVersion") %>'>
</asp:TextBox> 
CatalogNumber:
<asp:TextBox ID="CatalogNumberTextBox" runat="server" Text='<%# Bind("CatalogNumber") %>'>
</asp:TextBox> 
EAN:
<asp:TextBox ID="EANTextBox" runat="server" Text='<%# Bind("EAN") %>'>
</asp:TextBox> 
YearOfRelease:
<asp:TextBox ID="YearOfReleaseTextBox" runat="server" Text='<%# Bind("YearOfRelease") %>'>
</asp:TextBox> 
DurantionInSec:
<asp:TextBox ID="DurantionInSecTextBox" runat="server" Text='<%# Bind("DurantionInSec") %>'>
</asp:TextBox> 
CopyrightYear:
<asp:TextBox ID="CopyrightYearTextBox" runat="server" Text='<%# Bind("CopyrightYear") %>'>
</asp:TextBox> 
CopyrightText:
<asp:TextBox ID="CopyrightTextTextBox" runat="server" Text='<%# Bind("CopyrightText") %>'>
</asp:TextBox> 
TotalNumberOfDiscs:
<asp:TextBox ID="TotalNumberOfDiscsTextBox" runat="server" Text='<%# Bind("TotalNumberOfDiscs") %>'>
</asp:TextBox> 
TotalTracksOnDiscs:
<asp:TextBox ID="TotalTracksOnDiscsTextBox" runat="server" Text='<%# Bind("TotalTracksOnDiscs") %>'>
</asp:TextBox> 
AlbumDescrShortLocal:
<asp:TextBox ID="AlbumDescrShortLocalTextBox" runat="server" Text='<%# Bind("AlbumDescrShortLocal") %>'>
</asp:TextBox> 
AlbumDescrShortEng:
<asp:TextBox ID="AlbumDescrShortEngTextBox" runat="server" Text='<%# Bind("AlbumDescrShortEng") %>'>
</asp:TextBox> 
AlbumDescrLongLocal:
<asp:TextBox ID="AlbumDescrLongLocalTextBox" runat="server" Text='<%# Bind("AlbumDescrLongLocal") %>'>
</asp:TextBox> 
AlbumDescrLongEng:
<asp:TextBox ID="AlbumDescrLongEngTextBox" runat="server" Text='<%# Bind("AlbumDescrLongEng") %>'>
</asp:TextBox> 
RecordedStudio:
<asp:TextBox ID="RecordedStudioTextBox" runat="server" Text='<%# Bind("RecordedStudio") %>'>
</asp:TextBox> 
RecordedPeriode:
<asp:TextBox ID="RecordedPeriodeTextBox" runat="server" Text='<%# Bind("RecordedPeriode") %>'>
</asp:TextBox> 
MixetStudio:
<asp:TextBox ID="MixetStudioTextBox" runat="server" Text='<%# Bind("MixetStudio") %>'>
</asp:TextBox> 
CoverDesigner:
<asp:TextBox ID="CoverDesignerTextBox" runat="server" Text='<%# Bind("CoverDesigner") %>'>
</asp:TextBox> 
Thanks:
<asp:TextBox ID="ThanksTextBox" runat="server" Text='<%# Bind("Thanks") %>'>
</asp:TextBox> 
Technician:
<asp:TextBox ID="TechnicianTextBox" runat="server" Text='<%# Bind("Technician") %>'>
</asp:TextBox> 
Master:
<asp:TextBox ID="MasterTextBox" runat="server" Text='<%# Bind("Master") %>'>
</asp:TextBox> 
Image:
<asp:TextBox ID="ImageTextBox" runat="server" Text='<%# Bind("Image") %>'>
</asp:TextBox> 
CoverFront:
<asp:TextBox ID="CoverFrontTextBox" runat="server" Text='<%# Bind("CoverFront") %>'>
</asp:TextBox> 
CoverBack:
<asp:TextBox ID="CoverBackTextBox" runat="server" Text='<%# Bind("CoverBack") %>'>
</asp:TextBox> 
Label:
<asp:TextBox ID="LabelTextBox" runat="server" Text='<%# Bind("Label") %>'>
</asp:TextBox> 
ReleaseDate:
<asp:TextBox ID="ReleaseDateTextBox" runat="server" Text='<%# Bind("ReleaseDate") %>'>
</asp:TextBox> 
SaleStartDate:
<asp:TextBox ID="SaleStartDateTextBox" runat="server" Text='<%# Bind("SaleStartDate") %>'>
</asp:TextBox> 
ForSale:
<asp:CheckBox ID="ForSaleCheckBox" runat="server" Checked='<%# Bind("ForSale") %>' /> 
Timemade:
<asp:TextBox ID="TimemadeTextBox" runat="server" Text='<%# Bind("Timemade") %>'>
</asp:TextBox> 
Timeedit:
<asp:TextBox ID="TimeeditTextBox" runat="server" Text='<%# Bind("Timeedit") %>'>
</asp:TextBox> 
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
Text="Update">
</asp:LinkButton>
<asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</EditItemTemplate>
<InsertItemTemplate>
AlbumID:
<asp:TextBox ID="AlbumIDTextBox" runat="server" Text='<%# Bind("AlbumID") %>'>
</asp:TextBox> 
ArtistID:
<asp:TextBox ID="ArtistIDTextBox" runat="server" Text='<%# Bind("ArtistID") %>'>
</asp:TextBox> 
MainGenreID:
<asp:TextBox ID="MainGenreIDTextBox" runat="server" Text='<%# Bind("MainGenreID") %>'>
</asp:TextBox> 
SubGenre1ID:
<asp:TextBox ID="SubGenre1IDTextBox" runat="server" Text='<%# Bind("SubGenre1ID") %>'>
</asp:TextBox> 
SubGenre2ID:
<asp:TextBox ID="SubGenre2IDTextBox" runat="server" Text='<%# Bind("SubGenre2ID") %>'>
</asp:TextBox> 
SubGenre3ID:
<asp:TextBox ID="SubGenre3IDTextBox" runat="server" Text='<%# Bind("SubGenre3ID") %>'>
</asp:TextBox> 
AlbumType:
<asp:TextBox ID="AlbumTypeTextBox" runat="server" Text='<%# Bind("AlbumType") %>'>
</asp:TextBox> 
AlbumTitle:
<asp:TextBox ID="AlbumTitleTextBox" runat="server" Text='<%# Bind("AlbumTitle") %>'>
</asp:TextBox> 
AlbumTitleVersion:
<asp:TextBox ID="AlbumTitleVersionTextBox" runat="server" Text='<%# Bind("AlbumTitleVersion") %>'>
</asp:TextBox> 
CatalogNumber:
<asp:TextBox ID="CatalogNumberTextBox" runat="server" Text='<%# Bind("CatalogNumber") %>'>
</asp:TextBox> 
EAN:
<asp:TextBox ID="EANTextBox" runat="server" Text='<%# Bind("EAN") %>'>
</asp:TextBox> 
YearOfRelease:
<asp:TextBox ID="YearOfReleaseTextBox" runat="server" Text='<%# Bind("YearOfRelease") %>'>
</asp:TextBox> 
DurantionInSec:
<asp:TextBox ID="DurantionInSecTextBox" runat="server" Text='<%# Bind("DurantionInSec") %>'>
</asp:TextBox> 
CopyrightYear:
<asp:TextBox ID="CopyrightYearTextBox" runat="server" Text='<%# Bind("CopyrightYear") %>'>
</asp:TextBox> 
CopyrightText:
<asp:TextBox ID="CopyrightTextTextBox" runat="server" Text='<%# Bind("CopyrightText") %>'>
</asp:TextBox> 
TotalNumberOfDiscs:
<asp:TextBox ID="TotalNumberOfDiscsTextBox" runat="server" Text='<%# Bind("TotalNumberOfDiscs") %>'>
</asp:TextBox> 
TotalTracksOnDiscs:
<asp:TextBox ID="TotalTracksOnDiscsTextBox" runat="server" Text='<%# Bind("TotalTracksOnDiscs") %>'>
</asp:TextBox> 
AlbumDescrShortLocal:
<asp:TextBox ID="AlbumDescrShortLocalTextBox" runat="server" Text='<%# Bind("AlbumDescrShortLocal") %>'>
</asp:TextBox> 
AlbumDescrShortEng:
<asp:TextBox ID="AlbumDescrShortEngTextBox" runat="server" Text='<%# Bind("AlbumDescrShortEng") %>'>
</asp:TextBox> 
AlbumDescrLongLocal:
<asp:TextBox ID="AlbumDescrLongLocalTextBox" runat="server" Text='<%# Bind("AlbumDescrLongLocal") %>'>
</asp:TextBox> 
AlbumDescrLongEng:
<asp:TextBox ID="AlbumDescrLongEngTextBox" runat="server" Text='<%# Bind("AlbumDescrLongEng") %>'>
</asp:TextBox> 
RecordedStudio:
<asp:TextBox ID="RecordedStudioTextBox" runat="server" Text='<%# Bind("RecordedStudio") %>'>
</asp:TextBox> 
RecordedPeriode:
<asp:TextBox ID="RecordedPeriodeTextBox" runat="server" Text='<%# Bind("RecordedPeriode") %>'>
</asp:TextBox> 
MixetStudio:
<asp:TextBox ID="MixetStudioTextBox" runat="server" Text='<%# Bind("MixetStudio") %>'>
</asp:TextBox> 
CoverDesigner:
<asp:TextBox ID="CoverDesignerTextBox" runat="server" Text='<%# Bind("CoverDesigner") %>'>
</asp:TextBox> 
Thanks:
<asp:TextBox ID="ThanksTextBox" runat="server" Text='<%# Bind("Thanks") %>'>
</asp:TextBox> 
Technician:
<asp:TextBox ID="TechnicianTextBox" runat="server" Text='<%# Bind("Technician") %>'>
</asp:TextBox> 
Master:
<asp:TextBox ID="MasterTextBox" runat="server" Text='<%# Bind("Master") %>'>
</asp:TextBox> 
Image:
<asp:TextBox ID="ImageTextBox" runat="server" Text='<%# Bind("Image") %>'>
</asp:TextBox> 
CoverFront:
<asp:TextBox ID="CoverFrontTextBox" runat="server" Text='<%# Bind("CoverFront") %>'>
</asp:TextBox> 
CoverBack:
<asp:TextBox ID="CoverBackTextBox" runat="server" Text='<%# Bind("CoverBack") %>'>
</asp:TextBox> 
Label:
<asp:TextBox ID="LabelTextBox" runat="server" Text='<%# Bind("Label") %>'>
</asp:TextBox> 
ReleaseDate:
<asp:TextBox ID="ReleaseDateTextBox" runat="server" Text='<%# Bind("ReleaseDate") %>'>
</asp:TextBox> 
SaleStartDate:
<asp:TextBox ID="SaleStartDateTextBox" runat="server" Text='<%# Bind("SaleStartDate") %>'>
</asp:TextBox> 
ForSale:
<asp:CheckBox ID="ForSaleCheckBox" runat="server" Checked='<%# Bind("ForSale") %>' /> 
Timemade:
<asp:TextBox ID="TimemadeTextBox" runat="server" Text='<%# Bind("Timemade") %>'>
</asp:TextBox> 
Timeedit:
<asp:TextBox ID="TimeeditTextBox" runat="server" Text='<%# Bind("Timeedit") %>'>
</asp:TextBox> 
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
Text="Insert">
</asp:LinkButton>
<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</InsertItemTemplate>
<ItemTemplate>
AlbumID:
<asp:Label ID="AlbumIDLabel" runat="server" Text='<%# Eval("AlbumID") %>'></asp:Label> 
ArtistID:
<asp:Label ID="ArtistIDLabel" runat="server" Text='<%# Eval("ArtistID") %>'></asp:Label> 
MainGenreID:
<asp:Label ID="MainGenreIDLabel" runat="server" Text='<%# Bind("MainGenreID") %>'>
</asp:Label> 
SubGenre1ID:
<asp:Label ID="SubGenre1IDLabel" runat="server" Text='<%# Bind("SubGenre1ID") %>'>
</asp:Label> 
SubGenre2ID:
<asp:Label ID="SubGenre2IDLabel" runat="server" Text='<%# Bind("SubGenre2ID") %>'>
</asp:Label> 
SubGenre3ID:
<asp:Label ID="SubGenre3IDLabel" runat="server" Text='<%# Bind("SubGenre3ID") %>'>
</asp:Label> 
AlbumType:
<asp:Label ID="AlbumTypeLabel" runat="server" Text='<%# Bind("AlbumType") %>'></asp:Label> 
AlbumTitle:
<asp:Label ID="AlbumTitleLabel" runat="server" Text='<%# Bind("AlbumTitle") %>'>
</asp:Label> 
AlbumTitleVersion:
<asp:Label ID="AlbumTitleVersionLabel" runat="server" Text='<%# Bind("AlbumTitleVersion") %>'>
</asp:Label> 
CatalogNumber:
<asp:Label ID="CatalogNumberLabel" runat="server" Text='<%# Bind("CatalogNumber") %>'>
</asp:Label> 
EAN:
<asp:Label ID="EANLabel" runat="server" Text='<%# Bind("EAN") %>'></asp:Label> 
YearOfRelease:
<asp:Label ID="YearOfReleaseLabel" runat="server" Text='<%# Bind("YearOfRelease") %>'>
</asp:Label> 
DurantionInSec:
<asp:Label ID="DurantionInSecLabel" runat="server" Text='<%# Bind("DurantionInSec") %>'>
</asp:Label> 
CopyrightYear:
<asp:Label ID="CopyrightYearLabel" runat="server" Text='<%# Bind("CopyrightYear") %>'>
</asp:Label> 
CopyrightText:
<asp:Label ID="CopyrightTextLabel" runat="server" Text='<%# Bind("CopyrightText") %>'>
</asp:Label> 
TotalNumberOfDiscs:
<asp:Label ID="TotalNumberOfDiscsLabel" runat="server" Text='<%# Bind("TotalNumberOfDiscs") %>'>
</asp:Label> 
TotalTracksOnDiscs:
<asp:Label ID="TotalTracksOnDiscsLabel" runat="server" Text='<%# Bind("TotalTracksOnDiscs") %>'>
</asp:Label> 
AlbumDescrShortLocal:
<asp:Label ID="AlbumDescrShortLocalLabel" runat="server" Text='<%# Bind("AlbumDescrShortLocal") %>'>
</asp:Label> 
AlbumDescrShortEng:
<asp:Label ID="AlbumDescrShortEngLabel" runat="server" Text='<%# Bind("AlbumDescrShortEng") %>'>
</asp:Label> 
AlbumDescrLongLocal:
<asp:Label ID="AlbumDescrLongLocalLabel" runat="server" Text='<%# Bind("AlbumDescrLongLocal") %>'>
</asp:Label> 
AlbumDescrLongEng:
<asp:Label ID="AlbumDescrLongEngLabel" runat="server" Text='<%# Bind("AlbumDescrLongEng") %>'>
</asp:Label> 
RecordedStudio:
<asp:Label ID="RecordedStudioLabel" runat="server" Text='<%# Bind("RecordedStudio") %>'>
</asp:Label> 
RecordedPeriode:
<asp:Label ID="RecordedPeriodeLabel" runat="server" Text='<%# Bind("RecordedPeriode") %>'>
</asp:Label> 
MixetStudio:
<asp:Label ID="MixetStudioLabel" runat="server" Text='<%# Bind("MixetStudio") %>'>
</asp:Label> 
CoverDesigner:
<asp:Label ID="CoverDesignerLabel" runat="server" Text='<%# Bind("CoverDesigner") %>'>
</asp:Label> 
Thanks:
<asp:Label ID="ThanksLabel" runat="server" Text='<%# Bind("Thanks") %>'></asp:Label> 
Technician:
<asp:Label ID="TechnicianLabel" runat="server" Text='<%# Bind("Technician") %>'>
</asp:Label> 
Master:
<asp:Label ID="MasterLabel" runat="server" Text='<%# Bind("Master") %>'></asp:Label> 
Image:
<asp:Label ID="ImageLabel" runat="server" Text='<%# Bind("Image") %>'></asp:Label> 
CoverFront:
<asp:Label ID="CoverFrontLabel" runat="server" Text='<%# Bind("CoverFront") %>'>
</asp:Label> 
CoverBack:
<asp:Label ID="CoverBackLabel" runat="server" Text='<%# Bind("CoverBack") %>'></asp:Label> 
Label:
<asp:Label ID="LabelLabel" runat="server" Text='<%# Bind("Label") %>'></asp:Label> 
ReleaseDate:
<asp:Label ID="ReleaseDateLabel" runat="server" Text='<%# Bind("ReleaseDate") %>'>
</asp:Label> 
SaleStartDate:
<asp:Label ID="SaleStartDateLabel" runat="server" Text='<%# Bind("SaleStartDate") %>'>
</asp:Label> 
ForSale:
<asp:CheckBox ID="ForSaleCheckBox" runat="server" Checked='<%# Bind("ForSale") %>'
Enabled="false" /> 
Timemade:
<asp:Label ID="TimemadeLabel" runat="server" Text='<%# Bind("Timemade") %>'></asp:Label> 
Timeedit:
<asp:Label ID="TimeeditLabel" runat="server" Text='<%# Bind("Timeedit") %>'></asp:Label> 
</ItemTemplate>
</asp:FormView>
      
 
 
 
 
 
 
 
 
 
 
 
 
 
<asp:FormView ID="FormView2" runat="server" DefaultMode="Edit" DataKeyNames="TrackID,PriceStructureID,AlbumID,ProducerUserID,ArtistID,LanguageID,CopywriterUserID,GenreID"
DataSourceID="SqlDataSource5" Style="z-index: 104; left: 165px; position: absolute;
top: 195px">
<EditItemTemplate>
TrackID:
<asp:Label ID="TrackIDLabel1" runat="server" Text='<%# Eval("TrackID") %>'></asp:Label> 
PriceStructureID:
<asp:Label ID="PriceStructureIDLabel1" runat="server" Text='<%# Eval("PriceStructureID") %>'>
</asp:Label> 
AlbumID:
<asp:Label ID="AlbumIDLabel1" runat="server" Text='<%# Eval("AlbumID") %>'></asp:Label> 
ProducerUserID:
<asp:Label ID="ProducerUserIDLabel1" runat="server" Text='<%# Eval("ProducerUserID") %>'>
</asp:Label> 
ArtistID:
<asp:Label ID="ArtistIDLabel1" runat="server" Text='<%# Eval("ArtistID") %>'></asp:Label> 
LanguageID:
<asp:Label ID="LanguageIDLabel1" runat="server" Text='<%# Eval("LanguageID") %>'>
</asp:Label> 
CopywriterUserID:
<asp:Label ID="CopywriterUserIDLabel1" runat="server" Text='<%# Eval("CopywriterUserID") %>'>
</asp:Label> 
GenreID:
<asp:Label ID="GenreIDLabel1" runat="server" Text='<%# Eval("GenreID") %>'></asp:Label> 
TrackType:
<asp:TextBox ID="TrackTypeTextBox" runat="server" Text='<%# Bind("TrackType") %>'>
</asp:TextBox> 
TrackTitle:
<asp:TextBox ID="TrackTitleTextBox" runat="server" Text='<%# Bind("TrackTitle") %>'>
</asp:TextBox> 
TrackTitleVersion:
<asp:TextBox ID="TrackTitleVersionTextBox" runat="server" Text='<%# Bind("TrackTitleVersion") %>'>
</asp:TextBox> 
DurationInSec:
<asp:TextBox ID="DurationInSecTextBox" runat="server" Text='<%# Bind("DurationInSec") %>'>
</asp:TextBox> 
SampleStartInSec:
<asp:TextBox ID="SampleStartInSecTextBox" runat="server" Text='<%# Bind("SampleStartInSec") %>'>
</asp:TextBox> 
TrackNumber:
<asp:TextBox ID="TrackNumberTextBox" runat="server" Text='<%# Bind("TrackNumber") %>'>
</asp:TextBox> 
TotalTracksOnDisc:
<asp:TextBox ID="TotalTracksOnDiscTextBox" runat="server" Text='<%# Bind("TotalTracksOnDisc") %>'>
</asp:TextBox> 
DiscNumber:
<asp:TextBox ID="DiscNumberTextBox" runat="server" Text='<%# Bind("DiscNumber") %>'>
</asp:TextBox> 
TotalDiscs:
<asp:TextBox ID="TotalDiscsTextBox" runat="server" Text='<%# Bind("TotalDiscs") %>'>
</asp:TextBox> 
ISRC:
<asp:TextBox ID="ISRCTextBox" runat="server" Text='<%# Bind("ISRC") %>'>
</asp:TextBox> 
ISBN:
<asp:TextBox ID="ISBNTextBox" runat="server" Text='<%# Bind("ISBN") %>'>
</asp:TextBox> 
BPM:
<asp:TextBox ID="BPMTextBox" runat="server" Text='<%# Bind("BPM") %>'>
</asp:TextBox> 
YearOfFirstRelease:
<asp:TextBox ID="YearOfFirstReleaseTextBox" runat="server" Text='<%# Bind("YearOfFirstRelease") %>'>
</asp:TextBox> 
CopyrightYear:
<asp:TextBox ID="CopyrightYearTextBox" runat="server" Text='<%# Bind("CopyrightYear") %>'>
</asp:TextBox> 
CopyrightText:
<asp:TextBox ID="CopyrightTextTextBox" runat="server" Text='<%# Bind("CopyrightText") %>'>
</asp:TextBox> 
LyricsLocal:
<asp:TextBox ID="LyricsLocalTextBox" runat="server" Text='<%# Bind("LyricsLocal") %>'>
</asp:TextBox> 
LyricsEng:
<asp:TextBox ID="LyricsEngTextBox" runat="server" Text='<%# Bind("LyricsEng") %>'>
</asp:TextBox> 
TrackInfoLocal:
<asp:TextBox ID="TrackInfoLocalTextBox" runat="server" Text='<%# Bind("TrackInfoLocal") %>'>
</asp:TextBox> 
TrackInfoEng:
<asp:TextBox ID="TrackInfoEngTextBox" runat="server" Text='<%# Bind("TrackInfoEng") %>'>
</asp:TextBox> 
Image:
<asp:TextBox ID="ImageTextBox" runat="server" Text='<%# Bind("Image") %>'>
</asp:TextBox> 
ForSale:
<asp:CheckBox ID="ForSaleCheckBox" runat="server" Checked='<%# Bind("ForSale") %>' /> 
Timemade:
<asp:TextBox ID="TimemadeTextBox" runat="server" Text='<%# Bind("Timemade") %>'>
</asp:TextBox> 
Timeedit:
<asp:TextBox ID="TimeeditTextBox" runat="server" Text='<%# Bind("Timeedit") %>'>
</asp:TextBox> 
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
Text="Update">
</asp:LinkButton>
<asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</EditItemTemplate>
<InsertItemTemplate>
TrackID:
<asp:TextBox ID="TrackIDTextBox" runat="server" Text='<%# Bind("TrackID") %>'>
</asp:TextBox> 
PriceStructureID:
<asp:TextBox ID="PriceStructureIDTextBox" runat="server" Text='<%# Bind("PriceStructureID") %>'>
</asp:TextBox> 
AlbumID:
<asp:TextBox ID="AlbumIDTextBox" runat="server" Text='<%# Bind("AlbumID") %>'>
</asp:TextBox> 
ProducerUserID:
<asp:TextBox ID="ProducerUserIDTextBox" runat="server" Text='<%# Bind("ProducerUserID") %>'>
</asp:TextBox> 
ArtistID:
<asp:TextBox ID="ArtistIDTextBox" runat="server" Text='<%# Bind("ArtistID") %>'>
</asp:TextBox> 
LanguageID:
<asp:TextBox ID="LanguageIDTextBox" runat="server" Text='<%# Bind("LanguageID") %>'>
</asp:TextBox> 
CopywriterUserID:
<asp:TextBox ID="CopywriterUserIDTextBox" runat="server" Text='<%# Bind("CopywriterUserID") %>'>
</asp:TextBox> 
GenreID:
<asp:TextBox ID="GenreIDTextBox" runat="server" Text='<%# Bind("GenreID") %>'>
</asp:TextBox> 
TrackType:
<asp:TextBox ID="TrackTypeTextBox" runat="server" Text='<%# Bind("TrackType") %>'>
</asp:TextBox> 
TrackTitle:
<asp:TextBox ID="TrackTitleTextBox" runat="server" Text='<%# Bind("TrackTitle") %>'>
</asp:TextBox> 
TrackTitleVersion:
<asp:TextBox ID="TrackTitleVersionTextBox" runat="server" Text='<%# Bind("TrackTitleVersion") %>'>
</asp:TextBox> 
DurationInSec:
<asp:TextBox ID="DurationInSecTextBox" runat="server" Text='<%# Bind("DurationInSec") %>'>
</asp:TextBox> 
SampleStartInSec:
<asp:TextBox ID="SampleStartInSecTextBox" runat="server" Text='<%# Bind("SampleStartInSec") %>'>
</asp:TextBox> 
TrackNumber:
<asp:TextBox ID="TrackNumberTextBox" runat="server" Text='<%# Bind("TrackNumber") %>'>
</asp:TextBox> 
TotalTracksOnDisc:
<asp:TextBox ID="TotalTracksOnDiscTextBox" runat="server" Text='<%# Bind("TotalTracksOnDisc") %>'>
</asp:TextBox> 
DiscNumber:
<asp:TextBox ID="DiscNumberTextBox" runat="server" Text='<%# Bind("DiscNumber") %>'>
</asp:TextBox> 
TotalDiscs:
<asp:TextBox ID="TotalDiscsTextBox" runat="server" Text='<%# Bind("TotalDiscs") %>'>
</asp:TextBox> 
ISRC:
<asp:TextBox ID="ISRCTextBox" runat="server" Text='<%# Bind("ISRC") %>'>
</asp:TextBox> 
ISBN:
<asp:TextBox ID="ISBNTextBox" runat="server" Text='<%# Bind("ISBN") %>'>
</asp:TextBox> 
BPM:
<asp:TextBox ID="BPMTextBox" runat="server" Text='<%# Bind("BPM") %>'>
</asp:TextBox> 
YearOfFirstRelease:
<asp:TextBox ID="YearOfFirstReleaseTextBox" runat="server" Text='<%# Bind("YearOfFirstRelease") %>'>
</asp:TextBox> 
CopyrightYear:
<asp:TextBox ID="CopyrightYearTextBox" runat="server" Text='<%# Bind("CopyrightYear") %>'>
</asp:TextBox> 
CopyrightText:
<asp:TextBox ID="CopyrightTextTextBox" runat="server" Text='<%# Bind("CopyrightText") %>'>
</asp:TextBox> 
LyricsLocal:
<asp:TextBox ID="LyricsLocalTextBox" runat="server" Text='<%# Bind("LyricsLocal") %>'>
</asp:TextBox> 
LyricsEng:
<asp:TextBox ID="LyricsEngTextBox" runat="server" Text='<%# Bind("LyricsEng") %>'>
</asp:TextBox> 
TrackInfoLocal:
<asp:TextBox ID="TrackInfoLocalTextBox" runat="server" Text='<%# Bind("TrackInfoLocal") %>'>
</asp:TextBox> 
TrackInfoEng:
<asp:TextBox ID="TrackInfoEngTextBox" runat="server" Text='<%# Bind("TrackInfoEng") %>'>
</asp:TextBox> 
Image:
<asp:TextBox ID="ImageTextBox" runat="server" Text='<%# Bind("Image") %>'>
</asp:TextBox> 
ForSale:
<asp:CheckBox ID="ForSaleCheckBox" runat="server" Checked='<%# Bind("ForSale") %>' /> 
Timemade:
<asp:TextBox ID="TimemadeTextBox" runat="server" Text='<%# Bind("Timemade") %>'>
</asp:TextBox> 
Timeedit:
<asp:TextBox ID="TimeeditTextBox" runat="server" Text='<%# Bind("Timeedit") %>'>
</asp:TextBox> 
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
Text="Insert">
</asp:LinkButton>
<asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
Text="Cancel">
</asp:LinkButton>
</InsertItemTemplate>
<ItemTemplate>
TrackID:
<asp:Label ID="TrackIDLabel" runat="server" Text='<%# Eval("TrackID") %>'></asp:Label> 
PriceStructureID:
<asp:Label ID="PriceStructureIDLabel" runat="server" Text='<%# Eval("PriceStructureID") %>'>
</asp:Label> 
AlbumID:
<asp:Label ID="AlbumIDLabel" runat="server" Text='<%# Eval("AlbumID") %>'></asp:Label> 
ProducerUserID:
<asp:Label ID="ProducerUserIDLabel" runat="server" Text='<%# Eval("ProducerUserID") %>'>
</asp:Label> 
ArtistID:
<asp:Label ID="ArtistIDLabel" runat="server" Text='<%# Eval("ArtistID") %>'></asp:Label> 
LanguageID:
<asp:Label ID="LanguageIDLabel" runat="server" Text='<%# Eval("LanguageID") %>'>
</asp:Label> 
CopywriterUserID:
<asp:Label ID="CopywriterUserIDLabel" runat="server" Text='<%# Eval("CopywriterUserID") %>'>
</asp:Label> 
GenreID:
<asp:Label ID="GenreIDLabel" runat="server" Text='<%# Eval("GenreID") %>'></asp:Label> 
TrackType:
<asp:Label ID="TrackTypeLabel" runat="server" Text='<%# Bind("TrackType") %>'></asp:Label> 
TrackTitle:
<asp:Label ID="TrackTitleLabel" runat="server" Text='<%# Bind("TrackTitle") %>'>
</asp:Label> 
TrackTitleVersion:
<asp:Label ID="TrackTitleVersionLabel" runat="server" Text='<%# Bind("TrackTitleVersion") %>'>
</asp:Label> 
DurationInSec:
<asp:Label ID="DurationInSecLabel" runat="server" Text='<%# Bind("DurationInSec") %>'>
</asp:Label> 
SampleStartInSec:
<asp:Label ID="SampleStartInSecLabel" runat="server" Text='<%# Bind("SampleStartInSec") %>'>
</asp:Label> 
TrackNumber:
<asp:Label ID="TrackNumberLabel" runat="server" Text='<%# Bind("TrackNumber") %>'>
</asp:Label> 
TotalTracksOnDisc:
<asp:Label ID="TotalTracksOnDiscLabel" runat="server" Text='<%# Bind("TotalTracksOnDisc") %>'>
</asp:Label> 
DiscNumber:
<asp:Label ID="DiscNumberLabel" runat="server" Text='<%# Bind("DiscNumber") %>'>
</asp:Label> 
TotalDiscs:
<asp:Label ID="TotalDiscsLabel" runat="server" Text='<%# Bind("TotalDiscs") %>'>
</asp:Label> 
ISRC:
<asp:Label ID="ISRCLabel" runat="server" Text='<%# Bind("ISRC") %>'></asp:Label> 
ISBN:
<asp:Label ID="ISBNLabel" runat="server" Text='<%# Bind("ISBN") %>'></asp:Label> 
BPM:
<asp:Label ID="BPMLabel" runat="server" Text='<%# Bind("BPM") %>'></asp:Label> 
YearOfFirstRelease:
<asp:Label ID="YearOfFirstReleaseLabel" runat="server" Text='<%# Bind("YearOfFirstRelease") %>'>
</asp:Label> 
CopyrightYear:
<asp:Label ID="CopyrightYearLabel" runat="server" Text='<%# Bind("CopyrightYear") %>'>
</asp:Label> 
CopyrightText:
<asp:Label ID="CopyrightTextLabel" runat="server" Text='<%# Bind("CopyrightText") %>'>
</asp:Label> 
LyricsLocal:
<asp:Label ID="LyricsLocalLabel" runat="server" Text='<%# Bind("LyricsLocal") %>'>
</asp:Label> 
LyricsEng:
<asp:Label ID="LyricsEngLabel" runat="server" Text='<%# Bind("LyricsEng") %>'></asp:Label> 
TrackInfoLocal:
<asp:Label ID="TrackInfoLocalLabel" runat="server" Text='<%# Bind("TrackInfoLocal") %>'>
</asp:Label> 
TrackInfoEng:
<asp:Label ID="TrackInfoEngLabel" runat="server" Text='<%# Bind("TrackInfoEng") %>'>
</asp:Label> 
Image:
<asp:Label ID="ImageLabel" runat="server" Text='<%# Bind("Image") %>'></asp:Label> 
ForSale:
<asp:CheckBox ID="ForSaleCheckBox" runat="server" Checked='<%# Bind("ForSale") %>'
Enabled="false" /> 
Timemade:
<asp:Label ID="TimemadeLabel" runat="server" Text='<%# Bind("Timemade") %>'></asp:Label> 
Timeedit:
<asp:Label ID="TimeeditLabel" runat="server" Text='<%# Bind("Timeedit") %>'></asp:Label> 
<asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit"
Text="Edit">
</asp:LinkButton>
<asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete"
Text="Delete">
</asp:LinkButton>
<asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New"
Text="New">
</asp:LinkButton>
</ItemTemplate>
</asp:FormView>
<asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
DeleteCommand="DELETE FROM [MrvTrack] WHERE [TrackID] = @TrackID AND [PriceStructureID] = @PriceStructureID AND [AlbumID] = @AlbumID AND [ProducerUserID] = @ProducerUserID AND [ArtistID] = @ArtistID AND [LanguageID] = @LanguageID AND [CopywriterUserID] = @CopywriterUserID AND [GenreID] = @GenreID"
InsertCommand="INSERT INTO [MrvTrack] ([TrackID], [PriceStructureID], [AlbumID], [ProducerUserID], [ArtistID], [LanguageID], [CopywriterUserID], [GenreID], [TrackType], [TrackTitle], [TrackTitleVersion], [DurationInSec], [SampleStartInSec], [TrackNumber], [TotalTracksOnDisc], [DiscNumber], [TotalDiscs], [ISRC], [ISBN], [BPM], [YearOfFirstRelease], [CopyrightYear], [CopyrightText], [LyricsLocal], [LyricsEng], [TrackInfoLocal], [TrackInfoEng], [Image], [ForSale], [Timemade], [Timeedit]) VALUES (@TrackID, @PriceStructureID, @AlbumID, @ProducerUserID, @ArtistID, @LanguageID, @CopywriterUserID, @GenreID, @TrackType, @TrackTitle, @TrackTitleVersion, @DurationInSec, @SampleStartInSec, @TrackNumber, @TotalTracksOnDisc, @DiscNumber, @TotalDiscs, @ISRC, @ISBN, @BPM, @YearOfFirstRelease, @CopyrightYear, @CopyrightText, @LyricsLocal, @LyricsEng, @TrackInfoLocal, @TrackInfoEng, @Image, @ForSale, @Timemade, @Timeedit)"
SelectCommand="SELECT * FROM [MrvTrack] WHERE ([AlbumID] = @AlbumID)" UpdateCommand="UPDATE [MrvTrack] SET [TrackType] = @TrackType, [TrackTitle] = @TrackTitle, [TrackTitleVersion] = @TrackTitleVersion, [DurationInSec] = @DurationInSec, [SampleStartInSec] = @SampleStartInSec, [TrackNumber] = @TrackNumber, [TotalTracksOnDisc] = @TotalTracksOnDisc, [DiscNumber] = @DiscNumber, [TotalDiscs] = @TotalDiscs, [ISRC] = @ISRC, [ISBN] = @ISBN, [BPM] = @BPM, [YearOfFirstRelease] = @YearOfFirstRelease, [CopyrightYear] = @CopyrightYear, [CopyrightText] = @CopyrightText, [LyricsLocal] = @LyricsLocal, [LyricsEng] = @LyricsEng, [TrackInfoLocal] = @TrackInfoLocal, [TrackInfoEng] = @TrackInfoEng, [Image] = @Image, [ForSale] = @ForSale, [Timemade] = @Timemade, [Timeedit] = @Timeedit WHERE [TrackID] = @TrackID AND [PriceStructureID] = @PriceStructureID AND [AlbumID] = @AlbumID AND [ProducerUserID] = @ProducerUserID AND [ArtistID] = @ArtistID AND [LanguageID] = @LanguageID AND [CopywriterUserID] = @CopywriterUserID AND [GenreID] = @GenreID">
<DeleteParameters>
<asp:Parameter Name="TrackID" Type="Int32" />
<asp:Parameter Name="PriceStructureID" Type="Int32" />
<asp:Parameter Name="AlbumID" Type="Int32" />
<asp:Parameter Name="ProducerUserID" Type="Int32" />
<asp:Parameter Name="ArtistID" Type="Int32" />
<asp:Parameter Name="LanguageID" Type="Int32" />
<asp:Parameter Name="CopywriterUserID" Type="Int32" />
<asp:Parameter Name="GenreID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="TrackType" Type="Byte" />
<asp:Parameter Name="TrackTitle" Type="String" />
<asp:Parameter Name="TrackTitleVersion" Type="String" />
<asp:Parameter Name="DurationInSec" Type="Double" />
<asp:Parameter Name="SampleStartInSec" Type="Double" />
<asp:Parameter Name="TrackNumber" Type="Int32" />
<asp:Parameter Name="TotalTracksOnDisc" Type="Int32" />
<asp:Parameter Name="DiscNumber" Type="Int32" />
<asp:Parameter Name="TotalDiscs" Type="Int32" />
<asp:Parameter Name="ISRC" Type="String" />
<asp:Parameter Name="ISBN" Type="String" />
<asp:Parameter Name="BPM" Type="Int16" />
<asp:Parameter Name="YearOfFirstRelease" Type="String" />
<asp:Parameter Name="CopyrightYear" Type="Int16" />
<asp:Parameter Name="CopyrightText" Type="Object" />
<asp:Parameter Name="LyricsLocal" Type="String" />
<asp:Parameter Name="LyricsEng" Type="String" />
<asp:Parameter Name="TrackInfoLocal" Type="String" />
<asp:Parameter Name="TrackInfoEng" Type="String" />
<asp:Parameter Name="Image" Type="String" />
<asp:Parameter Name="ForSale" Type="Boolean" />
<asp:Parameter Name="Timemade" Type="DateTime" />
<asp:Parameter Name="Timeedit" Type="Object" />
<asp:Parameter Name="TrackID" Type="Int32" />
<asp:Parameter Name="PriceStructureID" Type="Int32" />
<asp:Parameter Name="AlbumID" Type="Int32" />
<asp:Parameter Name="ProducerUserID" Type="Int32" />
<asp:Parameter Name="ArtistID" Type="Int32" />
<asp:Parameter Name="LanguageID" Type="Int32" />
<asp:Parameter Name="CopywriterUserID" Type="Int32" />
<asp:Parameter Name="GenreID" Type="Int32" />
</UpdateParameters>
<SelectParameters>
<asp:ControlParameter ControlID="GridView3" Name="AlbumID" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
<InsertParameters>
<asp:Parameter Name="TrackID" Type="Int32" />
<asp:Parameter Name="PriceStructureID" Type="Int32" />
<asp:Parameter Name="AlbumID" Type="Int32" />
<asp:Parameter Name="ProducerUserID" Type="Int32" />
<asp:Parameter Name="ArtistID" Type="Int32" />
<asp:Parameter Name="LanguageID" Type="Int32" />
<asp:Parameter Name="CopywriterUserID" Type="Int32" />
<asp:Parameter Name="GenreID" Type="Int32" />
<asp:Parameter Name="TrackType" Type="Byte" />
<asp:Parameter Name="TrackTitle" Type="String" />
<asp:Parameter Name="TrackTitleVersion" Type="String" />
<asp:Parameter Name="DurationInSec" Type="Double" />
<asp:Parameter Name="SampleStartInSec" Type="Double" />
<asp:Parameter Name="TrackNumber" Type="Int32" />
<asp:Parameter Name="TotalTracksOnDisc" Type="Int32" />
<asp:Parameter Name="DiscNumber" Type="Int32" />
<asp:Parameter Name="TotalDiscs" Type="Int32" />
<asp:Parameter Name="ISRC" Type="String" />
<asp:Parameter Name="ISBN" Type="String" />
<asp:Parameter Name="BPM" Type="Int16" />
<asp:Parameter Name="YearOfFirstRelease" Type="String" />
<asp:Parameter Name="CopyrightYear" Type="Int16" />
<asp:Parameter Name="CopyrightText" Type="Object" />
<asp:Parameter Name="LyricsLocal" Type="String" />
<asp:Parameter Name="LyricsEng" Type="String" />
<asp:Parameter Name="TrackInfoLocal" Type="String" />
<asp:Parameter Name="TrackInfoEng" Type="String" />
<asp:Parameter Name="Image" Type="String" />
<asp:Parameter Name="ForSale" Type="Boolean" />
<asp:Parameter Name="Timemade" Type="DateTime" />
<asp:Parameter Name="Timeedit" Type="Object" />
</InsertParameters>
</asp:SqlDataSource>
 
 
 
<asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource4"
Style="left: 154px; position: relative; top: -237px; z-index: 103;" DataKeyNames="TrackID">
<Columns>
<asp:CommandField ShowSelectButton="True" />
<asp:BoundField DataField="TrackTitle" HeaderText="TrackTitle" SortExpression="TrackTitle" />
<asp:BoundField DataField="DurationInSec" HeaderText="DurationInSec" SortExpression="DurationInSec" />
<asp:BoundField DataField="TotalTracksOnDisc" HeaderText="TotalTracksOnDisc" SortExpression="TotalTracksOnDisc" />
<asp:BoundField DataField="TrackNumber" HeaderText="TrackNumber" SortExpression="TrackNumber" />
<asp:BoundField DataField="DiscNumber" HeaderText="DiscNumber" SortExpression="DiscNumber" />
</Columns>
</asp:GridView>
   
 
 
 
  
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [ArtistID], [Artistname] FROM [MrvArtist]"></asp:SqlDataSource>
 

<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [ArtistID], [AlbumID], [AlbumTitle] FROM [MrvAlbum] WHERE ([AlbumID] = @AlbumID)">
<SelectParameters>
<asp:ControlParameter ControlID="GridView1" DefaultValue="1" Name="AlbumID" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT * FROM [MrvAlbum] WHERE ([AlbumID] = @AlbumID)" DeleteCommand="DELETE FROM [MrvAlbum] WHERE [AlbumID] = @AlbumID AND [ArtistID] = @ArtistID" InsertCommand="INSERT INTO [MrvAlbum] ([AlbumID], [ArtistID], [MainGenreID], [SubGenre1ID], [SubGenre2ID], [SubGenre3ID], [AlbumType], [AlbumTitle], [AlbumTitleVersion], [CatalogNumber], [EAN], [YearOfRelease], [DurantionInSec], [CopyrightYear], [CopyrightText], [TotalNumberOfDiscs], [TotalTracksOnDiscs], [AlbumDescrShortLocal], [AlbumDescrShortEng], [AlbumDescrLongLocal], [AlbumDescrLongEng], [RecordedStudio], [RecordedPeriode], [MixetStudio], [CoverDesigner], [Thanks], [Technician], [Master], [Image], [CoverFront], [CoverBack], [Label], [ReleaseDate], [SaleStartDate], [ForSale], [Timemade], [Timeedit]) VALUES (@AlbumID, @ArtistID, @MainGenreID, @SubGenre1ID, @SubGenre2ID, @SubGenre3ID, @AlbumType, @AlbumTitle, @AlbumTitleVersion, @CatalogNumber, @EAN, @YearOfRelease, @DurantionInSec, @CopyrightYear, @CopyrightText, @TotalNumberOfDiscs, @TotalTracksOnDiscs, @AlbumDescrShortLocal, @AlbumDescrShortEng, @AlbumDescrLongLocal, @AlbumDescrLongEng, @RecordedStudio, @RecordedPeriode, @MixetStudio, @CoverDesigner, @Thanks, @Technician, @Master, @Image, @CoverFront, @CoverBack, @Label, @ReleaseDate, @SaleStartDate, @ForSale, @Timemade, @Timeedit)" UpdateCommand="UPDATE [MrvAlbum] SET [MainGenreID] = @MainGenreID, [SubGenre1ID] = @SubGenre1ID, [SubGenre2ID] = @SubGenre2ID, [SubGenre3ID] = @SubGenre3ID, [AlbumType] = @AlbumType, [AlbumTitle] = @AlbumTitle, [AlbumTitleVersion] = @AlbumTitleVersion, [CatalogNumber] = @CatalogNumber, [EAN] = @EAN, [YearOfRelease] = @YearOfRelease, [DurantionInSec] = @DurantionInSec, [CopyrightYear] = @CopyrightYear, [CopyrightText] = @CopyrightText, [TotalNumberOfDiscs] = @TotalNumberOfDiscs, [TotalTracksOnDiscs] = @TotalTracksOnDiscs, [AlbumDescrShortLocal] = @AlbumDescrShortLocal, [AlbumDescrShortEng] = @AlbumDescrShortEng, [AlbumDescrLongLocal] = @AlbumDescrLongLocal, [AlbumDescrLongEng] = @AlbumDescrLongEng, [RecordedStudio] = @RecordedStudio, [RecordedPeriode] = @RecordedPeriode, [MixetStudio] = @MixetStudio, [CoverDesigner] = @CoverDesigner, [Thanks] = @Thanks, [Technician] = @Technician, [Master] = @Master, [Image] = @Image, [CoverFront] = @CoverFront, [CoverBack] = @CoverBack, [Label] = @Label, [ReleaseDate] = @ReleaseDate, [SaleStartDate] = @SaleStartDate, [ForSale] = @ForSale, [Timemade] = @Timemade, [Timeedit] = @Timeedit WHERE [AlbumID] = @AlbumID AND [ArtistID] = @ArtistID">
<SelectParameters>
<asp:ControlParameter ControlID="GridView1" DefaultValue="1" Name="AlbumID" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="AlbumID" Type="Int32" />
<asp:Parameter Name="ArtistID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="MainGenreID" Type="Int32" />
<asp:Parameter Name="SubGenre1ID" Type="Int32" />
<asp:Parameter Name="SubGenre2ID" Type="Int32" />
<asp:Parameter Name="SubGenre3ID" Type="Int32" />
<asp:Parameter Name="AlbumType" Type="Byte" />
<asp:Parameter Name="AlbumTitle" Type="String" />
<asp:Parameter Name="AlbumTitleVersion" Type="String" />
<asp:Parameter Name="CatalogNumber" Type="String" />
<asp:Parameter Name="EAN" Type="String" />
<asp:Parameter Name="YearOfRelease" Type="String" />
<asp:Parameter Name="DurantionInSec" Type="Double" />
<asp:Parameter Name="CopyrightYear" Type="Int16" />
<asp:Parameter Name="CopyrightText" Type="String" />
<asp:Parameter Name="TotalNumberOfDiscs" Type="Int32" />
<asp:Parameter Name="TotalTracksOnDiscs" Type="Byte" />
<asp:Parameter Name="AlbumDescrShortLocal" Type="String" />
<asp:Parameter Name="AlbumDescrShortEng" Type="String" />
<asp:Parameter Name="AlbumDescrLongLocal" Type="String" />
<asp:Parameter Name="AlbumDescrLongEng" Type="String" />
<asp:Parameter Name="RecordedStudio" Type="String" />
<asp:Parameter Name="RecordedPeriode" Type="String" />
<asp:Parameter Name="MixetStudio" Type="String" />
<asp:Parameter Name="CoverDesigner" Type="String" />
<asp:Parameter Name="Thanks" Type="String" />
<asp:Parameter Name="Technician" Type="String" />
<asp:Parameter Name="Master" Type="String" />
<asp:Parameter Name="Image" Type="String" />
<asp:Parameter Name="CoverFront" Type="String" />
<asp:Parameter Name="CoverBack" Type="String" />
<asp:Parameter Name="Label" Type="String" />
<asp:Parameter Name="ReleaseDate" Type="DateTime" />
<asp:Parameter Name="SaleStartDate" Type="DateTime" />
<asp:Parameter Name="ForSale" Type="Boolean" />
<asp:Parameter Name="Timemade" Type="DateTime" />
<asp:Parameter Name="Timeedit" Type="Object" />
<asp:Parameter Name="AlbumID" Type="Int32" />
<asp:Parameter Name="ArtistID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="AlbumID" Type="Int32" />
<asp:Parameter Name="ArtistID" Type="Int32" />
<asp:Parameter Name="MainGenreID" Type="Int32" />
<asp:Parameter Name="SubGenre1ID" Type="Int32" />
<asp:Parameter Name="SubGenre2ID" Type="Int32" />
<asp:Parameter Name="SubGenre3ID" Type="Int32" />
<asp:Parameter Name="AlbumType" Type="Byte" />
<asp:Parameter Name="AlbumTitle" Type="String" />
<asp:Parameter Name="AlbumTitleVersion" Type="String" />
<asp:Parameter Name="CatalogNumber" Type="String" />
<asp:Parameter Name="EAN" Type="String" />
<asp:Parameter Name="YearOfRelease" Type="String" />
<asp:Parameter Name="DurantionInSec" Type="Double" />
<asp:Parameter Name="CopyrightYear" Type="Int16" />
<asp:Parameter Name="CopyrightText" Type="String" />
<asp:Parameter Name="TotalNumberOfDiscs" Type="Int32" />
<asp:Parameter Name="TotalTracksOnDiscs" Type="Byte" />
<asp:Parameter Name="AlbumDescrShortLocal" Type="String" />
<asp:Parameter Name="AlbumDescrShortEng" Type="String" />
<asp:Parameter Name="AlbumDescrLongLocal" Type="String" />
<asp:Parameter Name="AlbumDescrLongEng" Type="String" />
<asp:Parameter Name="RecordedStudio" Type="String" />
<asp:Parameter Name="RecordedPeriode" Type="String" />
<asp:Parameter Name="MixetStudio" Type="String" />
<asp:Parameter Name="CoverDesigner" Type="String" />
<asp:Parameter Name="Thanks" Type="String" />
<asp:Parameter Name="Technician" Type="String" />
<asp:Parameter Name="Master" Type="String" />
<asp:Parameter Name="Image" Type="String" />
<asp:Parameter Name="CoverFront" Type="String" />
<asp:Parameter Name="CoverBack" Type="String" />
<asp:Parameter Name="Label" Type="String" />
<asp:Parameter Name="ReleaseDate" Type="DateTime" />
<asp:Parameter Name="SaleStartDate" Type="DateTime" />
<asp:Parameter Name="ForSale" Type="Boolean" />
<asp:Parameter Name="Timemade" Type="DateTime" />
<asp:Parameter Name="Timeedit" Type="Object" />
</InsertParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [TrackID], [TrackType], [TrackTitle], [DurationInSec], [TotalTracksOnDisc], [TrackNumber], [DiscNumber] FROM [MrvTrack] WHERE ([AlbumID] = @AlbumID)">
<SelectParameters>
<asp:ControlParameter ControlID="GridView2" Name="AlbumID" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
</div>
</asp:Content>

Synes godt om

ktolbod Nybegynder

28. marts 2006 - 14:39 #5

Tjaa ved sgu ikke om det er til at finde hoved og hale i.

Synes godt om

ktolbod Nybegynder

28. marts 2006 - 20:50 #6

lukker

Synes godt om

ktolbod Nybegynder

28. marts 2006 - 20:50 #7

lukker igen :)

Synes godt om

dr_chaos Nybegynder

28. marts 2006 - 21:22 #8

du fandt ud af det?

Synes godt om

Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Følg dette spørgsmål

Opret Preview

Se alle it-kurser fra Computerworld Kurser

IT-kurser om Microsoft 365, sikkerhed, personlig vækst, udvikling, digital markedsføring, grafisk design, SAP og forretningsanalyse.

Se alle it-kurser

Flere spørgsmål fra ASP.NET kategorien

Titel	Indlæg	Oprettet	Seneste aktivitet
Angular, oprettelse af et projekt , Visual Studio 2022, C# Af OBS i ASP.NET	14	08/12/202501:05	11/12/202518:15
valgte i checkboks og comboboks opdater gui og backend Af keepy i ASP.NET	0	01/10/202318:39	-
Webservice Af SommerFyr i ASP.NET	19	11/05/202313:43	31/05/202315:08
ASP:Image og JPG/PDF Af TV47 i ASP.NET	4	25/03/202318:49	31/03/202310:24
www til non-www og HTTPS Af KOH i ASP.NET	2	16/03/202312:31	22/03/202310:19

Se alle spørgsmål i kategorien Opret spørgsmål

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester

Alle kategorier på Eksperten

Seneste artiklerRSS