[es] - DetailsView kontrola - trivijalni problem

VerbatimBOT
Aleksandar Dragosavac
Senior .NET Developer

Član broj: 84129
Poruke: 228
*.kalik.info.

Profil

DetailsView kontrola - trivijalni problem

^{22.07.2006. u 12:44 - pre 216 meseci}

Evo o čemu se zapravo radi: imam jedan detailsView koji je vezan za tabelu u bazi.

Tabela ima primarni ključ (ID) koji je setovan na IDENTITY(1,1), SqlDataSource je

generisao Insert, Update i Delete upite.
Medjutim, kada štikliram sa ovaj detailsView da omogućava Insert, Update i Delete, pri

pokušaju ovih operacija dobijam sledeću poruku:

Code:

Incorrect syntax near 'nvarchar'.
Description: An unhandled exception occurred during the execution of the current web

request. Please review the stack trace for more information about the error and where it

originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near 'nvarchar'.

Source Error:

An unhandled exception was generated during the execution of the current web request.

Information regarding the origin and location of the exception can be identified using

the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Incorrect syntax near 'nvarchar'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean

breakConnection) +95
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean

breakConnection) +82
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject

stateObj) +346
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler,

SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject

stateObj) +3244
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior

runBehavior, String resetOptionsString) +186
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior,

RunBehavior runBehavior, Boolean returnStream, Boolean async) +1121
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior,

RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +334
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String

methodName, Boolean sendToPipe) +407
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +149
   System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand command,

DataSourceOperation operation) +493
   System.Web.UI.WebControls.SqlDataSourceView.ExecuteUpdate(IDictionary keys,

IDictionary values, IDictionary oldValues) +915
   System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary

oldValues, DataSourceViewOperationCallback callback) +179
   System.Web.UI.WebControls.DetailsView.HandleUpdate(String commandArg, Boolean

causesValidation) +1199
   System.Web.UI.WebControls.DetailsView.HandleEvent(EventArgs e, Boolean

causesValidation, String validationGroup) +545
   System.Web.UI.WebControls.DetailsView.OnBubbleEvent(Object source, EventArgs e) +162
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +56
   System.Web.UI.WebControls.DetailsViewRow.OnBubbleEvent(Object source, EventArgs e)

+117
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +56
   System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +106
   System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +175


System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEv

ent(String eventArgument) +31
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String

eventArgument) +32
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +242
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean

includeStagesAfterAsyncPoint) +3839

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET

Version:2.0.50727.42

Jel zna neko o čemu se ovde radi?

Winners never quit, quitters never win.

Odgovor na temu

kaan
Kaurin Andrej
Telerik, Bulgaria
Banjaluka

Član broj: 1741
Poruke: 109
*.broadband.blic.net.

ICQ: 47193919

Profil

Re: DetailsView kontrola - trivijalni problem

^{22.07.2006. u 19:23 - pre 216 meseci}

Pa daj code da vidimo.

Kaurin Andrej

Odgovor na temu

VerbatimBOT
Aleksandar Dragosavac
Senior .NET Developer

Član broj: 84129
Poruke: 228
*.kalik.info.

Profil

Re: DetailsView kontrola - trivijalni problem

^{22.07.2006. u 21:13 - pre 216 meseci}

Pa evo bre...

Code:

protected void Page_Load(object sender, EventArgs e)
    {
        // ... ovde je neka provera

        if (DetailsView1.DataItemCount == 0)
            DetailsView1.ChangeMode(DetailsViewMode.Insert);
    }

A u Source-u stranice

