[New Bie] Insert a new record to Nettiers

Hi, I am using newest nettiers 2, Visual Studio 2005, and Ms SQL server 2000.

How to insert a new record with nettiers? I tried this code but failed :

(Database for this code is taken from "NorthWind" sample database )

        Customers myCustomer = new Customers();
        myCustomer.CustomerID = "CUST";
        myCustomer.CompanyName = "CUST";
        CustomersService myServices = new CustomersService();
  
        if (myServices.Insert(myCustomer))
        {
            Label1.Text = "Success";
        }
        else
        {
            Label1.Text = "Failed";
        }
       

Label1 always display "Failed". Something wrong with my code? (I am sure  no problem with database and its connection because I able to retrieve some record from customer table). Later, I tried this code, but also failed :

        Customers myCustomer = new Customers();
        myCustomer.CustomerID = "CUST";
        myCustomer.CompanyName = "CUST";
        CustomersService myServices = new CustomersService();       

        TList<Customers> myList = myServices.GetAll();
        myList.Add(myCustomer);
        myList.AcceptChanges();

        GridView1.DataSource = myList;
        GridView1.DataBind();

 Oddly, my GridView1 showing record of "mycustomer" but not in database.

Thanks

Alan 

Ok, I tried this one too :

DataRepository.CustomersProvider.Save(myCustomer); 

 ......and the result is : TIME OUT

I immediately check my connection with this code (and it's working!) :

        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="CustomerID" DataSourceID="customerdata">
            <Columns>
                <asp:CommandField ShowEditButton="True" />
                <asp:BoundField DataField="CustomerID" HeaderText="CustomerID" ReadOnly="True" SortExpression="CustomerID" />
                <asp:BoundField DataField="Region" HeaderText="Region" SortExpression="Region" />
                <asp:BoundField DataField="PostalCode" HeaderText="PostalCode" SortExpression="PostalCode" />
                <asp:BoundField DataField="Country" HeaderText="Country" SortExpression="Country" />
            </Columns>
        </asp:GridView>
        <data:CustomersDataSource ID="customerdata" runat="server"></data:CustomersDataSource>

see http://community.codesmithtools.com/forums/thread/17818.aspx

HTH

swin

Oh my God, I add "Northwind.Web" to my web config.....and all is working. How can this happen?

    <httpModules>
      <!--
        Enable transaction-per-request pattern;  This module allows a single TransactionManager to be shared by
        all data access operations executed during a page request.  Used by the EntityDataSource control when
        the EntityDataSource.EnableTransaction property is set to True.
      -->
      <add name="EntityTransactionModule" type="Northwind.Web.Data.EntityTransactionModule, Northwind.Web"/>
    </httpModules>

You have to specify what assembly the type resides in.

swin

Still not understand, but It's working now.

 Thanks
 

"type" is quite a common attribute in .Net config files (not just NetTiers) and what it usually expects is this format...

type="namespace.mytype, assembly"

where "namespace.mytype" is the type you're referencing and "assembly" is thw actual dll the type is located in.

HTH

swin

Hi,

It's a generation time option to generate a ComponentLayer, which could be a ServiceLayer or a DomainModel layer.

http://wiki.nettiers.com/componentlayer
 

DataRepository.MyEntityProvider.Save( myEntity )

The service layer just adds extra functionality before calling the methods in the MyEntityProvider.

Check out the DataRepository class in your Data project which provides access to the Providers via static properties.

hth

swin
 

Excellent - I now have a project generated with a service layer - I'm moving now!

What is the best practice now - include the generated code into a new web project - or add a web project to the generated project?  And do I just add a reference to the services layer?

Thanks,

Steve

I have several app's (web, services, gui etc etc) which all use the same NetTiers projects, so I created separate VS solutions for each of the app's and then just added the NetTiers projects to the solution where needed. Typically you would add all 4 layers (Data, Data.SqlClient, Entities and ServiceLayer) to each solution.  Additionally you might add the NetTiers web project if you're solution is a website.

hth

swin