dotNETportal.cz

Ahoj, jak u DropDown udělat aby se id zobrazeného názvu kategorie zapsalo do druhé tabulky???

Nechcete to trochu upřesnit?

Jak vypadá SQL dotaz, kam chcete ID dosadit. Děláte to přes SqlDataSource, v kódu nebo jak?

Proboha živého...

Jo omlouvám se,

Takže jde to přes SqlDataSource

SQL Dotaz

Create Table [dbo].[InsuranceCategories]
(
	[IdCatInsurance] int identity(1,1) not null,
	[TypeInsurance] nvarchar(100) not null,
	
	CONSTRAINT PK_InsuranceCategories PRIMARY KEY CLUSTERED ([IdCatInsurance] ASC)
)

Create table [dbo].[Insurance]
(
	[IdInsurance] int identity(1,1) not null,
	[Title] varchar(max) not null,
	[Description] nvarchar(max) null,
	[Images] varchar(max) null,
	[Price] varchar(max) null,
	[CatID] int not null
	
	CONSTRAINT PK_Insurance PRIMARY KEY CLUSTERED (IdInsurance ASC)
	CONSTRAINT FK_relace FOREIGN KEY (CatID) REFERENCES InsuranceCategories(IdCatInsurance)
)

CREATE VIEW [InsuranceInsuranceCategories] as
	select
			IdInsurance, Title, Description, Price, Images, 
			TypeInsurance, IdCatInsurance
		from InsuranceCategories
			left join Insurance on InsuranceCategories.IdCatInsurance = insurance.catid


select * from InsuranceInsuranceCategories

a potřebuju aby se IdCatInsurance dosadilo do CatID ale tak aby to CatID odpovídalo vyselectovanýmu záznamu v DropDownListu

<asp:DropDownList ID="DropDownList1" runat="server" 
    DataSourceID="SqlDataSource1"
    DataTextField="TypeInsurance" 
    DataValueField="IdCatInsurance">
</asp:DropDownList>

zkoušel jsem to následovně

VB.NET ale soudím že je asik na 99% blbě z toho důvodu že je to podtržený vlnkou

    Protected Sub CatIDTextBox_Load(ByVal sender As Object, ByVal e As System.EventArgs)
        DropDownList.SelectedValue.Insert(startIndex:="{0}", value:="{0}")
    End Sub

TextBox

<asp:TextBox ID="CatIDTextBox" runat="server" 
    Text='<%# Bind("CatID") %>'
    OnLoad="CatIDTextBoxE_Load" />

stačí to takto

Jinak celá stránka vypadá následovně

<%@ Page Title="Úvod (Zobraz)" Language="VB" MasterPageFile="~/Admin/SiteAdmin.master" %>

<script runat="server">

    Protected Sub CatIDTextBox_Load(ByVal sender As Object, ByVal e As System.EventArgs)
        DropDownList.SelectedValue.Insert(startIndex:="{0}", value:="{0}")
    End Sub
</script>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:FRAVLSERVIS %>" 
        SelectCommand="SELECT * FROM [Insurance] WHERE ([CatID] = @CatID)"
        DeleteCommand="DELETE FROM [Insurance] WHERE [IdInsurance] = @IdInsurance"
        InsertCommand="INSERT INTO [Insurance] ([Title], [Description], [Images], [Price], [CatID]) VALUES (@Title, @Description, @Images, @Price, @CatID)" 
        
        UpdateCommand="UPDATE [Insurance] SET [Title] = @Title, [Description] = @Description, [Images] = @Images, [Price] = @Price, [CatID] = @CatID WHERE [IdInsurance] = @IdInsurance">
        <SelectParameters>
            <asp:QueryStringParameter Name="CatID" QueryStringField="Id" 
                Type="Int32" />
        </SelectParameters>
        <DeleteParameters>
            <asp:Parameter Name="IdInsurance" Type="Int32" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="Title" Type="String" />
            <asp:Parameter Name="Description" Type="String" />
            <asp:Parameter Name="Images" Type="String" />
            <asp:Parameter Name="Price" Type="String" />
            <asp:Parameter Name="CatID" Type="Int32" />
            <asp:Parameter Name="IdInsurance" Type="Int32" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="Title" Type="String" />
            <asp:Parameter Name="Description" Type="String" />
            <asp:Parameter Name="Images" Type="String" />
            <asp:Parameter Name="Price" Type="String" />
            <asp:Parameter Name="CatID" Type="Int32" />
        </InsertParameters>
    </asp:SqlDataSource>
    <asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource1" 
        DataKeyNames="IdInsurance" DefaultMode="Edit">
        <EditItemTemplate>
            
            <table>
                <tr>
                    <td>
                        Nadpis:
                    </td>
                    <td colspan="2">
                        <asp:TextBox ID="TitleTextBox" runat="server"
                            Text='<%# Bind("Title") %>' />
                    </td>
                </tr>
                <tr>
                    <td>
                        Popis
                    </td>
                    <td colspan="2">
                        <asp:TextBox ID="DescriptionTextBox" runat="server" 
                            Text='<%# Bind("Description") %>' />
                    </td>
                </tr>
                <tr>
                    <td>
                        Cena
                    </td>
                    <td colspan="2">
                        <asp:TextBox ID="PriceTextBox" runat="server"
                            Text='<%# Bind("Price") %>' />
                    </td>
                </tr>
                <tr>
                    <td>
                        Obrázek
                    </td>
                    <td colspan="2">
                        <asp:TextBox ID="ImagesTextBox" runat="server"
                            Text='<%# Bind("Images") %>' />
                    </td>
                </tr>
                <tr>
                    <td>
                        Název kategorie
                    </td>
                    <td>
                        <asp:DropDownList ID="DropDownList" runat="server" 
                            DataSourceID="SqlDataSource1"
                            DataTextField="TypeInsurance" 
                            DataValueField="IdCatInsurance">
                        </asp:DropDownList>
                    </td>
                    <td>
                        <asp:TextBox ID="CatIDTextBox" runat="server"
                            Text='<%# Bind("CatID") %>'
                            OnLoad="CatIDTextBoxE_Load" />
                    </td>
                </tr>
                <tr>
                    <td colspan="3">
                        <asp:Button ID="UpdateButton" runat="server" CausesValidation="True" 
                            CommandName="Update" Text="Upravit" />
                        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                        <asp:Button ID="UpdateCancelButton" runat="server" 
                            CausesValidation="False" CommandName="Cancel" Text="Zrušit" />
                    </td>
                </tr>
            </table>
        </EditItemTemplate>
    </asp:FormView>
</asp:Content>

Díky