"anonym***@gmail.com" wrote:

> Hello,
>
> I started working with the ObjectDataSource today.  I have the select,
> and have been working on getting the update method to work.  Here is
> the asp code for my Data source:
>
> <asp:ObjectDataSource ID="dsourceApps" runat="server"
> SelectMethod="getAllApplications"
>         TypeName="AppMgr.AppManager" UpdateMethod="updateAppHdr"
>         ConflictDetection="CompareAllValues"
> OldValuesParameterFormatString="{0}_old"
>         OnObjectCreating="dsourceApps_OnObjectCreating"
> OnObjectDisposing="dsourceApps_OnObjectDisposing">
>         <UpdateParameters>
>             <asp:Parameter Name="appid" Type="String" />
>             <asp:Parameter Name="appname" Type="String" />
>             <asp:Parameter Name="apploc" Type="String" />
>             <asp:Parameter Name="appdesc" Type="String" />
>             <asp:Parameter Name="appid_old" Type="String" />
>             <asp:Parameter Name="appname_old" Type="String" />
>             <asp:Parameter Name="apploc_old" Type="String" />
>             <asp:Parameter Name="appdesc_old" Type="String" />
>         </UpdateParameters>
>     </asp:ObjectDataSource>
>
>
> The function sig for the updateAppHdr function is:
>
> public void updateAppHdr(string appid, string appname, string apploc,
> string appdesc, string appid_old, string appname_old, string
> apploc_old, string appdesc_old)
>
> The error that I get after I hit the save button after editing a field
> in my GridView is:
>
> Exception Details: System.Data.OracleClient.OracleException: ORA-06550:
> line 1, column 7:
> PLS-00306: wrong number or types of arguments in call to
> 'ND_UPD_DEFINED_APP'
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
>
> I did some digging, and I'm noticing that all the new values (the
> fields without "_old" appended) are coming into the function as NULL.
> The old values are coming in properly, but the new values are just
> null...
>
> Any ideas why this is happening?  It's actually getting into the
> function, so I'm guessing it has something to do with the way the
> gridview is setup... I can't seem to find anything on this on google,
> or maybe I'm just not sure what to look for...
>
> Thanks in advance for any help,
> Mike
>
>

"Mike" wrote:

