e questo è il codice della pagina clienti.aspx
<%@ Page Title="Clienti" Language="C#" MasterPageFile="~/Master/Page.Master" AutoEventWireup="true" ClientIDMode="Static" CodeBehind="clienti.aspx.cs" Inherits="DemoBootstrap.clienti" %>
<asp:Content ID="ContentHead" ContentPlaceHolderID="PlaceHolderHead" runat="server">
</asp:Content>
<asp:Content ID="ContentBody" ContentPlaceHolderID="PlaceHolderBody" runat="server">
<div class="container">
<h4>Clienti</h4>
<div>
<asp:TextBox ID="CercaText2" runat="server"></asp:TextBox>
<asp:Button ID="CercaButton2" runat="server" Text="CERCA" OnClick="CercaButton2_Click" />
<asp:LinkButton ID="ButtonCLIE" OnClick="ButtonCLIE_Click" runat="server">Gestione Clienti</asp:LinkButton>
</div>
<asp:GridView ID="GridCLIE2" runat="server" AutoGenerateColumns="False" DataKeyNames="CLIE_ID" ShowHeaderWhenEmpty="true"
CellPadding="4" ForeColor="#333333" GridLines="None" OnSelectedIndexChanged="GridCLIE2_SelectedIndexChanged1">
<%-- Theme Properties --%>
<AlternatingRowStyle BackColor="White" />
<EditRowStyle BackColor="#2461BF" />
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#EFF3FB" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#F5F7FB" />
<SortedAscendingHeaderStyle BackColor="#6D95E1" />
<SortedDescendingCellStyle BackColor="#E9EBEF" />
<SortedDescendingHeaderStyle BackColor="#4870BE" />
<Columns>
<asp:TemplateField HeaderText="ID">
<ItemTemplate>
<asp:Label Text='<%# Eval("CLIE_ID") %>' runat="server" />
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtCLIE_ID" Text='<%# Eval("CLIE_ID") %>' runat="server" />
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtCLIE_IDFooter" runat="server" />
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Ragione sociale">
<ItemTemplate>
<asp:Label Text='<%# Eval("CLIE_Denominazione") %>' runat="server" />
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtCLIE_Denominazione" Text='<%# Eval("CLIE_Denominazione") %>' runat="server" />
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtCLIE_DenominazioneFooter" runat="server" />
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Città">
<ItemTemplate>
<asp:Label Text='<%# Eval("CLIE_Citta") %>' runat="server" />
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtCLIE_Citta" Text='<%# Eval("CLIE_Citta") %>' runat="server" />
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtCLIE_CittaFooter" runat="server" />
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Telefono">
<ItemTemplate>
<asp:Label Text='<%# Eval("CLIE_Telefono") %>' runat="server" />
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtCLIE_Telefono" Text='<%# Eval("CLIE_Telefono") %>' runat="server" />
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtCLIE_TelefonoFooter" runat="server" />
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Email">
<ItemTemplate>
<asp:Label Text='<%# Eval("CLIE_Email") %>' runat="server" />
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtCLIE_Email" Text='<%# Eval("CLIE_Email") %>' runat="server" />
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtCLIE_EmailFooter" runat="server" />
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Sito internet">
<ItemTemplate>
<asp:Label Text='<%# Eval("CLIE_Web") %>' runat="server" />
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtCLIE_Web" Text='<%# Eval("CLIE_Web") %>' runat="server" />
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtCLIE_WebFooter" runat="server" />
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Note">
<ItemTemplate>
<asp:Label Text='<%# Eval("CLIE_Note") %>' runat="server" />
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtCLIE_Note" Text='<%# Eval("CLIE_Note") %>' runat="server" />
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtCLIE_NoteFooter" runat="server" />
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Dettagli">
<ItemTemplate>
<asp:linkButton ID="LnkCliDettagli" OnClick="LnkCliDettagli_Click" runat="server" Font-Bold="true" CommandArgument='<%# Eval("CLIE_ID") %>' >Dettagli</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Riferimenti">
<ItemTemplate>
<asp:LinkButton ID="LnkCliRiferimenti" OnClick="LnkCliRiferimenti_Click" runat="server" Font-Bold="true" CommandArgument='<%# Eval("CLIE_ID") %>' >Riferimenti</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
</asp:Content>
<asp:Content ID="ContentFooter" ContentPlaceHolderID="PlaceHolderFooter" runat="server">
</asp:Content>
aggiungo la parte cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Web.UI.HtmlControls;
namespace DemoBootstrap
{
public partial class clienti : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
PopulateGridview();
}
}
void PopulateGridview()
{
DataTable dtbl2 = new DataTable();
string mainconn = ConfigurationManager.ConnectionStrings["LocalDB"].ConnectionString;
SqlConnection sqlConnection = new SqlConnection(mainconn);
sqlConnection.Open();
{
SqlDataAdapter sqlDa = new SqlDataAdapter("SELECT * FROM CLIENTE", mainconn);
sqlDa.Fill(dtbl2);
}
if (dtbl2.Rows.Count > 0)
{
GridCLIE2.DataSource = dtbl2;
GridCLIE2.DataBind();
}
else
{
dtbl2.Rows.Add(dtbl2.NewRow());
GridCLIE2.DataSource = dtbl2;
GridCLIE2.DataBind();
GridCLIE2.Rows[0].Cells.Clear();
GridCLIE2.Rows[0].Cells.Add(new TableCell());
GridCLIE2.Rows[0].Cells[0].ColumnSpan = dtbl2.Columns.Count;
GridCLIE2.Rows[0].Cells[0].Text = "Dati non trovati";
GridCLIE2.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
}
}
protected void CercaButton2_Click(object sender, EventArgs e)
{
SqlDataReader rdr = null;
string mainconn = ConfigurationManager.ConnectionStrings["LocalDB"].ConnectionString;
SqlConnection sqlConnection = new SqlConnection(mainconn);
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand();
string sqlquery = "select * from [INTRAWEB].[dbo].[CLIENTE] where CLIE_Denominazione like '%'+ @CLIE_Denominazione+ '%'";
sqlCommand.CommandText = sqlquery;
sqlCommand.Connection = sqlConnection;
sqlCommand.Parameters.AddWithValue("CLIE_Denominazione", CercaText2.Text);
sqlCommand.Parameters.Add("@ReturnValue", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
rdr = sqlCommand.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{
}
}
}
protected void ButtonCLIE_Click(object sender, EventArgs e)
{
HttpContext.Current.Response.Redirect("~/WebFormCLIE.aspx", false);
}
protected void LnkCliDettagli_Click(object sender, EventArgs e)
{
HttpContext.Current.Response.Redirect("~/ClieDettagli.aspx", false);
}
protected void LnkCliRiferimenti_Click(object sender, EventArgs e)
{
HttpContext.Current.Response.Redirect("~/WebFormCLIE.aspx", false);
}
protected void GridCLIE2_SelectedIndexChanged1(object sender, EventArgs e)
{
string CLIE_ID = GridCLIE2.SelectedRow.Cells[0].Text;
Response.Redirect("~/ClieDettagli.aspx?CLIE_ID=" + CLIE_ID);
}
}
}
Grazie ancora a tutti
