C# Discussion Boards - CodeProject

Anyway to check if a SqlConnection has a SqlTransaction open against it

dlarkin7710-Mar-10 4:21

10-Mar-10 4:21

Hi,

Is there any way to find out if a SqlConnection has an open SqlTransaction?

Basically I have an object with a method that accepts a SqlConnection as a parameter. This method is called from a number of different application. Sometimes the SqlConnection has a SqlTransaction and other times it doesn't.

So what I need to be able to do is something along the lines of

public bool Post(SqlConnection cn, int ID)
{
  SqlTransaction trans;

  if(cn.HasTransaction)
  {
    trans = cn.Transaction;
  }
  else
  {
    trans = cn.BeginTransaction();
  }

  // some other stuff

  return true;
}

Is there anyway to get something similar?

Thanks,

David

Re: Anyway to check if a SqlConnection has a SqlTransaction open against it

Pete O'Hanlon10-Mar-10 6:00

Pete O'Hanlon

10-Mar-10 6:00

I rather suspect that you could just check to see if the Transaction is null or not on the command.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: Anyway to check if a SqlConnection has a SqlTransaction open against it

dlarkin7710-Mar-10 6:13

dlarkin77

10-Mar-10 6:13

There is no command being passed in, just a connection.
So when I create a command object I want to do something like.

SqlTransaction trans = null;
cmd.Connection = cn;

if(cn.HasTransaction)
{
  trans = cn.Transaction;
}
else
{
  trans = cn.BeginTransaction();
}

cmd.Transaction = trans;

Re: Anyway to check if a SqlConnection has a SqlTransaction open against it

PIEBALDconsult10-Mar-10 6:07

PIEBALDconsult

10-Mar-10 6:07

Shouldn't you track that yourself?

Re: Anyway to check if a SqlConnection has a SqlTransaction open against it

dlarkin7710-Mar-10 6:15

dlarkin77

10-Mar-10 6:15

Ideally we would/should be.
But there are so many applications using this class at the moment that it's not really feasible to revisit them all right now.

asp.net c# webcam

brsecu10-Mar-10 4:02

brsecu

10-Mar-10 4:02

I'm looking to add webcam support to a web page but i really have no idea where to start. I can use any version of VS so thats not a problem. I've seen a few examples on here about how to do it but they were all over the place. Any ideas on where to start? I'm obviously not ask for code to do it but whats the easiest way to get it done would be helpful. Thank you in advance.

Re: asp.net c# webcam

Chetan Ranpariya11-Mar-10 2:08

Chetan Ranpariya

11-Mar-10 2:08

Hi...

If you have seen the Gmail webcam support from browser while chatting, the same can be implemented.

To enable webcam support Gmail asks to download an activeX at first. So you also can create and API in C# which will capture the image from the webcam and ask the user to download it when he/she wants to have webcam support.

You API will search for the webcam on various ports of the users computer and streams images from webcam to your server and also display it to the user in a window.

I hope this approach will give some idea and lead to your goal.

Thanks and regards,
Chetan Ranpariya

Thanks and Regards,
Chetan Ranpariya

Facebook offline access key

rnvrnv10-Mar-10 3:39

rnvrnv

10-Mar-10 3:39

Hi,
I am a beginner to create Facebook application. Will appreciate if someone can explain how to get and use offline access session key?
regards,
rnv

Re: Facebook offline access key

^1.21 Gigawatts10-Mar-10 3:55

^1.21 Gigawatts

10-Mar-10 3:55

Have you checked out the Facebook developers community[^]?

Smile | :)

"If you can't explain it simply, you don't understand it well enough" ~ Albert Einstein

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." ~ Paul Neal "Red" Adair

Re: Facebook offline access key

Etienne_12315-Jul-10 23:58

Etienne_123

15-Jul-10 23:58

Hi. I've recently had to do this as well. I used the following:

browserFacebook.Navigate(@"http://www.facebook.com/login.php?api_key=" + FacebookAPIKey + @"&connect_display=popup&v=1.0&
next=http://www.facebook.com/connect/login_success.html&cancel_url=http://www.facebook.com/connect/login_failure.html&
fbconnect=true&return_session=true&session_key_only=true&req_perms=read_stream,publish_stream,offline_access");

You can intercept this URL once its done loading (string s = browserFacebook.Url.ToString()) which will show you the session key thats been returned Smile | :)

Detect a line in an image then delete it

snouto10-Mar-10 2:42

snouto

10-Mar-10 2:42

hi guys ,
i have an image that after deskewing it , a black slopped line appear at the end of the image , it is always black in color .
i need to remove that line from the image how can i do that i searched the internet and i found an image processing library called aforge , but i actually don't know how to use i to detect that line and then remove it successfully.

Any help will be greatly appreciated....

Thanks in advance..

Human knowledge belongs to the world.

Re: Detect a line in an image then delete it

#realJSOP10-Mar-10 3:51

#realJSOP

10-Mar-10 3:51

Instead of trying to remove the line, I'd try to find out why it's there to begin with. There might be an issue with your code.

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

Documentation

stancrm10-Mar-10 2:38

stancrm

10-Mar-10 2:38

modified 23-Nov-14 6:36am.

Re: Documentation

Keith Barrow10-Mar-10 2:41

Keith Barrow

10-Mar-10 2:41

