Hi!We got a problem with sql sever in vwd 2008 express.Q1: is it possible to use an "image button" as an "insert button"?Q2: Do you have to put the "insert button" in the same table as the "binded" variables for the textbox fields?In the code we tried to position the "insert button" att three different locations but only one worked. At LOCATION 1 all fields except "presentation" were saved to the database.At LOCATION 2 the "image button" skips saving the fields. At LOCATION 3 we get an error msg:[SqlException (0x80131904): Måste deklarera den skalära variabeln "@arbetstakt".](in english: must declare the ?scalar? variable...)<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="Tunnel1.aspx.vb" Inherits="Default2" title="Untitled Page" %><asp:Content ID="Main" ContentPlaceHolderID="Main" Runat="Server"> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" InsertCommand="INSERT INTO konsult(arbetstakt, typ, presentation, postadress, språk, postnr, CO, epost, mobil, telefon, enamn, fnamn, pnummer) VALUES (@arbetstakt, @typ, @presentation, @postadress, @språk, @postnr, @CO, @epost, @mobil, @telefon, @enamn, @fnamn, @pnummer)"> </asp:SqlDataSource> <asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource1" DefaultMode="Insert"> <InsertItemTemplate> <table cellpadding="0" cellspacing="0" width="100%" border="0"> <!-- Menyrad --> <tr> <td colspan="2"> <table align="right" cellpadding="0" width="100%" bgcolor="#EEEEEE"> <tr> <td align="left"> <script type="text/javascript" language="JavaScript">showMenus(1,'Horizontal')</script> </td> <td align="right"> <!-- <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" InsertCommand="INSERT INTO konsult(arbetstakt, typ, postadress, språk, postnr, CO, epost, mobil, telefon, enamn, fnamn, pnummer) VALUES (@arbetstakt, @typ, @postadress, @språk, @postnr, @CO, @epost, @mobil, @telefon, @enamn, @fnamn, @pnummer)"> </asp:SqlDataSource> --> <b>Steg 1</b> av 5: Personuppgifter </td> <td bgcolor="#EEEEEE" width="25" height="25" align="center"> <asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/Images/TunnelKnapp1vald.jpg" PostBackUrl="~/Tunnel1.aspx" AlternateText="Steg 1" /> </td> <td bgcolor="#EEEEEE" width="25" height="25" align="center"> <asp:ImageButton ID="ImageButton2" runat="server" ImageUrl="~/Images/TunnelKnapp2.jpg" PostBackUrl="~/Tunnel2.aspx" AlternateText="Steg 2"/> </td> <td bgcolor="#EEEEEE" width="25" height="25" align="center"> <asp:ImageButton ID="ImageButton3" runat="server" ImageUrl="~/Images/TunnelKnapp3.jpg" PostBackUrl="~/Tunnel3.aspx" AlternateText="Steg 3"/> </td> <td bgcolor="#EEEEEE" width="25" height="25" align="center"> <asp:ImageButton ID="ImageButton4" runat="server" ImageUrl="~/Images/TunnelKnapp4.jpg" PostBackUrl="~/Tunnel4.aspx" AlternateText="Steg 4" /> </td> <td bgcolor="#EEEEEE" width="25" height="25" align="center"> <asp:ImageButton ID="ImageButton5" runat="server" ImageUrl="~/Images/TunnelKnapp5.jpg" PostBackUrl="~/Tunnel5.aspx" AlternateText="Steg 5" /> </td> </tr> </table> </td> </tr> <!-- Sidan --> <tr> <!-- Topp skuggor --> <td width="500" height="15" style="background-image: url('Images/toppskugga_Liten.jpg'); background-repeat: no-repeat; background-position: center bottom"> <table cellpadding="0" cellspacing="0"> <tr> <td width="20"></td> <td width="460"></td> <td width="20"></td> </tr> </table> </td> </tr> <tr> <!-- Mellan skuggor --> <td width="500" style="background-image: url('Images/mellanskugga_Liten.jpg'); background-repeat: repeat-y; background-position: center bottom"> <table cellpadding="0" cellspacing="0"> <tr> <td width="20"></td> <td width="460"> <!-- <asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource1" DefaultMode="Insert"> <InsertItemTemplate> --> <table width="100%"> <tr> <td width="150">Personnummer:*</td> <td width="250"><asp:TextBox Width="150" ID="pnummerTextBox" runat="server" Font-Size="X-Small" Text='<%# Bind("pnummer") %>' /></td> </tr> <tr> <td width="150">Förnamn:*</td> <td width="250"><asp:TextBox Width="150" ID="fnamnTextBox" runat="server" Font-Size="X-Small" Text='<%# Bind("fnamn") %>' /></td> </tr> <tr> <td width="150">Efternamn:*</td> <td width="250"><asp:TextBox Width="150" ID="enamnTextBox" runat="server" Font-Size="X-Small" Text='<%# Bind("enamn") %>' /></td> </tr> <tr><td><br></td></tr> <tr> <td width="150">Telefon:</td> <td width="250"><asp:TextBox Width="150" ID="telefonTextBox" runat="server" Font-Size="X-Small" Text='<%# Bind("telefon") %>' /></td> </tr> <tr> <td width="150">Mobil:*</td> <td width="250"><asp:TextBox Width="150" ID="mobilTextBox" runat="server" Font-Size="X-Small" Text='<%# Bind("mobil") %>' /></td> </tr> <tr> <td width="150">Epost:*</td> <td width="250"><asp:TextBox Width="150" ID="epostTextBox" runat="server" Font-Size="X-Small" Text='<%# Bind("epost") %>' /></td> </tr> <tr> <td width="150">CO:</td> <td width="250"><asp:TextBox Width="150" ID="COTextBox" runat="server" Font-Size="X-Small" Text='<%# Bind("CO") %>' /></td> </tr> <tr> <td width="150">Postnummer:</td> <td width="250"><asp:TextBox Width="150" ID="postnrTextBox" runat="server" Font-Size="X-Small" Text='<%# Bind("postnr") %>' /></td> </tr> <tr> <td width="150">Postadress:</td> <td width="250"><asp:TextBox Width="150" ID="postadressTextBox" runat="server" Font-Size="X-Small" Text='<%# Bind("postadress") %>' /></td> </tr> <tr><td><br></td></tr> <tr> <td width="150">Övrigt språk:</td> <td width="250"> <asp:DropDownList Width="156" ID="språkDropDownList" runat="server" Font-Size="X-Small" Text='<%# Bind("språk") %>'> <asp:ListItem>Välj språk</asp:ListItem> <asp:ListItem>Engelska</asp:ListItem> <asp:ListItem>Tyska</asp:ListItem> <asp:ListItem>Ryska</asp:ListItem> <asp:ListItem>Spanska</asp:ListItem> <asp:ListItem>Franska</asp:ListItem> </asp:DropDownList> </td> </tr> <tr> <td width="150">Konsulttyp:</td> <td width="250"> <asp:DropDownList Width="156" ID="typDropDownList" runat="server" Font-Size="X-Small" Text='<%# Bind("typ") %>'> <asp:ListItem>Intern</asp:ListItem> <asp:ListItem>Extern</asp:ListItem> </asp:DropDownList> </td> </tr> <tr> <td width="150">Arbetstakt:</td> <td width="250"> <asp:DropDownList Width="156" ID="arbetstaktTextBox" runat="server" Font-Size="X-Small" Text='<%# Bind("arbetstakt") %>'> <asp:ListItem>25%</asp:ListItem> <asp:ListItem>50%</asp:ListItem> <asp:ListItem>75%</asp:ListItem> <asp:ListItem>100%</asp:ListItem> </asp:DropDownList> </td> </tr> <tr> <td></td> <td></td> <td align="right"> <!-- LOCATION 1 <asp:Button ID="InsertButton" CommandName="Insert" CausesValidation="True" runat="server" Text="Spara" /> --> </td> </tr> </table> <!-- </InsertItemTemplate> </asp:FormView> --> </td> <td width="20"></td> </tr> </table> </td> <td rowspan="3" width="240" valign="top"> <table cellpadding="0" cellspacing="0"> <tr> <td width="240" align="right"> <!-- <img src="Images/PilBak.jpg" alt="Bak"/> --> <!-- LOCATION 2 <asp:ImageButton ID="InsertButton" CommandName="Insert" runat="server" CausesValidation="True" ImageUrl="Images/PilFram.jpg" PostBackUrl="Tunnel2.aspx" AlternateText="Fram" /> --> </td> </tr> <tr> <td width="240" style="background-image: url('Images/toppskugga_Mini.jpg'); background-repeat: repeat-y; background-position: center bottom"> </td> </tr> <tr> <td width="240" style="background-image: url('Images/mellanskugga_Mini.jpg'); background-repeat: repeat-y; background-position: center bottom"> <table> <tr> <td width="20"></td> <td width="200" valign="top" align="center"> <asp:Image ID="Image9" runat="server" width="150" Height="150" ImageUrl="~/Images/defaultFoto.jpg"/> <br /> <asp:Button ID="InsertButton2" runat="server" Text="Ladda upp bild" /> <br /><br /> Personlig beskrivning: <br /> <!--<asp:FormView ID="FormView2" runat="server" DataSourceID="SqlDataSource1" DefaultMode="Insert"> <InsertItemTemplate>--> <table cellpadding="0" cellspacing="4"> <tr> <td> <asp:TextBox ID="txtPersonligPresentation" Text='<%# Bind("presentation") %>' runat="server" Width="175" Rows="6" TextMode="MultiLine"></asp:TextBox> </td> <tr> </tr> <td align="right"> <!-- LOCATION 3 --> <asp:Button ID="InsertButton" CommandName="Insert" CausesValidation="True" runat="server" Text="Spara" /> </td> </tr> </table> <!-- </InsertItemTemplate> </asp:FormView> --> </td> <td width="20"></td> </tr> </table> </td> </tr> <tr> <td width="240" style="background-image: url('Images/bottenskugga_Mini.jpg'); background-repeat: repeat-y; background-position: center bottom"> </td> </tr> </table> </td> </tr> <tr> <!-- Botten skuggor --> <td width="500" height="20" style="background-image: url('Images/bottenskugga_Liten.jpg'); background-repeat: no-repeat; background-position: center bottom"> <table cellpadding="0" cellspacing="0"> <tr> <td width="20"></td> <td width="460"></td> <td width="20"></td> </tr> </table> </td> </tr> </table> </InsertItemTemplate> </asp:FormView></asp:Content>Is it possible to solve this? 
Sql server 2005 with default formview problem
Posted - 2008-03-19 : 06:42:57
