Sicuramente sono un po' tonto e non ci arrivo in nessun modo.
Ho ridotto il progetto ai minimi termini, ma il risultato è sempre lo stesso.
ti posto il codice:
Questo è VB
Imports System
Imports System.Data
Imports System.Data.SqlClient
Public Class WebForm1
Inherits System.Web.UI.Page
Dim conn As New SqlConnection(ConfigurationManager.ConnectionStrings(1).ConnectionString)
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
End Sub
Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim cmdIns As SqlCommand
Dim strIns As String
strIns = "Insert T_Prova ("
strIns = strIns & "Tipo"
strIns = strIns & ",Nome"
strIns = strIns & ")VALUES("
strIns = strIns & "@Tipo"
strIns = strIns & ",@Nome"
strIns = strIns & ")"
cmdIns = New SqlCommand(strIns, conn)
cmdIns.Parameters.Add("Tipo", SqlDbType.VarChar).Value = DrpTipoAffiliato.Text
cmdIns.Parameters.Add("Nome", SqlDbType.VarChar).Value = DrpDescrizioneaff.Text
conn.Open()
cmdIns.ExecuteNonQuery()
conn.Close()
Response.Redirect("WebForm1.aspx")
End Sub
Protected Sub DrpIdAffiliato_SelectedIndexChanged(sender As Object, e As EventArgs)
DrpDescrizioneaff.SelectedValue = DrpIdAffiliato.SelectedValue
DrpTipoAffiliato.SelectedValue = DrpIdAffiliato.SelectedValue
DrpIdAffiliato.SelectedValue = DrpDescrizioneaff.SelectedValue
End Sub
Protected Sub DrpDescrizioneaff_SelectedIndexChanged(sender As Object, e As EventArgs)
DrpIdAffiliato.SelectedValue = DrpDescrizioneaff.SelectedValue
DrpTipoAffiliato.SelectedValue = DrpDescrizioneaff.SelectedValue
End Sub
Protected Sub DrpTipoAffiliato_SelectedIndexChanged(sender As Object, e As EventArgs)
DrpIdAffiliato.SelectedValue = DrpTipoAffiliato.SelectedValue
DrpDescrizioneaff.SelectedValue = DrpTipoAffiliato.SelectedValue
End Sub
End Class
Codice ASP
<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="WebForm1.aspx.vb" Inherits="Prova_C.WebForm1" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:DropDownList ID="DrpIdAffiliato" runat="server" AutoPostBack="True" DataSourceID="Prova" DataTextField="IdAffiliato" DataValueField="IdAffiliato" OnSelectedIndexChanged="DrpIdAffiliato_SelectedIndexChanged" ></asp:DropDownList>
<asp:SqlDataSource ID="Prova" runat="server" ConnectionString="<%$ ConnectionStrings:EsaWebConnectionString1 %>" SelectCommand="SELECT [IdAffiliato], [Sigla], [Descrizione] FROM [T_Affiliati]"></asp:SqlDataSource>
<asp:DropDownList ID="DrpDescrizioneaff" runat="server" AutoPostBack="True" DataSourceID="Prova" DataTextField="Descrizione" DataValueField="Descrizione" OnSelectedIndexChanged="DrpDescrizioneaff_SelectedIndexChanged" ></asp:DropDownList>
<asp:DropDownList ID="DrpTipoAffiliato" runat="server" AutoPostBack="True" DataSourceID="Prova" DataTextField="Sigla" DataValueField="Sigla" OnSelectedIndexChanged="DrpTipoAffiliato_SelectedIndexChanged" ></asp:DropDownList>
</div>
<asp:Button ID="Button1" runat="server" Height="26px" Text="Salva" Width="237px" />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="IdAffiliato" DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="IdAffiliato" HeaderText="IdAffiliato" InsertVisible="False" ReadOnly="True" SortExpression="IdAffiliato" />
<asp:BoundField DataField="Tipo" HeaderText="Tipo" SortExpression="Tipo" />
<asp:BoundField DataField="Nome" HeaderText="Nome" SortExpression="Nome" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:EsaWebConnectionString1 %>" SelectCommand="SELECT * FROM [T_Prova]"></asp:SqlDataSource>
</form>
</body>
</html>
Ora Riesco a scrivere nella tabella come dico io, ma non mi popola piu' le DDL dianicamente, mi da ancora l'errore :
SelectedValue in 'DrpDescrizioneaff' non valido, poiché non è incluso nell'elenco di elementi.
