C# Discussion Boards - CodeProject

11-Nov-07 19:54

hi,
Is it posible to use two diferent connection string in a SqlTransaction object??

Be very grateful for any advice.

They laugh at me; they think I’m different. I laugh at them, ‘coz they are all same!!
CrazySanker

Adeel Chaudhry11-Nov-07 20:07

11-Nov-07 20:07

Hi,

I dont think it is possible to use two connection strings(CSs) at the same time!! But you should be able to use two different CSs 1 after the other. Like use CS-1 perform something in transaction close CS-1, then open CS-2 and use it with the same transaction object! That may be possible.

Regards,

Adeel

Vipin.d11-Nov-07 20:17

11-Nov-07 20:17

Thank you very much for your reply.. Smile | :)

 <br />
using (SqlConnection connection = DbConnection("SerConstr"))<br />
                     {<br />
                         using (SqlCommand command =<br />
                                 connection.CreateCommand())<br />
                         {<br />
                             SqlTransaction transaction = null;<br />
<br />
                             try<br />
                             {<br />
                                  connection.Open();<br />
<br />
                                 transaction = connection.BeginTransaction();<br />
<br />
<br />
<br />
<br />
                                 command.Transaction = transaction;<br />
<br />
<br />
<br />
            // i need to perform this in con1                                <br />
  command.CommandText = "Insert ...";<br />
                                 command.ExecuteNonQuery();<br />
<br />
               // Execute i need to perform this in con2<br />
                                 command.CommandText = "Update...";<br />
                                 command.ExecuteNonQuery();<br />
<br />
                                 transaction.Commit();<br />
                             }<br />
                             catch<br />
                             {<br />
                                 transaction.Rollback();<br />
                                 throw;<br />
                             }<br />
                             finally<br />
                             {<br />
                                 connection.Close();<br />
                             }<br />
<br />

how I ll do this??

They laugh at me; they think I’m different. I laugh at them, ‘coz they are all same!!
CrazySanker

Andrei Ungureanu11-Nov-07 20:19

Andrei Ungureanu

11-Nov-07 20:19

Vipin.d wrote:
// i need to perform this in con1
command.CommandText = "Insert ...";
command.ExecuteNonQuery();

// Execute i need to perform this in con2
command.CommandText = "Update...";
command.ExecuteNonQuery();

The insert and update queries refer to the same database, within the same server?

I will use Google before asking dumb questions

Vipin.d11-Nov-07 20:25

11-Nov-07 20:25

yes i know that ,
my requirement is I need to change the connection string before doing UPDATE process.is it have any solution??

They laugh at me; they think I’m different. I laugh at them, ‘coz they are all same!!
CrazySanker

Adeel Chaudhry11-Nov-07 20:25

11-Nov-07 20:25

Can you please elaborate "Insert..." & "Update..." bit more? Smile | :)

Like for what purpose you need to have two CSs? Do you want to change the database? If yes, why not do it as an intermediate SQL statement between insert & update?

Vipin.d11-Nov-07 20:26

11-Nov-07 20:26

Dear friend,
my rquiremnt is like

1. SELECT some data from servr1.db1.Tbl1
2. INSERT that to server2.db2.Tbl1.
3. UPDATE the status filed of selected data in servr1.db1.Tbl1

If either step 2 or 3 fail I need to Roll back that transaction.
any advice please..

Let me check intermediate SQL statement in my Google Uncle Smile | :)

They laugh at me; they think I’m different. I laugh at them, ‘coz they are all same!!
CrazySanker

Adeel Chaudhry11-Nov-07 20:38

11-Nov-07 20:38

First, allow me to clear this, I used "intermediate" as an english word, not as technical word. Smile | :)

Theoretically, it should be like that

connect with server1
select
if it was a success
connect with server2
insert
if it was a success
disconnect with server2
update
if not success rollback
disconnect with server1

Surely, you will need to have 2 connection objects, given this is not a live server with few hundereds transactions goin on.

Hope that helps!

Adeel

