ASP.NET

21-Sep-10 13:30

Hi All,

I have a C# application, which inserts or updates values in to some tables in the SQL Server Database. As it does line by line, whenever any insert or update fails, we need to rollback all inserted values. Not only from the same table but from all the tables in which the rows are inserted.
Is there any mechanism to implement it from C# code. Even if it SQL Command I dont have any issues but, I should be able to call that command from C# code. Is there any way to implement all this as one transaction in C# code and roll back it. Is it possible to rollback what is inserted in C# code. Please help me out in this issue.

Any links any suggestions would be of great help. Thanks in advance.

Thanks & Regards,

Md. Abdul Aleem
NIIT technologies

Not Active21-Sep-10 15:21

Not Active

21-Sep-10 15:21

Its called a Transaction Roll eyes | :rolleyes:

http://msdn.microsoft.com/en-us/library/system.transactions.transactionscope.aspx[^]

http://msdn.microsoft.com/en-us/library/ms188929.aspx[^]

I know the language. I've read a book. - _Madmatt

indian14322-Sep-10 5:10

22-Sep-10 5:10

Hi,

What I am looking for is, is there any type of Dataset in which I can add all these tables or define schemas, then iserting first in the dataset. If there is any mimatch thorwing the error from there itself only. If every thing goes correct then writing in to the database.
Does this makes sense. If this is possible in .Net please give me your advice. I would appreciate it. Why am I doing this is, instead of writing on to the database and rolling back. Check before inserting in to the database, by filling up the already defined schemas in the dataset. Then if any mismatch occurs log the error and terminate the program or asking user to verify the source database.
Is there any any way tot do this?

Thanks & Regards,

Md. Abdul Aleem
NIIT technologies

future383921-Sep-10 15:25

future3839

21-Sep-10 15:25

Use Store procedure in Sql and do all insert and update in that side. look to this link
http://www.wewill.cn/n2020c22.aspx

indian14321-Sep-10 18:12

21-Sep-10 18:12

Hi,

I cant use transaction at database side. Passing such a huge data is a network overhead. Let us suppose I have 50 tables, I am using different TableAdapter for different table.
Even if one insertion in one table fails all the 50 tables transaction(insertions or updates) should be rolled back. Again deletion is also not possoble because its overhead on the Database Server.

Can any body help me in this regard. In the above answer, that is maintaining transaction in the application (C# code).
But I am looking for more easier option.

Thanks & Regards,

Md. Abdul Aleem
NIIT technologies

Not Active22-Sep-10 2:26

Not Active

22-Sep-10 2:26

indian143 wrote:
But I am looking for more easier option.

Define "easier"?

Did you even look at the links you were provided?

I know the language. I've read a book. - _Madmatt

indian14322-Sep-10 4:29

22-Sep-10 4:29

Yes. I did. Thanks for the help buddy. Easier in the sense some components which can take the transaction within themselves or soemthing like that. But your links are helpfull. Thanks for the help. Smile | :)

Thanks & Regards,

Md. Abdul Aleem
NIIT technologies

T M Gray22-Sep-10 4:53

T M Gray

22-Sep-10 4:53

What makes you think deletion is more overhead than rollbacks? Having the server track 50 simultaneous inserts in one transaction is almost certainly more overhead as long as you manage your connections properly and use stored procedures.

If you are inserting into 50 tables at once it really sounds like you need to change your data model. You probably need to denormalize your OLTP data a bit to optimize for inserts.

indian14322-Sep-10 6:15

22-Sep-10 6:15

Hi,

What I am asking is, is there any dataset or anything like that in which we can store the data before insert and if all goes well, then inserting data in to the Database tables.
Here the condition is, the dataset should be able to handle the datatypes, Foreign, Unique Key and Check constraints properly. Is there any way to do thsi.

Thanks & Regards,

Md. Abdul Aleem
NIIT technologies

how to save both text and image together

T M Gray22-Sep-10 9:03

T M Gray

22-Sep-10 9:03

The .Net DataSet object supports defining DataRelations that act like foreign keys. You can add UniqueConstraints and ForeginKeyConstraints. You should browse the docs for the System.Data Namespace[^].

Dhyanga21-Sep-10 10:05

Dhyanga

21-Sep-10 10:05

Can we write text and upload image in the text editor type and save that data in html format ? Any idea if we need to put text plus image together??

suchita

Abhijit Jana21-Sep-10 10:44

Abhijit Jana

21-Sep-10 10:44

Hi Suchita,

SayamiSuchi wrote:
Can we write text and upload image in the text editor type and save that data in html format ? Any idea if we need to put text plus image together??

Your problem is not clear to me. Could you please explain it in details ?

I am bit confused in this statement,

SayamiSuchi wrote:
Can we write text and upload image in the text editor type

And where do you want to save ?

Cheers !
Abhijit Jana | My Blog | @Twitter | Disclaimer

Indian CodeProject Members Meet 2010 - Nominate Now Green Alien | [Alien]

Dhyanga21-Sep-10 11:31

Dhyanga

21-Sep-10 11:31

Sorry for not stating my problem well. Actually I am wondering if we could do something like this.

Lets say I have a text editor and we can get the input data from the text editor. Now Is it possible someway that we can have text and image as a data in that text editor ? Also when we save, Can we save both text and image as a single data and save it ?

suchita

Abhijit Jana21-Sep-10 12:11

Abhijit Jana

21-Sep-10 12:11

Which texteditor are you using ? Is it AJAX Text editor ?

Cheers !
Abhijit Jana | My Blog | @Twitter | Disclaimer

Indian CodeProject Members Meet 2010 - Nominate Now Green Alien | [Alien]

Dhyanga21-Sep-10 12:24

Dhyanga

21-Sep-10 12:24

no I am just using textbox setting multiline..

suchita