Update is a type and cannot be used as an expression

'Update' is a type and cannot be used as an expression.
I've searched the forums and lowercased letters with no success.

Here is my code:

Dim SupplierContactNum As String = dataList1.DataKeys(e.Item.ItemIndex).ToString
        Dim SupplierContact As TextBox = CType(e.Item.FindControl("EditSupplierContactTB"), TextBox)
        Dim TitlePosition As TextBox = CType(e.Item.FindControl("EditPositionTB"), TextBox)
        Dim SupplierPhone As TextBox = CType(e.Item.FindControl("EditSupplierPhoneTB"), TextBox)
        Dim CellPhone As TextBox = CType(e.Item.FindControl("EditCellTB"), TextBox)
        Dim Address As TextBox = CType(e.Item.FindControl("EditAddressTB"), TextBox)
        Dim Extension As TextBox = CType(e.Item.FindControl("EditExtensionTB"), TextBox)
        Dim Email As TextBox = CType(e.Item.FindControl("EditEmailTB"), TextBox)
        Dim Fax As TextBox = CType(e.Item.FindControl("EditSupplierFaxTB"), TextBox)


        dataListSQL.UpdateParameters("SupplierContact").DefaultValue = SupplierContact.Text
        dataListSQL.UpdateParameters("Title").DefaultValue = TitlePosition.Text
        dataListSQL.UpdateParameters("SupplierPhone").DefaultValue = SupplierPhone.Text
        dataListSQL.UpdateParameters("CellPhone").DefaultValue = CellPhone.Text
        dataListSQL.UpdateParameters("Address").DefaultValue = Address.Text
        dataListSQL.UpdateParameters("Ext").DefaultValue = Extension.Text
        dataListSQL.UpdateParameters("EmailAddress").DefaultValue = Email.Text
        dataListSQL.UpdateParameters("SupplierFax").DefaultValue = Fax.Text


        dataListSQL.Update()
        dataList1.EditItemIndex = -1
        dataList1.DataBind()

Thanks in advance.

Re: Update is a type and cannot be used as an expression

What type of object is dataListSQL?

What type of object is dataList1?

Re: Update is a type and cannot be used as an expression

dataListSQL is a datasource

dataList1 is a datalist

Re: Update is a type and cannot be used as an expression

>>>dataListSQL is a datasource

What kind of DataSource?

(Sorry to stickle.)

Re: Update is a type and cannot be used as an expression

SQLDataSource .. I think that's what your asking... What I selected to create it in the toolbox?

Re: Update is a type and cannot be used as an expression

MCas --

Hmm.

There IS a parameterless Update method on the SqlDataSource-- that is a fact.

I suggest that in this case one should try this refactor...

Dim myReturn As Integer = dataListSQL.Update()

...and see this link...

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.update.aspx

...and check the code to be sure there is no object called "Update" anywhere...

...and check to make sure the UpdateCommand is set...

...and hopefully that will help.

HTH.

Thank you.

-- Mark Kamoski

Re: Update is a type and cannot be used as an expression

What I don't understand though is that it just started happening since:

-I changed the datakey

-Added a field

That's it. Anyways, I'm leaving work now. So if you reply, I won't reply until tomorrow at 8am. Thanks for your help. I'll test it tomorrow.

Re: Update is a type and cannot be used as an expression

I tried:

Dim myReturn as integer = dataListSQL.Update()

with no success. However, I'm not too sure what I'm supposed to do with myReturn afterwards.

Re: Update is a type and cannot be used as an expression

As it is, I would recommend making a very simplified sample.

Then, once that is done, I would recommend posting both the complete code-infront and the code-behind here.

Regarding this...

MCas86

I tried:

Dim myReturn as integer = dataListSQL.Update()

...what happended when you tried that? When you tried that that did you still get the same error "Update is a type and cannot be used as an expression"?

Please advise.

Thank you.

-- Mark Kamoski

Re: Update is a type and cannot be used as an expression

When i tried the Dim myReturn ...

i just dont know what to do after i make it equal to dataListSQL.Update(). I'm not getting a true error where it pops up and tells me... i added a watch and its just not firing i dont think. The error i listed is what my watch said.

Re: Update is a type and cannot be used as an expression

MCas86

When i tried the Dim myReturn ...

i just dont know what to do after i make it equal to dataListSQL.Update(). I'm not getting a true error where it pops up and tells me... i added a watch and its just not firing i dont think. The error i listed is what my watch said.

You lost me there.

Can you post a complete simplified version of your code that shows the problem?

Re: Update is a type and cannot be used as an expression