Code:

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <strong>ADMINISTRACIJA KATEGORIJA OGLASA<asp:DetailsView ID="DetailsView1" runat="server"
        AllowPaging="True" AutoGenerateRows="False" CellPadding="4" DataKeyNames="ID kategorije"
        DataSourceID="SqlDataSource1" ForeColor="#333333" Height="50px" Style="position: relative"
        Width="417px">
        <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
        <CommandRowStyle BackColor="#C5BBAF" Font-Bold="True" />
        <EditRowStyle BackColor="#7C6F57" />
        <RowStyle BackColor="#E3EAEB" />
        <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
        <FieldHeaderStyle BackColor="#D0D0D0" Font-Bold="True" />
        <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
        <AlternatingRowStyle BackColor="White" />
        <Fields>
            <asp:BoundField DataField="Naziv kategorije" HeaderText="Naziv kategorije" SortExpression="Naziv kategorije" />
            <asp:BoundField DataField="Aktivno" HeaderText="Aktivno" SortExpression="Aktivno" />
            <asp:BoundField DataField="ID kategorije" HeaderText="ID kategorije" InsertVisible="False"
                ReadOnly="True" SortExpression="ID kategorije" />
            <asp:CommandField CancelText="Poništi" DeleteText="Obriši" EditText="Izmeni" InsertText="Unesi"
                NewText="Novi unos" SelectText="Označi" ShowDeleteButton="True" ShowEditButton="True"
                ShowInsertButton="True" />
        </Fields>
    </asp:DetailsView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString %>"
        DeleteCommand="DELETE FROM [tblKategorije] WHERE [ID kategorije] = @ID_kategorije"
        InsertCommand="INSERT INTO [tblKategorije] ([Naziv kategorije], [Aktivno]) VALUES (@Naziv_kategorije, @Aktivno)"
        SelectCommand="SELECT * FROM [tblKategorije]" UpdateCommand="UPDATE [tblKategorije] SET [Naziv kategorije] = @Naziv_kategorije, [Aktivno] = @Aktivno WHERE [ID kategorije] = @ID_kategorije">
        <DeleteParameters>
            <asp:Parameter Name="ID_kategorije" Type="Int64" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="Naziv_kategorije" Type="String" />
            <asp:Parameter Name="Aktivno" Type="Boolean" />
            <asp:Parameter Name="ID_kategorije" Type="Int64" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="Naziv_kategorije" Type="String" />
            <asp:Parameter Name="Aktivno" Type="Boolean" />
        </InsertParameters>
    </asp:SqlDataSource>
        <br />
    </strong>
</asp:Content>

Pomagaj! :)

Winners never quit, quitters never win.

Odgovor na temu

kaan
Kaurin Andrej
Telerik, Bulgaria
Banjaluka

Član broj: 1741
Poruke: 109
*.broadband.blic.net.

ICQ: 47193919

Profil

Re: DetailsView kontrola - trivijalni problem

^{23.07.2006. u 10:26 - pre 216 meseci}

Jedino sto mi pada na pamet je da "Naziv kategorije" moras da stavish pod navodnike jer ima space tj. ime kolone se sastoji iz 2+ rijechi.

Kaurin Andrej

Odgovor na temu

VerbatimBOT
Aleksandar Dragosavac
Senior .NET Developer

Član broj: 84129
Poruke: 228
*.kalik.info.

Profil

Re: DetailsView kontrola - trivijalni problem

^{23.07.2006. u 13:21 - pre 216 meseci}

Gde to? Svuda gde mi se pominje Naziv kategorije je stavljeno u okviru uglastih zagrada.

Winners never quit, quitters never win.

Odgovor na temu

VerbatimBOT
Aleksandar Dragosavac
Senior .NET Developer

Član broj: 84129
Poruke: 228
*.kalik.info.

Profil

Re: DetailsView kontrola - trivijalni problem

^{23.07.2006. u 20:08 - pre 216 meseci}

Delimično sam rešio problem tako što sam sve kolone u bazi koje imaju space preimenovao tako da nemaju razmak.

Ali evo novog problema: Imam drugi detailsView koji nije vezan ni za jedan SqlDataSource, imam 6 SqlDataSource kontrola i u zavisnosti od toga na koje se dugme klikne, detailsView mi se vezuje za odredjeni SqlDataSource.
To sve lepo radi, ali ne mogu sada da vršim update.

Greška je sledeća:

Code:

The DetailsView 'DetailsView1' fired event ModeChanging which wasn't handled.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: The DetailsView 'DetailsView1' fired event ModeChanging which wasn't handled.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[HttpException (0x80004005): The DetailsView 'DetailsView1' fired event ModeChanging which wasn't handled.]
   System.Web.UI.WebControls.DetailsView.OnModeChanging(DetailsViewModeEventArgs e) +324
   System.Web.UI.WebControls.DetailsView.HandleEdit() +84
   System.Web.UI.WebControls.DetailsView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +457
   System.Web.UI.WebControls.DetailsView.RaisePostBackEvent(String eventArgument) +212
   System.Web.UI.WebControls.DetailsView.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +31
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +32
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +244
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3839

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

Jel ima neko ideju kako da "handle"-ujem ChangeMode za detailsView?

I još jedno pitanje: Stranica mi se drastično razlikuje kada je otvorim u Mozilla Firefox-u, tako da ne daj bože ako neko bude pristupao preko nekog drugog browsera sem IE, neće videti neke stvari onako kako sam hteo. Jel postoji neko rešenje za ovo?

Winners never quit, quitters never win.

Odgovor na temu