Salve , come specificato nell'oggetto, nella pagina aspx di seguito elencata, quando schiaccio il tasto aggiorna, mi ritorma una campo nullo. Gentilemente qualcuno puo aiutarmi. Grazie
------------------------------- Aspx----------------------------------------
<%@ Page Language="VB" AutoEventWireup="true" CodeFile="Assegnaprogettistaomc.aspx.vb" Inherits="Assegnaprogettistaomc" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title>Monitoraggio ADSL</title>
<link href="foglidistile.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="menu.js"></script>
</head>
<body onload="navMenu();navMenu1('innov')">
<form id="form1" runat="server">
<div>
<!-- #Include file="Testata.aspx" -->
<asp:Label id="Label1ga" runat="server" Text="Label" Font-Size="X-Large" ForeColor="Maroon" CssClass="navy" Font-Italic="true" Font-Bold="true"></asp:Label><br/><br/>
<asp:GridView id="GridView1" cssclass="mail2" runat="server" onrowcommand="GridView1_RowCommand"
DataSourceID="SqlDataSource1" AllowPaging="True" PageSize="8"
AutoGenerateColumns="False"
BorderColor="Black"
BorderWidth="1px"
CellPadding="3"
HeaderStyle-BackColor="Yellow">
<Columns>
<asp:TemplateField HeaderText="Aggiorna">
<ItemTemplate>
<asp:Button ID="Aggiorna" runat="server" Text="Aggiorna" CommandName="aggiorna" CommandArgument="<%# CType(Container,GridViewRow).RowIndex %>" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Progettista_Omc">
<ItemTemplate>
<asp:DropDownList ID="DropDownList1"
DataSource='<%# values6 %>'
DataTextField=""
DataValueField=""
AutoPostBack="false"
runat="server" Width="150px">
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="td" HeaderText="td" />
<asp:BoundField DataField="id_linea" HeaderText="tgu" />
<asp:BoundField DataField="velocita" HeaderText="Velocita" />
<asp:BoundField DataField="tecnologia" HeaderText="Tipo" />
<asp:BoundField DataField="cliente" HeaderText="Cliente" />
<asp:BoundField DataField="Utr" HeaderText="Utr" />
<asp:BoundField DataField="data_arrivo" HeaderText="Data" />
<asp:BoundField DataField="Indirizzo" HeaderText="Indirizzo" />
<asp:BoundField DataField="Localita" HeaderText="Localita" />
<asp:BoundField DataField="m_proc" HeaderText="Procedura" />
<asp:BoundField DataField="Id_Siebel" HeaderText="Id_Siebel" />
</Columns>
<RowStyle ForeColor="#009933" />
<AlternatingRowstyle forecolor="Blue" />
<emptydatarowstyle forecolor="Red"/>
<emptydatatemplate>
<asp:image id="NoDataImage"
imageurl="~/images/icon-info.gif"
alternatetext="No Data"
runat="server"/>
Nessun record trovato.
</emptydatatemplate>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1"
runat="server"
ConnectionString="Data Source=localhost;database=adslmonnew;uid=;pwd=;"
ProviderName="MySql.Data.MySqlClient"
SelectCommand="Select * from adsl_inn_rod_who_att where utr = 'S1' and stato = 'ID' and velocita is not null and (tecnologia = 'HDSL' or tecnologia = 'HSHDSL' or tecnologia = 'SSHDSL' or tecnologia = 'Altro CDN' or tecnologia = 'GBE') and (m_proc = 'Who' or (m_proc <> 'Who' and (cast(velocita as signed) > 64 And cast(velocita as signed) < 34000))) And not IsNull(sede1) and IsNull(assistente_cir) order by date(data_arrivo);">
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
-------------------------------- Vb.Net--------------------------------------
Partial Class Assegnaprogettistaomc
Inherits System.Web.UI.Page
Public values6 As ArrayList = New ArrayList()
Overloads Sub Page_Load(ByVal Sender As Object, ByVal E As EventArgs) Handles Me.Load
If Not Session("id") Then
Response.Redirect("loginingresso.aspx")
End If
If Not (Page.IsPostBack) Then
'Impostiamo la connessione al DB
con = New MySqlConnection(System.Configuration.ConfigurationManager.AppSettings("conadslmon"))
con.Open()
strSql = "Select * from tbassistentiol order by assistente;"
dbComm = New MySqlCommand(strSql, con)
'Creiamo un DataReader
dbRead = dbComm.ExecuteReader()
values6.Add("---- Scegli ----")
While dbRead.read()
values6.Add(Trim(dbRead("assistente")))
End While
dbRead.close()
con.close()
End Sub
Protected Sub GridView1_RowCommand(ByVal sender As Object, ByVal e As GridViewCommandEventArgs)
If e.CommandName = "aggiorna" Then
'Indice riga
Dim indexRow As Integer = System.Convert.ToInt32(e.CommandArgument)
'Recupero riga
Dim selectedRow As GridViewRow = GridView1.Rows(indexRow)
BindFormCan(selectedRow)
Else
Response.Write(e.CommandName & " - 1111 ")
Response.End()
End If
End Sub
Private Sub BindFormCan(ByVal row As GridViewRow)
Dim c As Integer
For c = 0 To 12
Response.Write(row.Cells(c).Text & " - " & c & "<br>")
' la stampa delle celle relative alla riga selezionata e' vuota per dropdownlist
Next
Response.End()
End Sub
End Class
