Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 370
  • Last Modified:

How do i modify the default update method for an asp.net datagrid with object data source to SQL Server backend.

Hi Everyone!
Hey, first time question poster here, I've worked only a bit with asp.net and bringing datagrids out for managing sqlServer Data. So I am 'somewhat' comfortable with the various sheets and places which to find certain tags, etc. But I can tell very quickly that there is much for me to learn on it.

Here's the question:
I have a datagrid which is displaying table data, and have enabled Updating.  I've set up all of the fields as item templates so that i could add an "Insert" row in the footerRow of the gridview.
-Everything is working wonderful at this point-
I decide to make 1 field no longer editable, which is usually accomplished by knocking out the <EditItemTemplate> tag and it's contents, or at the very least, change the contained textbox to simply a label. The reason i don't want this editible anymore is because i want to drive this field off of another one.
for example

Name | Id | effective_dte | term_dte |.......


I can look the name up (which i already do on the insert method) so that when an ID# is typed into the footer row and inserted, it mines the Name from the name table.... it is however relevant and useful for the users to have this information displayed (and this field is just informational), i just don't want to rely on them for accuracy of it and figured why not just drive it off of the name table.
I have modified the update method to be this:

Update MyTable
Set MyNameField = (SELECT NmeFld FROM MyNameTable WHERE IdFld = @IdParam)
, MyIdFld = @IdParam
, MyEffDte = @EffParam
, MyTrmDte = @TrmParam)

-The reason i do this is in case someone inadvertently types an incorrect Id# into the table, they can go back and edit the ID# which will refresh the contents of the name field (regardless of your agreement or lack thereof, it's the greater functionality rather than this specific case which is evading me and i seek and answer to)

Everything looks slick like it should work fine (just as it did when i pulled the same thing off for the Insert Method (which works perfect) but every time i go to update a record it throws this:

Exception Details: System.InvalidOperationException: ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'Update' that has parameters: CLT_BSU, PGRM_EFFECTIVE_DTE, PGRM_TERMINATE_DTE, original_CLT_PGRM_NO, CLT_PGRM_NO, CLT_NAME.

(where CLT_BSU = MyIdFld, Pgrm_Effective_dte = MyEffDte, Pgrm_Terminate_dte = MyTrmDte, CLT_PGRM_NO is my PK field, CLT_NAME = MyNameFld)


-Keep in mind everything worked perfectly until i modified the update method. I've also pulled the <Parameter> tags out for CLT_NAME in my .aspx page in the update section and modified the .xsd page...

Any Idea where/why this would hang up here? (and why it worked fine for the insert Method?)

Many Thanks!
-John
0
JohnSingleton
Asked:
JohnSingleton
  • 6
  • 6
2 Solutions
 
Kyle AbrahamsSenior .Net DeveloperCommented:
You say the problem first started when you made the field no longer editable . . . what if you reverted it back to a textbox but disabled it?  

Also note the following:
CLT_BSU, PGRM_EFFECTIVE_DTE, PGRM_TERMINATE_DTE, original_CLT_PGRM_NO, CLT_PGRM_NO, CLT_NAME.

(where CLT_BSU = MyIdFld, Pgrm_Effective_dte = MyEffDte, Pgrm_Terminate_dte = MyTrmDte, CLT_PGRM_NO is my PK field, CLT_NAME = MyNameFld)

You're passing in original_CLT_PGRM_NO  but it's not used in the where.  

Welcome to EE.
0
 
JohnSingletonAuthor Commented:
Thanks for the welcome, i'd actually joined in mid Dec. but only been answering questions and hadn't a need to post anything till now.

-I am actually using it (original_CLT_PGRM_NO) in the where, i'd just stripped it out to get to the meat and potatoes which is in the SET portion...


-well, i know it will work because i've done if for my CLT_PGRM_NO field as it's my primary key... obviously don't want it ediable, so i knocked out the <EditItemTemplate> tag for that column in the .aspx page and now my CLT_PGRM_NO and CLT_NAME field both still display, but rather just as labels while in Edit Mode (where the other fields to the right display textboxes).... which is exactly how i envisioned it to work.

the only difference between between the CLT_PGRM_NO field and this CLT_NAME field is that i've not included the the CLT_PGRM_NO field at all in the SET portion of the Update Method SQL, and the CLT_NAME field i still have in as "SET CLT_NAME = (SELECT CLIENT_NAME FROM....where....)"

-i think that's what's fouling it up, but can't figure out why because it worked fine when i did the same thing to the insert method...
-I've also tested/executed from within the .XSD page query windo, it works like a charm there. it's something with the TableAdapter between the .XSD and the ObjectDataSource on the .aspx page. Someone's expecting that parameter or rather posting it when it shouldn't be...... just can't find the right place to look.

I think if i could figure out how to read the stack trace, i'd be golden, but haven't made heads nor tails of it yet.


-When looking at the Stack Trace keep in Mind, I've stripped out most of these things in the question which aren't relevant, such as "MCI_NO", "IPS_END_DTE",,,,,nothing whatsoever has changed with anything besides CLT_NAME....
and prior to it was working beautifully.


Many Thanks!
-John
Stack Trace:
 
[InvalidOperationException: ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'Update' that has parameters: CLT_BSU, MCI_NO, PROGRAM_TYPE, ISP_END_DATE, ISP_REVIEW_DATE, PGRM_EFFECTIVE_DTE, PGRM_TERMINATE_DTE, original_CLT_PGRM_NO, CLT_PGRM_NO, CLT_NAME.]
   System.Web.UI.WebControls.ObjectDataSourceView.GetResolvedMethodData(Type type, String methodName, IDictionary allParameters, DataSourceOperation operation) +1122846
   System.Web.UI.WebControls.ObjectDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues) +1008
   System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) +92
   System.Web.UI.WebControls.GridView.HandleUpdate(GridViewRow row, Int32 rowIndex, Boolean causesValidation) +907
   System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +704
   System.Web.UI.WebControls.GridView.OnBubbleEvent(Object source, EventArgs e) +95
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
   System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source, EventArgs e) +123
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
   System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +118
   System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +135
   System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +175
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

