SqlTransaction Rollback - C# Discussion Boards

N a v a n e e t h9-Jun-08 16:10

9-Jun-08 16:10

George_George wrote:
. I think the wait handle will be signalled immediately when there is an underlying TCP client connection even if we do not call EndfGetContext (so no relationship between calling EndGetContext and the wait handle signal be set)?

I don't think so. WaitHandle will be signaled when the asynchronous operations ends.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: HttpListener.BeginGetContext

George_George9-Jun-08 16:28

George_George

9-Jun-08 16:28

Thanks N a v a n e e t h,

Do you think asynchronous operations is the same thing as the callback method? If not, could you clarify please?

regards,
George

Re: HttpListener.BeginGetContext

N a v a n e e t h10-Jun-08 7:24

N a v a n e e t h

10-Jun-08 7:24

George_George wrote:
Do you think asynchronous operations is the same thing as the callback method?

CallBack method ? They are implemented using delegates. Asynchronous methods are different. They are used to do a job without blocking any thread hence it consumes better CPU.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: HttpListener.BeginGetContext

George_George11-Jun-08 2:30

George_George

11-Jun-08 2:30

Sorry, N a v a n e e t h!

Yes, I mean the delegate. I have re-described my question here, any ideas? Smile | :)

http://www.codeproject.com/script/Forums/View.aspx?fid=1649&msg=2589897[^]

regards,
George

specified DataTable EventHanlder

climbah4-Jun-08 23:21

climbah

4-Jun-08 23:21

Hi all,

first of all, my Englisch's not my mothertongue, please forgive me mistakes in grammar.

Ok the Problem:

I have two DataTables:
- the first one, called FULL and contains all the relevant Information.
- the second one, called EXTRACT and is - the name say it - a extract from the FULL Table.

The User can made Inserts into the Extract Table on 3 ways:
- over a RichtTextBox
- over a Textbox
- with a NumericUpDown

And now my Idea was to make an Eventhandler, to update the FULL-Table evry Time the User made an Insert into the EXTRACT-Table.
I tried the ColumnChanged and the RowChanged Eventhandler, now comes a big BUT
everytime i clear the table and evry time when i fill an new Extract into the Table, the EventHandler throw an Event.
Cause of the Fact that the EXTRACT-Tables content is changing very often, i ask you:

Is there a possiblity to react only on userentrys?
Maybe there is a much more easier way to handle that

Hope on your answers
Greetz
Daniel

Re: specified DataTable EventHanlder

johland5-Jun-08 1:01

johland

5-Jun-08 1:01

i'm not sure i understood so forgive me if my answer is not useful...but couldnt u just create a bool variable that according to its value the callback method will decide if to execute or not?

y

Re: specified DataTable EventHanlder

climbah5-Jun-08 2:14

climbah

5-Jun-08 2:14

The idea isn't so bad, but let me tell you, how i load my Extract table and what my program did if i do that.

I load with a SQL script the Fulltable, thats not the problem.
But when i made a extract from the full table, sometimes there are more then 1000 records and for evry record there are 8 attributes, the program load 8000 times the eventhandler. small example

1   DataRow rw = table1.NewRow();
2   rw["Attribute"] = table2.Rows["row"]["Column"];
3   rw["Attribute"] = table2.Rows["row"]["Column"];
4   rw["Attribute"] = table2.Rows["row"]["Column"];

When i proceed Line 2 - 4, the Programm jumps 3 times into the EventHandler Function, why? I dont know.

And thats why i ask if there is a specific function to filter if it was a userentry or not.

SqlTransaction Rollback

Navneet Hegde4-Jun-08 23:05

Navneet Hegde

4-Jun-08 23:05

Hi,
I am using a block of code to Import the Data to SQLServer2000

try
sqlTransaction sqlTran;
{
   using (sqlTran = MyConnnection.BeginTansaction )
      try
      { 
         ImportData();
         sqlTran.Commit();
      }
      catch(Exception ex)
      {
         sqlTran.Rollback()
      }  
}
catch
{}

Now as the Process start's If in middle of the Process I close the Window
the Process stop's, But the related tables in DB doesn't respond
Is that because rollback() is not called.If yes then Is it possible to calls Rollback in such situation.

Thanks

Navneet Hegde

Develop2Program & Program2Develop

Re: SqlTransaction Rollback

Ashfield5-Jun-08 0:32

Ashfield

5-Jun-08 0:32

Try putting the rollback and commit in a FINALLY block and set an indicator so you know which to execute. FINALLY blocks are always executed.

Bob
Ashfield Consultants Ltd

Re: SqlTransaction Rollback

Navneet Hegde5-Jun-08 0:45

Navneet Hegde

5-Jun-08 0:45

Thanks
So, if I close my Application through Task maNager, Then before ending the process FINALLY will be executed.

Develop2Program & Program2Develop

Re: SqlTransaction Rollback

leppie5-Jun-08 1:18

leppie

5-Jun-08 1:18

I doubt that!