Protected Sub DataList1_UpdateCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataListCommandEventArgs) Handles dataList1.UpdateCommand


        Dim SupplierContactNum As String = dataList1.DataKeys(e.Item.ItemIndex).ToString
        Dim SupplierContact As TextBox = CType(e.Item.FindControl("EditSupplierContactTB"), TextBox)
        Dim TitlePosition As TextBox = CType(e.Item.FindControl("EditPositionTB"), TextBox)
        Dim SupplierPhone As TextBox = CType(e.Item.FindControl("EditSupplierPhoneTB"), TextBox)
        Dim CellPhone As TextBox = CType(e.Item.FindControl("EditCellTB"), TextBox)
        Dim Address As TextBox = CType(e.Item.FindControl("EditAddressTB"), TextBox)
        Dim Extension As TextBox = CType(e.Item.FindControl("EditExtensionTB"), TextBox)
        Dim Email As TextBox = CType(e.Item.FindControl("EditEmailTB"), TextBox)
        Dim Fax As TextBox = CType(e.Item.FindControl("EditSupplierFaxTB"), TextBox)


        dataListSQL.UpdateParameters("SupplierContact").DefaultValue = SupplierContact.Text
        dataListSQL.UpdateParameters("Title").DefaultValue = TitlePosition.Text
        dataListSQL.UpdateParameters("SupplierPhone").DefaultValue = SupplierPhone.Text
        dataListSQL.UpdateParameters("CellPhone").DefaultValue = CellPhone.Text
        dataListSQL.UpdateParameters("Address").DefaultValue = Address.Text
        dataListSQL.UpdateParameters("Ext").DefaultValue = Extension.Text
        dataListSQL.UpdateParameters("EmailAddress").DefaultValue = Email.Text
        dataListSQL.UpdateParameters("SupplierFax").DefaultValue = Fax.Text


        '''''not firing'''''
        dataListSQL.Update()
        ''''''''''''''''''''


        dataList1.EditItemIndex = -1
        dataList1.DataBind()


    End Sub

What I'm receiving when I "Add Watch" on Update is what the title of this thread is

Re: Update is a type and cannot be used as an expression

I tried to add a screenshot but it didnt work.

Re: Update is a type and cannot be used as an expression

Can you please post the source in the page behid that defines the 'dataListSQL' control? It should be the code that begins with:

<asp:SqlDataSource
          id="dataListSQL"

Re: Update is a type and cannot be used as an expression

<asp:SqlDataSource ID="dataListSQL" runat="server"
                ConnectionString="<%$ ConnectionStrings:NCMRConnectionString3 %>"
                SelectCommand="SELECT SupplierContactNum, SupplierContact, Title, CellPhone, SupplierPhone, Address, Ext, EmailAddress,
                SupplierFax FROM [Supplier List] WHERE (Supplier = @SupplierDDL)"
                

                UpdateCommand="UPDATE [Supplier List] SET SupplierContact=@SupplierContact, Title=@Title, SupplierPhone=@SupplierPhone, CellPhone=@CellPhone,
                Address=@Address, Ext=@Ext, EmailAddress=@EmailAddress, SupplierFax=@SupplierFax WHERE SupplierContactNum=@SupplierContactNum"
                

                >
                                <UpdateParameters>
                <asp:Parameter Name="Title" Type="String" />
                <asp:Parameter Name="SupplierPhone" Type="String" />
                <asp:Parameter Name="CellPhone" Type="String" />
                <asp:Parameter Name="Address" Type="String" />
                <asp:Parameter Name="Ext" Type="String" />
                <asp:Parameter Name="EmailAddress" Type="String" />
                <asp:Parameter Name="SupplierFax" Type="String" />
                <asp:Parameter Name="SupplierContact" Type="String" />
                <asp:Parameter Name="SupplierContactNum" Type="Int32" />
                </UpdateParameters>
                <SelectParameters>
                    <asp:ControlParameter ControlID="DropDownList1" Name="SupplierDDL"
                        PropertyName="SelectedValue" />
                </SelectParameters>
            </asp:SqlDataSource>

Re: Update is a type and cannot be used as an expression

MCas86
I'm not getting a true error where it pops up and tells me... i added a watch and its just not firing i dont think. The error i listed is what my watch said.

So at this point you are receiving no error at all, and the code is executing completely but your Update is not being reflected in SQL Server correct? Have you checked SQL Server directly to see if the record actually was updated?

Re: Update is a type and cannot be used as an expression

Correct. And yes I have.

Re: Update is a type and cannot be used as an expression

MCas86
And yes I have.

I am sorry. I see you checked it, but you did not state if it actually was updated. I am assuming it was not Updated and you were able to verify this?

If the Update is not working, can you run the SQL manually using the parameters extracted by debugging the code and inserting them manually into the UPDATE statement, but run directly from SQL Server? At this point if you are not receiving a .NET exception, we need to see if the actual SQL has an issue. If you are fimilar with setting up a trace in SQL Server, you can also sniff out what SQL is actually being sent to the databse to see if it is 1. actually being sent, and 2. in the proper format.