Open in new window

0
 
Kyle AbrahamsSenior .Net DeveloperCommented:
as long as it's not editable, why not try including the CLT_PGRM_NO in the update.  It will just get copied the same.  Are you using the generic update or you have your own datagrid update command you're using?

Also same thing with the client name, no need to go fetch it if you're not allowing people to edit it, just use it right from the datagrid.
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
Kyle AbrahamsSenior .Net DeveloperCommented:
Actually, that's exactly your problem:
could not find a non-generic method 'Update' that has parameters: CLT_BSU, MCI_NO, PROGRAM_TYPE, ISP_END_DATE, ISP_REVIEW_DATE, PGRM_EFFECTIVE_DTE, PGRM_TERMINATE_DTE, original_CLT_PGRM_NO, CLT_PGRM_NO, CLT_NAME.]

No CLT_PGRM_NO in the update, and therefore you're passing one less value then you are columns.
0
 
JohnSingletonAuthor Commented:

Alright, That sounds plausible, just can't for the life of me figure out how i'd contaminated that by simply replacing

SET CLT_NAME = @CLT_NAME, ....
 with
SET CLT_NAME = (SELECT CLIENT_NAME FROM CLIENT_TABLE WHERE CLIENT_ID = @BSU_NO), ....


----As soon as I added to the "SET" portion of the update CLT_PGRM_ID = @CLT_PGRM_ID -visualWebDeveloper threw:

'Column or expression 'CLT_PGRM_NO' cannot be updated.'

then kindly removed it for me, haha. intellisense, gotta love it.


Yeah, it was the original Default Update Method that the TableAdapter created for me and had linked to the ObjectDataSource, until i started to monkey with it : )


-John

0
 
Kyle AbrahamsSenior .Net DeveloperCommented:
TableAdapter Via the GUI?  Can you regenerate it by deleting and then re-adding?  Were there any other changes?
0
 
JohnSingletonAuthor Commented:
Yeah, only change i'd made to the update method. the insert i'd done the same stuff to.


Problem with rebuilding it is that it'll replace all of my custom <asp:TemplateField> i'd built into the grid for each colum with <asp:BoundField> tags....
I've innocently blundered across that land mine before with much larger tables, hahaha, it'll also wipe out my footer row insert line contained in the templatefields.

let me copy what i believe to be the relevant parts of the .aspx/ .xsd where i'd made changes and the update information resides. i've made no changes to nor contain anything in the code behind which is relevant to the update process, but rather just the insert process (being built-in, there is nothing involved in hooking up the updates).

-keep in mind, i'm a nOOb to c# and .Net.   I've programmed and coded for years with VB/SQL/Crystal Rpts, bat, asp, but this is a different monster.... be gentle.... haha

-John


