<%@ Page Title="" Language="C#" MasterPageFile="~/Bmovida.master" AutoEventWireup="true" CodeFile="Bar.aspx.cs" Inherits="Bar" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="lat" Runat="Server">
    <asp:Image ID="Image1" ImageUrl="Immagini/Categorie/Bar.jpg" runat="server" />
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="pag" Runat="Server">
     <p><asp:textbox
           id="Fnome"
           runat="server" />
           <p><asp:textbox
           id="Fluogo"
           runat="server" />
           <p><asp:textbox
           id="Findirizzo"
           runat="server" />
           <p><asp:textbox
           id="Ftelefono"
           runat="server" />
           <p><asp:textbox
           id="Fcategoria"
           runat="server" />
           <p><asp:button
           id="Button1"
           runat="server"
           text="Inserisci Locale"
           onclick="Inserisci" />
    <asp:SqlDataSource ID="movida" runat="server"
        ConnectionString="<%$ ConnectionStrings:Conn %>" 
        
        SelectCommand="SELECT [Nome], [Luogo], [Indirizzo], [Immagine], [Telefono] FROM [Locali] WHERE ([Categoria] = @Categoria) ORDER BY [Preferenza] DESC, [ID]"
        insertcommand="INSERT INTO Locali (Nome,Luogo,Indirizzo,Telefono,Categoria) VALUES (@Inome,@Iluogo,@Lindirizzo,@Itelefono,@Icategoria)">
          <insertparameters>
            <asp:formparameter name="Inome" formfield="Fnome" />
            <asp:formparameter name="Iluogo"  formfield="Fluogo" />
             <asp:formparameter name="Lindirizzo" formfield="Findirizzo" />
            <asp:formparameter name="Itelefono"  formfield="Ftelefono" />
            <asp:formparameter name="Icategoria"  formfield="Fcategoria" />
          </insertparameters>
        <SelectParameters>
            <asp:Parameter DefaultValue="1" Name="Categoria" Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>

</asp:Content>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class Bar : System.Web.UI.Page
{
    public void Inserisci(object source, EventArgs e)
    {
        movida.Insert();
    }
    protected void Page_Load(object sender, EventArgs e)
    {
 
    }
}