Here is a tought one, I hope someone can help me. I know VS is able to create inserts, update,..., for a single table but how can I create those for multiple tables when I normalized my model. I cannot believe I'm forced to do it all by myself?

Here is hat I have:

tbl_Collection
- ID (PK)
- description
- ... 

tbl_Base
- ID (PK)
- CollectionID (FK)
- ownerID
- ....

tbl_BaseDetail
- ID (PK)
- BaseID (FK)
- value
- ...

There is a 1:n relationship between Collection : Basis and a 1:n relation between Base : BaseDetail

I have a CSV file that holds multiple number series which I like to store into my DB. every CSV file is treated like a collection, every single line is put into base and basedetail.

So what I like to do is to read the file line by line and run an insert. As of now I couldn't figure out how to make VS help me with the creation of the statement. I know I have to get the identity back per higher level to insert below e.g. Collection, Base, BaseDetail. Therefore a single insert is a bit more complicated. Also ideally I would like stored procedure calls.

Please I don't want to use DTS or the newer stuff as I like to implement a class that also allows me to update and delete the data.

Can somebody please explain to me how VS would provide what I need or in case VS won't do it explain to me how I have to do it.

Thanks in advance.

Dirk

I'd suggest creating an ObjectDataSource.  Inside the insert method you can do whatever you want.  I just recently completed an ODS that is used for membership that automatically updates both the Membership tables as well as a second table foreign key'd into membership.  I think that is similar.

does ODS create the staged insert for me or do I have to iterate through? would you mind to share more detail as to how to go about this task, that would be great!

dirk

ODS lets you build your own method that does the staged insert.  I'll post here some pseudo code of what it might look like:

 public void InsertAlldbo_CustomerInfo(Guid userkey, string firstname, string lastname, string billingaddress, string city, string state, , string gender, DateTime birthdate, Double height, int planname_id)
        {
            SqlConnection connection = new SqlConnection(connectionString);
            String insertString = "INSERT INTO dbo.CustomerInfo (";
            insertString += "UserKey";
            insertString += ",FirstName";
            insertString += ",LastName";
                   insertString += ",BirthDate";
            insertString += ",Height";
            insertString += ",PlanName_id";
            insertString += ") VALUES (";
            insertString += "@userkey";
            insertString += ",@firstname";
            insertString += ",@lastname";
             insertString += ",@height";
            insertString += ",@planname_id";
            insertString += "); ";
            SqlCommand cmd = new SqlCommand(insertString, connection);
            cmd.Parameters.Add("@userkey", SqlDbType.UniqueIdentifier, 16).Value = userkey;
            cmd.Parameters.Add("@firstname", SqlDbType.VarChar, 50).Value = firstname == null ? String.Empty : firstname;
            cmd.Parameters.Add("@lastname", SqlDbType.VarChar, 50).Value = lastname == null ? String.Empty : lastname;
                  cmd.Parameters.Add("@height", SqlDbType.Float, 17).Value = height;
            cmd.Parameters.Add("@planname_id", SqlDbType.Int, 0).Value = planname_id;
            try
            {
                connection.Open();
                cmd.ExecuteNonQuery();
            }
            catch (SqlException err)
            {
                throw new ApplicationException("TestODS Insert Error." + err.ToString());
            }
            finally
            {
                connection.Close();
             }

        AND DO SOME MORE INESRT STUFF INTO ANOTHE RTABLE..

        }

I refered to the above code and my requirement is

I have 3 checkboxes  in aspx page,  I m using check boxes with  labels for displaing checkboxes values and if user select one check out of 3 then selected check box value from corresponding  label value  to be store in the database

how can I modify this code for I have checkboxes

String insertString = "INSERT INTO dbo.CustomerInfo (";
            insertString += "UserKey";
            insertString += ",FirstName";
            insertString += ",LastName";
                   insertString += ",BirthDate";
            insertString += ",Height";
            insertString += ",PlanName_id";
            insertString += ") VALUES (";
            insertString += "@userkey";
            insertString += ",@firstname";
            insertString += ",@lastname";
             insertString += ",@height";
            insertString += ",@planname_id";
            insertString += "); ";

Need help

thanks

[email protected]