----------------------------------------------------
Here is a sample from the .aspx page:
NOTE: I'd knocked the CLT_NAME parameter out of the UPDATEParameter Tag
----------------------------------------------------
 
 
        <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" 
            DeleteMethod="Delete" InsertMethod="Insert"
            OnInserting="ObjectDataSource1_Inserting"
            OldValuesParameterFormatString="original_{0}" SelectMethod="GetCltPgrmType" 
            TypeName="CltProgramTypeTableAdapters.HCSIS_PROGRAM_TYPETableAdapter" 
            UpdateMethod="Update">
            <DeleteParameters>
                <asp:Parameter Name="Original_CLT_PGRM_NO" Type="Int32" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="CLT_BSU" Type="String" />
                <asp:Parameter Name="MCI_NO" Type="String" />
                <asp:Parameter Name="PROGRAM_TYPE" Type="String" />
                <asp:Parameter Name="ISP_END_DATE" Type="DateTime" />
                <asp:Parameter Name="ISP_REVIEW_DATE" Type="DateTime" />
                <asp:Parameter Name="PGRM_EFFECTIVE_DTE" Type="DateTime" />
                <asp:Parameter Name="PGRM_TERMINATE_DTE" Type="DateTime" />
                <asp:Parameter Name="Original_CLT_PGRM_NO" Type="Int32" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="insCLT_BSU" Type="String" />
                <asp:Parameter Name="insPROGRAM_TYPE" Type="String" />
                <asp:Parameter Name="insPGRM_EFFECTIVE_DTE" Type="DateTime" />
                <asp:Parameter Name="insPGRM_TERMINATE_DTE" Type="DateTime" />
            </InsertParameters>
        </asp:ObjectDataSource>
        <asp:ObjectDataSource ID="ObjectDataSource2" runat="server" 
            OldValuesParameterFormatString="original_{0}" SelectMethod="GetPgrmDscr" 
            TypeName="CltProgramTypeTableAdapters.PROGRAM_TYPESTableAdapter">
        </asp:ObjectDataSource>
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
            AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="CLT_PGRM_NO" 
            DataSourceID="ObjectDataSource1" CssClass="GridViewStyle" PageSize="25"
            showfooter="True" OnRowCommand="GridView1_RowCommand1" >
            <HeaderStyle foreColor="White" CssClass="HeaderStyle" />
            <RowStyle CssClass="RowStyle" />
            <AlternatingRowStyle CssClass="AlternatingRowStyle" />
            <EditRowStyle CssClass="EditRowStyle" />
            <FooterStyle CssClass="FooterStyle" />
            <SelectedRowStyle CssClass="SelectedRowStyle" />
 
            <Columns>
                <asp:CommandField ShowEditButton="True" />
                <asp:TemplateField HeaderText="CLT_PGRM_NO" SortExpression="CLT_PGRM_NO">
                    <ItemTemplate>
                        <asp:Label ID="lblCLT_PGRM_NO" runat="server" Text='<%# Bind("CLT_PGRM_NO") %>' />
                    </ItemTemplate>
                    <FooterTemplate>
                        <asp:Button ID="btnInsert" runat="server"
                            CommandName="Insert_" Text="Create"
                            CausesValidation="false" />
                    </FooterTemplate>                
                </asp:TemplateField>
                <asp:TemplateField HeaderText="CLT_NAME" SortExpression="CLT_NAME">
                    <ItemTemplate>
                        <asp:Label ID="lblCLT_NAME" runat="server" Text='<%# Bind("CLT_NAME") %>' />
                    </ItemTemplate>
 
                </asp:TemplateField>
                <asp:TemplateField HeaderText="CLT_BSU" SortExpression="CLT_BSU">
                    <ItemTemplate>
                        <asp:Label ID="lblCLT_BSU" runat="server" Text='<%# Bind("CLT_BSU") %>' />
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox ID="CLT_BSU" runat="server" Text='<%# Bind("CLT_BSU") %>' />
                    </EditItemTemplate>
                    <FooterTemplate>
                        <asp:TextBox ID="insCLT_BSU" runat="server" Text='<%# Bind("CLT_BSU") %>' />
                    </FooterTemplate>
                </asp:TemplateField>
 
 
 
----------------------------------------------------
Here's the .XSD Page Contents. This is where I'd modified the Update Method:
----------------------------------------------------
 
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE DomainUsers.HCSIS_PROGRAM_TYPE
SET          CLT_NAME = (SELECT CLNAME FROM FCCPROD.Domainusers.SQL_CLIENT WHERE CLALPH = @CLT_BSU), CLT_BSU = @CLT_BSU, MCI_NO = @MCI_NO, PROGRAM_TYPE = @PROGRAM_TYPE, ISP_END_DATE = @ISP_END_DATE, ISP_REVIEW_DATE = @ISP_REVIEW_DATE, 
                  PGRM_EFFECTIVE_DTE = @PGRM_EFFECTIVE_DTE, PGRM_TERMINATE_DTE = @PGRM_TERMINATE_DTE