Why on earth do you want to close the application through the Task Manager?

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Re: SqlTransaction Rollback

Navneet Hegde5-Jun-08 1:28

Navneet Hegde

5-Jun-08 1:28

anyway!!
I wanted to be sure that my DB is not hanged in case of any eventuality.So Rollback is fired atleast.

Develop2Program & Program2Develop

Re: SqlTransaction Rollback

Ashfield5-Jun-08 3:13

Ashfield

5-Jun-08 3:13

Maybe. Put something like writing a file in the finally (so you know for sure) and try it.

Bob
Ashfield Consultants Ltd

Re: SqlTransaction Rollback

PIEBALDconsult5-Jun-08 4:54

PIEBALDconsult

5-Jun-08 4:54

Ashfield wrote:
FINALLY blocks are always executed.

Not if the application is terminated outside its control, though I don't know why he's concerned about it.

Re: SqlTransaction Rollback

PIEBALDconsult5-Jun-08 4:42

PIEBALDconsult

5-Jun-08 4:42

If the application terminates unexpectedly the connection will be closed and any transaction will be rolled back.

How can i know witch language is active in the language bar ? ?

Yanshof4-Jun-08 22:11

Yanshof

4-Jun-08 22:11

Hi,

On my machine i installed two languages.
I wrote some application that using keyboard hook ( low level keyboard hook ).
In the run time i want to know witch of those languages is active.

How can i do it ?

Thanks for any help.

Re: How can i know witch language is active in the language bar ? ?

leppie4-Jun-08 22:59

leppie

4-Jun-08 22:59

Why not just look up the Threads Current Culture?

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Re: How can i know witch language is active in the language bar ? ?

Yanshof4-Jun-08 23:06

Yanshof

4-Jun-08 23:06

OK,

I dont know how to do it -

can you please explain ?

Re: How can i know witch language is active in the language bar ? ?

leppie5-Jun-08 1:19

leppie

5-Jun-08 1:19

So you wanna be spoonfed D'Oh! | :doh:

System.Threading.Thread.CurrentThread.CurrentCulture

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Problem in Calling an MS Access Stored Procedure which in turn calls a Macro Function

Rafferty Uy4-Jun-08 21:37

Rafferty Uy

4-Jun-08 21:37

Hi,

I'm currently working on a C# app using MS Access as the database. In the database, it contains a SELECT stored procedure where one of its columns is something like Sum(IIf(WorkingDays(startDate, endDate)<=3,1,0)) AS Within3BusinessDays.

The WorkingDays(...) function basically counts the number of business days from the startDate to the endDate. Business days are weekdays (excluding Saturday and Sunday) AND non-holidays (holidays are listed in a separate Holiday table).

Now, my problem is... when I call this stored procedure in C#, it is getting an OleDbException with message "Undefined function 'WorkingDays' in expression." How can I fix this problem? I thought about removing the macro and just create a stored procedure that returns the # of working days instead but I don't know if that is possible since MS Access does NOT seem to use Transact-SQL.

Thank you in advance.

Rafferty

Rafferty

Re: Problem in Calling an MS Access Stored Procedure which in turn calls a Macro Function

leppie4-Jun-08 23:00

leppie

4-Jun-08 23:00

IIRC prefix the function with the qualifier, eg "dbo."

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Re: Problem in Calling an MS Access Stored Procedure which in turn calls a Macro Function

Rafferty Uy5-Jun-08 0:31

Rafferty Uy

5-Jun-08 0:31

leppie wrote:
IIRC prefix the function with the qualifier, eg "dbo."

Sorry I did not get what you meant by that. Going back to the stored procedure, are you suggesting that I simply change the Sum(IIf(WorkingDays(... to Sum(IIf(dbo.WorkingDays(...? I tried it but it didn't work. I'm now also getting an error even when I run the stored procedure in MS Access.

Please clarify.

Thanks again.

Rafferty

Re: Problem in Calling an MS Access Stored Procedure which in turn calls a Macro Function

leppie5-Jun-08 1:57

leppie

5-Jun-08 1:57

Sorry I cant help then Frown | :(

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Re: Problem in Calling an MS Access Stored Procedure which in turn calls a Macro Function

Rafferty Uy5-Jun-08 4:05

Rafferty Uy

5-Jun-08 4:05

haha! okay, thanks for trying. Smile | :)

Rafferty

monitor for handle leak

George_George4-Jun-08 20:48

George_George

4-Jun-08 20:48

Hello everyone,

I want to monitor whether the handles of my C# application is released timely. The handles I mean various native handles wrapped by various Stream classes, like XMLReader/XMLWriter, Request.InputStream of Http request, etc.

(I do not use any native handles directly, and I only use C# wrap class like StreamReader.)

Currently, I am using Process Explorer --> Select the specific process for my C# application --> Select Properties --> Select Performance Tab --> Watch for "Handles" (including Handles, GDI Handles and USER Handles).

My questions are,

1. Is it the correct method to serve my purpose?
2. Any better tools or methods to use? Smile | :)

thanks in advance,
George

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.