Copy from one table to another table???

 I have read the data of a excle file and captured the data into the dataset to a datatable, now that data is to be inserted into a SQL Server table using bulk copy option. I am using -

 public bool BulkEnterData(DataTable dt, string tblName)
    {
        SqlBulkCopy bulk = new SqlBulkCopy(con);
        bulk.DestinationTableName = tblName;
        
        con.Open();
        bulk.WriteToServer(dt);
        con.Close();

        return true;
    }

ERROR Getting-
A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.) 

How to resolve the above problem or any other solution is available.

Hi

I tried to insert new values (new rows into table) to Table A according to specific Select query on table A

Table B holds many datarows. I just want to add more from Table A to it.

Both tables are with the same columns (and properties).

I tried this :

INSERT INTO B_Archive
SELECT   A.*
FROM     A
WHERE   (YEAR(t_date) = 2009)

 I got an error:

An explicit value for the identity column in table 'Tnuot_Archive' can only be specified when a column list is used and IDENTITY_INSERT is ON.

Hey,

In a Stored Procedure, I need to copy a row in a table, change some fields and then INSERT the row into the table as a new row. Something like:

Select @Field1=Field1, @Field1 = Filed2, ... @FieldN = FiledN FROM MyDB

INSERT INTO MyDB

Values (MyNew_PK_index, @Field1, @Field2, ... @FieldN )

GO

My problem is that I have 60 something columns in each row and I would like to avoid using that many variables if it's possible.

Can I read the row into an array and then manipulate the members that need to be changed (like PK for example) and then write the array to the table in some simple way? Any other or better way?

Cheers,

Mats

how to One GridView (table ) Copy to other page  Gridview (table)

For a given Domain name how can I retrieve the AD User details including a Unique identifier so that any changes to the user details including the username can be updated using the unique Identifier.

I can use System.DirectoryServices.DirectoryEntry to get the user details but not able to figure out how to work with the Unique Identifier to maintain the user details consistently.

Please provide me with some sample.

Thank you

Hello Team,

I'm working with Rich Text Box in WPF. When I'm trying to Copy a table from MS Word (which does not have borders) and Paste it on Rich text box it looses it's formatting. Instead of table two lines are comming.

Steps to Produce :

1. Open a Ms Word Document and Insert a table(Say 4x4).

2. Apply Design for that table-any  Light Shading - Accent 5 or Accent 4...

3. Copy the table and Paste it on RichTextBox.

Observe the result. It's giving two lines instead of Table which I've copied

This is Urgent requirement for me. Please, Give a solution for this problem

How do I move the data from one column to another column within the same table?

I have work phone numbers that should be in the contact phone number column.

Will the following work:

     UPDATE table1

     SET contact_phone =

    (SELECT work_phone

     FROM table1

     WHERE id IN

     (SELECT id FROM table1)

     );

Dear All,

I am stuck with an issue. I have around 200 rows in a table with a particular database. I want to copy those values to another table in a different database.

Pls support

Hi All,

Need help.

I've deleted some of the products from the product table. from 32Million to 22 million products. and in that 22 million, I've added 1.2 Million products. Now, I want that 32 million table bacik.

I've that table on another server. and i copied that table to the server I want. but i can copy only data. i can't copy with all indexes, statistics, constraints etc.

Now, I need to get 32 million records into product table.

Any suggestions.. never done it before.and spent enough time. but getting screwed every time. Thanks in advance.

Hi,

ServerName.Database.dbo.Table

In above convention can we use IP address instead of ServerName?