WHERE  (CLT_PGRM_NO = @Original_CLT_PGRM_NO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CLT_BSU" ColumnName="CLT_BSU" DataSourceName="HCSIS.DomainUsers.HCSIS_PROGRAM_TYPE" DataTypeServer="nvarchar(12)" DbType="String" Direction="Input" ParameterName="@CLT_BSU" Precision="0" ProviderType="NVarChar" Scale="0" Size="12" SourceColumn="CLT_BSU" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="MCI_NO" ColumnName="MCI_NO" DataSourceName="HCSIS.DomainUsers.HCSIS_PROGRAM_TYPE" DataTypeServer="nvarchar(9)" DbType="String" Direction="Input" ParameterName="@MCI_NO" Precision="0" ProviderType="NVarChar" Scale="0" Size="9" SourceColumn="MCI_NO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PROGRAM_TYPE" ColumnName="PROGRAM_TYPE" DataSourceName="HCSIS.DomainUsers.HCSIS_PROGRAM_TYPE" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@PROGRAM_TYPE" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="PROGRAM_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ISP_END_DATE" ColumnName="ISP_END_DATE" DataSourceName="HCSIS.DomainUsers.HCSIS_PROGRAM_TYPE" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@ISP_END_DATE" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="ISP_END_DATE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ISP_REVIEW_DATE" ColumnName="ISP_REVIEW_DATE" DataSourceName="HCSIS.DomainUsers.HCSIS_PROGRAM_TYPE" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@ISP_REVIEW_DATE" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="ISP_REVIEW_DATE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PGRM_EFFECTIVE_DTE" ColumnName="PGRM_EFFECTIVE_DTE" DataSourceName="HCSIS.DomainUsers.HCSIS_PROGRAM_TYPE" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@PGRM_EFFECTIVE_DTE" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="PGRM_EFFECTIVE_DTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PGRM_TERMINATE_DTE" ColumnName="PGRM_TERMINATE_DTE" DataSourceName="HCSIS.DomainUsers.HCSIS_PROGRAM_TYPE" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@PGRM_TERMINATE_DTE" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="PGRM_TERMINATE_DTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Original_CLT_PGRM_NO" ColumnName="CLT_PGRM_NO" DataSourceName="HCSIS.DomainUsers.HCSIS_PROGRAM_TYPE" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Original_CLT_PGRM_NO" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CLT_PGRM_NO" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CLT_PGRM_NO" DataSetColumn="CLT_PGRM_NO" />
              <Mapping SourceColumn="CLT_NAME" DataSetColumn="CLT_NAME" />
              <Mapping SourceColumn="CLT_BSU" DataSetColumn="CLT_BSU" />
              <Mapping SourceColumn="MCI_NO" DataSetColumn="MCI_NO" />
              <Mapping SourceColumn="PROGRAM_TYPE" DataSetColumn="PROGRAM_TYPE" />
              <Mapping SourceColumn="ISP_END_DATE" DataSetColumn="ISP_END_DATE" />
              <Mapping SourceColumn="ISP_REVIEW_DATE" DataSetColumn="ISP_REVIEW_DATE" />
              <Mapping SourceColumn="PGRM_EFFECTIVE_DTE" DataSetColumn="PGRM_EFFECTIVE_DTE" />
              <Mapping SourceColumn="PGRM_TERMINATE_DTE" DataSetColumn="PGRM_TERMINATE_DTE" />
            </Mappings>
            <Sources />
          </TableAdapter>

Open in new window

0
 
JohnSingletonAuthor Commented:
ooo, ooo, ooo, you may be onto something ged325....

when i look at the UpdateMethod of the objectdatasource GUI from the .aspx designer, i see the update method alright, but my custom field "CLT_NAME" is not shown.......

from within the update window is shows as the method signature:

Update(String CLT_BSU, String MCI_NO, String PROGRAM_TYPE, Nullable<DateTime> ISP_END_DATE, Nullable<DateTime> ISP_REVIEW_DATE, DateTime PGRM_EFFECTIVE_DTE, Nullable<DateTime> PGRM_TERMINATE_DTE, Int32 Original_CLT_PGRM_NO), returns Int32


have to figure out how to edit this,  i may have to rebuild it. rats.

i'll keep you posted.

-John
0
 
JohnSingletonAuthor Commented:
hey, I'm out of here for the week, I'll be back Monday to resume. many thanks so far,

-also of note: remember i did the same thing on the insert? well the GUI doesn't show CLT_NAME in the insert method signature either, so the update and insert are consistent.... hmm.

-John
0
 
Kyle AbrahamsSenior .Net DeveloperCommented:
Would recommend copying your table, then rebuild your code as necessary.
0
 
Kyle AbrahamsSenior .Net DeveloperCommented:
^^ copy the code so you can paste all of it in, let it rebuild the update as necessary.  Have a great weekend.
0
 
JohnSingletonAuthor Commented:
Well, I've done it a couple times.... To no avail...
Finally i began trying every combination of parameters/sql i could think of and found what i'd been missing.....

within the .xsd file I modified the code to be that which is in the code window.
You can see that the update command uses the subquery to derive the client name.

I had to add dummy parameters in here for CLT_PGRM_NO and CLT_NAME (at least they seemed dummy to me as i'm not using them within the SQL update.)

tested, and works beautiful both ways (when a lookup finds a clt_name) and also when a bad CLT_BSU # is entered and no CLT_NAME is found....

-John
      <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE DomainUsers.HCSIS_PROGRAM_TYPE
SET          CLT_BSU = @CLT_BSU, MCI_NO = @MCI_NO, PROGRAM_TYPE = @PROGRAM_TYPE, ISP_END_DATE = @ISP_END_DATE, ISP_REVIEW_DATE = @ISP_REVIEW_DATE, 
                  PGRM_EFFECTIVE_DTE = @PGRM_EFFECTIVE_DTE, PGRM_TERMINATE_DTE = @PGRM_TERMINATE_DTE, 
                  CLT_NAME = (SELECT CLNAME FROM FCCPROD.DomainUsers.SQL_CLIENT WHERE (CLALPH = @CLT_BSU))
WHERE  (CLT_PGRM_NO = @original_CLT_PGRM_NO)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="CLT_BSU" ColumnName="CLT_BSU" DataSourceName="HCSIS.DomainUsers.HCSIS_PROGRAM_TYPE" DataTypeServer="nvarchar(12)" DbType="String" Direction="Input" ParameterName="@CLT_BSU" Precision="0" ProviderType="NVarChar" Scale="0" Size="12" SourceColumn="CLT_BSU" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="MCI_NO" ColumnName="MCI_NO" DataSourceName="HCSIS.DomainUsers.HCSIS_PROGRAM_TYPE" DataTypeServer="nvarchar(9)" DbType="String" Direction="Input" ParameterName="@MCI_NO" Precision="0" ProviderType="NVarChar" Scale="0" Size="9" SourceColumn="MCI_NO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PROGRAM_TYPE" ColumnName="PROGRAM_TYPE" DataSourceName="HCSIS.DomainUsers.HCSIS_PROGRAM_TYPE" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@PROGRAM_TYPE" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="PROGRAM_TYPE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ISP_END_DATE" ColumnName="ISP_END_DATE" DataSourceName="HCSIS.DomainUsers.HCSIS_PROGRAM_TYPE" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@ISP_END_DATE" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="ISP_END_DATE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="ISP_REVIEW_DATE" ColumnName="ISP_REVIEW_DATE" DataSourceName="HCSIS.DomainUsers.HCSIS_PROGRAM_TYPE" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@ISP_REVIEW_DATE" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="ISP_REVIEW_DATE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="PGRM_EFFECTIVE_DTE" ColumnName="PGRM_EFFECTIVE_DTE" DataSourceName="HCSIS.DomainUsers.HCSIS_PROGRAM_TYPE" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@PGRM_EFFECTIVE_DTE" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="PGRM_EFFECTIVE_DTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="PGRM_TERMINATE_DTE" ColumnName="PGRM_TERMINATE_DTE" DataSourceName="HCSIS.DomainUsers.HCSIS_PROGRAM_TYPE" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@PGRM_TERMINATE_DTE" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="PGRM_TERMINATE_DTE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="original_CLT_PGRM_NO" ColumnName="CLT_PGRM_NO" DataSourceName="HCSIS.DomainUsers.HCSIS_PROGRAM_TYPE" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@original_CLT_PGRM_NO" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CLT_PGRM_NO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="CLT_PGRM_NO" ColumnName="CLT_PGRM_NO" DataSourceName="HCSIS.DomainUsers.HCSIS_PROGRAM_TYPE" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CLT_PGRM_NO" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CLT_PGRM_NO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="True" AutogeneratedName="CLT_NAME" ColumnName="CLT_NAME" DataSourceName="HCSIS.DomainUsers.HCSIS_PROGRAM_TYPE" DataTypeServer="int" DbType="String" Direction="Input" ParameterName="@CLT_NAME" Precision="0" ProviderType="NvarChar" Scale="0" Size="60" SourceColumn="CLT_NAME" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>

Open in new window

0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 6
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now