> Thanks Phillip, I was away for a few days or I would have replied
> sooner.
>
> I did what you suggested, in the function to do the update, I went
> ahead and hardcoded some values for the "new" fields (bypassing the
> NULL's that were coming in) and the stored proc fired and executed just
> fine.
>
> The problem has to be with the null's getting passed in, but I can't
> seem to track it down yet.  Any more suggestions?
>
> Thanks,
> Mike
>
>

> Welcome back Mike.
>
> My first guess would be the 2-way databinding.  The ObjectDataSource would
> pass null for the parameter values if the databound server control was not
> using 2-way databinding, e.g. if you had used itemtemplates in the GridView
> with controls bound using the Eval method instead of the Bind, e.g.:
> <asp:TextBox ID="txtapploc" runat="server" Text='<%# Eval("apploc"")
> %>'></asp:TextBox>
>
> --
> HTH,
> Phillip Williams
> http://www.societopia.net
> http://www.webswapp.com
>
>
> "Mike" wrote:
>
> > Thanks Phillip, I was away for a few days or I would have replied
> > sooner.
> >
> > I did what you suggested, in the function to do the update, I went
> > ahead and hardcoded some values for the "new" fields (bypassing the
> > NULL's that were coming in) and the stored proc fired and executed just
> > fine.
> >
> > The problem has to be with the null's getting passed in, but I can't
> > seem to track it down yet.  Any more suggestions?
> >
> > Thanks,
> > Mike
> >
> >

"Mike" wrote:

> Hi again Phillip...
>
> I did some googling, but I'm not understanding what you mean by this...
> how do I implement 2 way databinding between the gridview and my
> object?  By using itemtemplates?
>
> I'll keep looking, and thanks again for your help,
> Mike
>
>
> Phillip Williams wrote:
> > Welcome back Mike.
> >
> > My first guess would be the 2-way databinding.  The ObjectDataSource would
> > pass null for the parameter values if the databound server control was not
> > using 2-way databinding, e.g. if you had used itemtemplates in the GridView
> > with controls bound using the Eval method instead of the Bind, e.g.:
> > <asp:TextBox ID="txtapploc" runat="server" Text='<%# Eval("apploc"")
> > %>'></asp:TextBox>
> >
> > --
> > HTH,
> > Phillip Williams
> > http://www.societopia.net
> > http://www.webswapp.com
> >
> >
> > "Mike" wrote:
> >
> > > Thanks Phillip, I was away for a few days or I would have replied
> > > sooner.
> > >
> > > I did what you suggested, in the function to do the update, I went
> > > ahead and hardcoded some values for the "new" fields (bypassing the
> > > NULL's that were coming in) and the stored proc fired and executed just
> > > fine.
> > >
> > > The problem has to be with the null's getting passed in, but I can't
> > > seem to track it down yet.  Any more suggestions?
> > >
> > > Thanks,
> > > Mike
> > >
> > >
>
>

"Mike" wrote:

> I checked out your source, and cannot see anything that you're really
> doing different than me.  I even changed an item to be a template
> column and that did nothing for me as well...
>
> Below is my markup for the gridview and datasource... Thanks again!
>
> --------------------------------------------------
>     <asp:GridView ID="gvAppList" runat="server" AllowPaging="True"
> AllowSorting="True"
>         Caption="Application List" CssClass="tabledisplay"
> DataSourceID="dsourceApps"
>         HorizontalAlign="Center" PageSize="5" Width="95%"
> CaptionAlign="Top" CellPadding="4" ForeColor="#333333"
>         GridLines="None" AutoGenerateColumns="False"
> OnRowUpdating="gvAppList_OnRowUpdating"
>         AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"
>         AutoGenerateSelectButton="True">
>         <Columns>
>             <asp:CommandField ShowSelectButton="True" />
>             <asp:BoundField DataField="APPID" HeaderText="App ID"
> SortExpression="appid" ApplyFormatInEditMode="True" />
>             <asp:TemplateField HeaderText="Name"
> SortExpression="APPNAME">
>                 <EditItemTemplate>
>                     <asp:TextBox ID="TextBox1" runat="server" Text='<%#
> Bind("APPNAME") %>'></asp:TextBox>
>                 </EditItemTemplate>
>                 <ItemTemplate>
>                     <asp:Label ID="Label1" runat="server" Text='<%#
> Bind("APPNAME") %>'></asp:Label>
>                 </ItemTemplate>
>             </asp:TemplateField>
>             <asp:BoundField DataField="APPLOC" HeaderText="Location"
> SortExpression="APPLOC"  />
>             <asp:BoundField DataField="APPDESC"
> HeaderText="Description" SortExpression="APPDESC" />
>         </Columns>
>         <FooterStyle BackColor="#507CD1" Font-Bold="True"
> ForeColor="White" />
>         <RowStyle BackColor="#EFF3FB" />
>         <EditRowStyle BackColor="#2461BF" />
>         <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True"
> ForeColor="#333333" />
>         <PagerStyle BackColor="#2461BF" ForeColor="White"
> HorizontalAlign="Center" />
>         <HeaderStyle BackColor="#507CD1" Font-Bold="True"
> ForeColor="White" />
>         <AlternatingRowStyle BackColor="White" />
>     </asp:GridView>
>     <asp:ObjectDataSource ID="dsourceApps" runat="server"
> SelectMethod="getAllApplications"
>         TypeName="AppMgr.AppManager" UpdateMethod="updateAppHdr"
>         ConflictDetection="CompareAllValues"
> OldValuesParameterFormatString="{0}_old"
>         OnObjectCreating="dsourceApps_OnObjectCreating"
> OnObjectDisposing="dsourceApps_OnObjectDisposing">
>         <UpdateParameters>
>             <asp:Parameter Name="appid" Type="String" />
>             <asp:Parameter Name="appname" Type="String" />
>             <asp:Parameter Name="apploc" Type="String" />
>             <asp:Parameter Name="appdesc" Type="String" />
>             <asp:Parameter Name="appid_old" Type="String" />
>             <asp:Parameter Name="appname_old" Type="String" />
>             <asp:Parameter Name="apploc_old" Type="String" />
>             <asp:Parameter Name="appdesc_old" Type="String" />
>         </UpdateParameters>
>     </asp:ObjectDataSource>
> ---------------------------------------
>
>

"Mike" wrote:

> I took the code out of the masterpage and put it in it's own page,
> hooked up the necessary events and fired it off and the values are
> coming through fine, just like on your site.
>
> So I guess now the question moves on to why is the masterpage messing
> with my viewstate values on the return?
>
> Thanks again for your help,
> Mike
>
>

"Mike" wrote:

> Phillip,
>
> I found the cause.  There's a user control in my master page that holds
> a username/password (login-type) area.  This is all that is going into
> the viewstate (found it in the trace output), so when I'm clicking the
> update button on the grid, it's not sending those updated values back
> (the viewstate only contains the username & password fields).
>
> I removed the username/pw form and tried again, and sure enough, the
> values got passed properly.
>
> Off to figure out why ... Thanks again very much for all the help, I
> greatly appreciate it.
>
> Mike
>
>