ho provato a fare così ma niente non ne vuole sapere mi dà problemi su [/b]object sender,DataGridCommandEventArgs e[/b]
HELP
:
codice:
public void abc (object sender,DataGridCommandEventArgs e)
{
switch(e.CommandName)
{
case "visciclo":
tab_visciclo.Visible=true;
tab_update_cliente.Visible=true;
uint cId = (uint) gridallclient.DataKeys[gridallclient.SelectedIndex];
string qcontroluserdata = "SELECT * FROM ciclomotori WHERE cliente = "+cId+"";
//Response.Write(qcontroluserdata);
string conn = "Database=maximotogest;Data Source=localhost;User Id=root;Password=";
MySqlConnection connessione = new MySqlConnection(conn);
MySqlCommand cmd = new MySqlCommand(qcontroluserdata,connessione);
MySqlDataAdapter adapter = new MySqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds);
gridallclient.DataSource=ds;
gridallclient.DataBind();
connessione.Close();
break;
case "viscliente":
tab_update_cliente.Visible=true;
uint Id = (uint) gridallclient.DataKeys[gridallclient.SelectedIndex];
string qpopulateuserlabel = "SELECT * FROM Clienti WHERE Id="+Id+"";
string conn2 = "Database=maximotogest;Data Source=localhost;User Id=root;Password=";
MySqlConnection connection=new MySqlConnection(conn2);
MySqlCommand cmd2 = new MySqlCommand(qpopulateuserlabel,connection);
connection.Open();
MySqlDataReader reader;
reader=cmd2.ExecuteReader();
while (reader.Read())
lnome.Text=reader.GetString(1);
lcognome.Text=reader.GetString(2);
lnascita.Text=reader.GetString(3);
lluogonascita.Text=reader.GetString(4);
lresidenza.Text=reader.GetString(5);
lvia.Text=reader.GetString(6);
lcodfisc.Text=reader.GetString(7);
lpiva.Text=reader.GetString(8);
lnumtel.Text=reader.GetString(9);
lnumfax.Text=reader.GetString(10);
lcnote.Text=reader.GetString(11);
reader.Close();
connection.Close();
break;
}
}
codice:
<asp:datagrid id="gridallclient" runat="server" OnPageIndexChanged="paginazione" PagerStyle-HorizontalAlign="Right"
PageSize="2" AllowPaging="True" OnSortCommand="Sorting" AllowSorting="True" AutoGenerateColumns="False" Width="690px"
DataKeyField="Id" OnSelectedIndexChanged="abc">
<Columns>
<asp:BoundColumn DataField="Nome" SortExpression="Nome" HeaderText="Nome"></asp:BoundColumn>
<asp:BoundColumn DataField="Cognome" SortExpression="Cognome" HeaderText="Cognome"></asp:BoundColumn>
<asp:BoundColumn DataField="Res_city" SortExpression="Res_city" HeaderText="Residenza"></asp:BoundColumn>
<asp:BoundColumn DataField="Address" SortExpression="Address" HeaderText="Indirizzo"></asp:BoundColumn>
<asp:ButtonColumn Text="<img src='img/viscliente.gif' title='Visualizza tutte le informazioni del cliente' border='no'>"
CommandName="viscliente">
<ItemStyle HorizontalAlign="Center"></ItemStyle>
<FooterStyle Height="22px" Width="22px"></FooterStyle>
</asp:ButtonColumn>
<asp:ButtonColumn Text="<img src='img/visciclomotors.gif' title='Visualizza tutti i ciclomotori associati a questo cliente' border='no'>"
CommandName="visciclo">
<ItemStyle HorizontalAlign="Center"></ItemStyle>
<FooterStyle Height="22px" Width="22px"></FooterStyle>
</asp:ButtonColumn>
</Columns>
<PagerStyle NextPageText="AVANTI >" PrevPageText="< INDIETRO" HorizontalAlign="Right"
Position="TopAndBottom"></PagerStyle>
</asp:datagrid>