GhostDoc?

Dalek Dave: There are many words that some find offensive, Homosexuality, Alcoholism, Religion, Visual Basic, Manchester United, Butter.
Pete o'Hanlon: If it wasn't insulting tools, I'd say you were dumber than a bag of spanners.

Re: Documentation

Pete O'Hanlon10-Mar-10 2:44

Pete O'Hanlon

10-Mar-10 2:44

Microsoft has Sandcastle[^], or there's ghostdoc[^].

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Message Closed

10-Mar-10 2:55

stancrm

10-Mar-10 2:55

Message Closed

modified 23-Nov-14 6:36am.

Re: Documentation

Pete O'Hanlon10-Mar-10 3:03

Pete O'Hanlon

10-Mar-10 3:03

stancrm wrote:
Sancastle is only for 2.0.

No it's not. There's a common misconception that .NET 3.5 won't be able to run .NET 2 things and that's just plain wrong. .NET 3.5 is built as a set of extensions to .NET 2, so things that run on .NET 2 will run on .NET 3.5. Trust me, I document my projects with Sandcastle.

stancrm wrote:
GhostDoc is payware.

Did you even bother reading the announcement on the page I linked you to? Here's the free download[^].

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: Documentation

R. Giskard Reventlov10-Mar-10 3:16

R. Giskard Reventlov

10-Mar-10 3:16

Good call: I use both and they work fine and are free.

Tychotics

"The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!"
Larry Niven

Re: Documentation

NickPace10-Mar-10 3:50

NickPace

10-Mar-10 3:50

I recently started using Doxygen (http://www.stack.nl/~dimitri/doxygen/index.html[^]) and have been very impressed with its capabilities. Once you set up a configuration file, you can easily (and quickly) generate documentation with the click of a button. And you can't beat the price.

-NP

Never underestimate the creativity of the end-user.

ptz camera control

sindhumahe9-Mar-10 23:57

sindhumahe

9-Mar-10 23:57

i am currently working with ptz cameras. i want to send the ptz commands thorugh http. can anybody help me?
or some good reference which could help me ?
Confused | :confused:

Re: ptz camera control

CDP180210-Mar-10 1:00

CDP1802

10-Mar-10 1:00

I suppose you want to send http requests to those cams and receive whatever response the cams send back. In this case you might take a look at the System.Net.WebClient class in the MSDN. With this class you can send HttpRequests and receive the responses. Good Luck.

A while ago he asked me what he should have printed on my business cards. I said 'Wizard'.

I read books which nobody else understand. Then I do something which nobody understands. After that the computer does something which nobody understands. When asked, I say things about the results which nobody understand. But everybody expects miracles from me on a regular basis. Looks to me like the classical definition of a wizard.

[SOLVED] Catching several (hierarchically unrelated) exceptions in the same catch block

blackblizzard9-Mar-10 23:49

blackblizzard

9-Mar-10 23:49

Hi everyone.

This is a trivial question, but I can't find the answer anywhere (even though it's been asked before in these forums, but it wasn't solved in a way that satisfies me): is it possible to catch several hierarchically unrelated exceptions in the same catch block? By hierarchically unrelated I mean one isn't a subclass of the other, etc.

Basically, I'd like to do this:

try {
    // Code.
} catch (ExceptionType1, ExceptionType2) {
    // Exception handling. I want to handle both types of exceptions the same way.
}

Is it possible, or do I need to do it as follows?

try {
    // Code.
} catch (ExceptionType1) {
    handleMyException();
} catch (ExceptionType2) {
    handleMyException();
}

public void handleMyException() {
    // Exception handling. I want to handle both types of exceptions the same way.
}

I know Java allows the first format (ExceptionType1, ExceptionType2), but C# doesn't seem to like it. However, having to create a method each time this happens doesn't seem to promote code-cleanliness.

So... is it possible to do it as in Java?

Thanks!

modified on Wednesday, March 10, 2010 6:10 AM

Re: Catching several (hierarchically unrelated) exceptions in the same catch block

#realJSOP10-Mar-10 0:07

#realJSOP

10-Mar-10 0:07

You have to use the 2nd method you posted.

Re: Catching several (hierarchically unrelated) exceptions in the same catch block

blackblizzard10-Mar-10 0:10

blackblizzard

10-Mar-10 0:10

Ok, thanks.

Re: Catching several (hierarchically unrelated) exceptions in the same catch block

Keith Barrow10-Mar-10 0:09

Keith Barrow

10-Mar-10 0:09

You need to do the second. I'm actually surprised Java has the first syntax, though it does make sense if you don't access the Exception object, so I suspect the Java syntax is really [good] syntactic sugar. If you do need to access the Exception object (as in my snippet) and the first syntax is used the compiler would have hellish time as it wouldn't be able to work out the Exception object type etc...

try
{
//...
}
catch (NullReferenceException ex)
{
    Console.WriteLine(ex.Source);
}
catch (ArgumentException ex)
{
    Console.WriteLine(ex.ParamName);
}

is OK, but

try
{
//...
}
//Not sure this is legal in Java, it isn't in c#, even without the "ex"s
catch (NullReferenceException ex, ArgumentException ex)
{
   // this would fail anyway as NullReferenceException does not have a paramname property.
   Console.WriteLine(ex.ParamName);
}

Hope this helps!

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