Vipin.d11-Nov-07 20:42

11-Nov-07 20:42

ohh!!I already started searching the term intermediate sql Cool | :cool:

thank you for your reply.. Big Grin | :-D

They laugh at me; they think I’m different. I laugh at them, ‘coz they are all same!!
CrazySanker

Andrei Ungureanu11-Nov-07 20:14

Andrei Ungureanu

11-Nov-07 20:14

Why do you need 2 connection strings? What is the purpose..changing the database while the transaction is open?

I will use Google before asking dumb questions

Vipin.d11-Nov-07 20:23

11-Nov-07 20:23

Dear friend,
my rquiremnt is like

1. SELECT some data from servr1.db1.Tbl1
2. INSERT that to server2.db2.Tbl1.
3. UPDATE the status filed of selected data in servr1.db1.Tbl1

If either step 2 or 3 fail I need to Roll back that transaction.
any advice please..

They laugh at me; they think I’m different. I laugh at them, ‘coz they are all same!!
CrazySanker

Andrei Ungureanu11-Nov-07 20:43

Andrei Ungureanu

11-Nov-07 20:43

The ConnectionString property can be set only when the connection is closed. (from MSDN) and when you close a query, the pending transactions are rolledback.
So...my suggestion is to use at least 2 connections

using (SqlConnection conn = new SqlConnection())
{
 //set the first cs
 string cs1 = "connection string 1";
 conn.ConnectionString = cs1;

 conn.Open();

 SqlTransaction trans = conn.BeginTransaction();

 //do the the select query

 if (InsertSecondDB())
 {
  //update first DB
  trans.Commit();
 }
 else
 {
  trans.Rollback();
 }

 conn.Close();
}

The InsertSecondDB should create a new connection and a new transaction to the second DataBase and return true if the query succeeded or false otherwise.

Hope it helps.

I will use Google before asking dumb questions

Vipin.d11-Nov-07 20:46

11-Nov-07 20:46

defenitely it clicked some ideas in my mind..
Thank you soo much!!

They laugh at me; they think I’m different. I laugh at them, ‘coz they are all same!!
CrazySanker

Vipin.d11-Nov-07 20:55

file synchronisation in c#

11-Nov-07 20:55

Dear friends,
During my g0ole search i got this

Distributed Transaction ^]

They laugh at me; they think I’m different. I laugh at them, ‘coz they are all same!!
CrazySanker

suny12311-Nov-07 19:21

suny123

11-Nov-07 19:21

how to synchronize file on two pc

Re: file synchronisation in c#

Adeel Chaudhry11-Nov-07 20:01

Re: Please can any one help me in customizing the open file dialog selection

11-Nov-07 20:01

Hi,

There can be several ways, following are some possibilities:

1. Web-service
2. Application loaded in a hidden mode at the system start-up

In the 2nd option there can further be some possibilities as

2.a Client-Server sort of application for 2 PCs
2.b Instances of a same application on both PCs
2.c Event-Trigger sort of application, i.e. generating event and start sending changed/modified file from 1 PC to other

Hope that helps.

Regards,

Adeel

Adeel Chaudhry11-Nov-07 19:02

Re: Please can any one help me in customizing the open file dialog selection

11-Nov-07 19:02

Hi,

Try looking at some flags of the open dialog.

Regards,

Adeel

Please can any one help me in customizing the open11-Nov-07 21:11

Please can any one help me in customizing the open

11-Nov-07 21:11

is that no so...
i had seen the flags...
it should be custom control

chandru

How to find the encoding of a file?

deep_C#11-Nov-07 18:47

deep_C#

11-Nov-07 18:47

Hello,

I need to find out programatically the encoding format of a text file.
Do text files, have a header which contains the encoding format.
If it does then how do I view it/access it ?

The encoding I am referring to is - ANSI, Unicode, UTF8, UTF4, etc.

Any help is appreciated.

Thanks,
\deepu

Re: How to find the encoding of a file?

Adeel Chaudhry11-Nov-07 19:05