Excel Addin MiniDump - C# Discussion Boards

Wannes Geysen26-Apr-10 1:08

26-Apr-10 1:08

Since nobody seems to understand my question, i will specify it.

Does anyone here has any experience with Bluetooth and mobile phones?
I would like some advice about the libraries I could use or maybe that I should write the entire communication myself.

let me know

Using Gzip in HttpRequests

rahul.kulshreshtha23-Apr-10 3:41

rahul.kulshreshtha

23-Apr-10 3:41

Hello I am making http calls from my C# desktop application.
I want to use Gzip compression while posting data and also deserialize the server response that is in GZip compression. Any help for that.

Re: Using Gzip in HttpRequests

Abhinav S23-Apr-10 5:16

Abhinav S

23-Apr-10 5:16

Try using the GZipStream class.

Re: Using Gzip in HttpRequests

Migounette23-Apr-10 6:51

Migounette

23-Apr-10 6:51

Do not forget to modify the content type of the http header in order to correctly handle it on the server side or client side.

Getting UNMANAGED stack trace in C#

Fayu23-Apr-10 3:39

Fayu

23-Apr-10 3:39

Is it possible to get UNMANAGED stack trace in c#. Here is what I am trying to do:

I have a COM written in c#. I have VB6/C++ code calling this COM component. In the COM component, I want to be able to find out who called the COM function(s).

I have tried using the System.Diagnostics.StackTrace class, but that seems to only return MANAGED stack traces.

For Example:

COM Interface/Implementation
<pre>
[Guid(###)]
[InterfaceType(ComInterfaceType.InterfaceIsIDispatch)]
public interface ISkel
{
[DispId(1)]
void DoSomething(int id);
}

[Guid(###)]
[ClassInterface(ClassInterfaceType.None)]
public class Skel : ISkel
{
public void DoSomething(int id)
{
...
}
}
</pre>

VB (VBProject Name = VBProject1)
<pre>

Private Sub Command1_Click()
dim s as new Skel
s.DoSomething(1)
End Sub
</pre>

From the C# code, I want to get a value indication that the calling project (VBProject1) and the method (Command1_Click())

Any ideas/suggestions?

Thanks in advance.

Re: Getting UNMANAGED stack trace in C#

Dave Kreskowiak23-Apr-10 4:00

Dave Kreskowiak

23-Apr-10 4:00

AFAICT, the StackTrace will only work with managed calls. I can't find any method of getting the unmanaged stack trace from managed code.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Re: Getting UNMANAGED stack trace in C#

Abhinav S23-Apr-10 5:58

Abhinav S

23-Apr-10 5:58

You cannot view unmanaged code in the stack trace - you could use the disassembly window, however.

Excel Addin MiniDump

GoodIntentions23-Apr-10 3:37

GoodIntentions

23-Apr-10 3:37

I have created a dump of an excel addin and I'm having trouble loading it. When simply opening it with Visual Studio 2008 it gets to run after it loads the symbols but the "go to source code" button is grayed out.

Second time I run it it throws the no source code error however I have specified the source code directory.

I'm afraid that being an Excel addon I also need to have the excel sources?

Programming in Excel with C#

cdpace23-Apr-10 2:02

cdpace

23-Apr-10 2:02

Hi,

I was wondering is there some kind of addon for Visual Studio that lets you develop excel sheets or addons with C#.

Anyone have any links?

Thank you in advance

Regards,
Christian Pace

Re: Programming in Excel with C#

Mirko198023-Apr-10 2:20

Mirko1980

23-Apr-10 2:20

Here you are: Microsoft Office Excel Programming Using VSTO

Re: Programming in Excel with C#

cdpace23-Apr-10 2:59

cdpace

23-Apr-10 2:59

Thank you

i have problem to create excel Add-in please help me ....

dhiraj.upadhyay23-Apr-10 1:54

dhiraj.upadhyay

23-Apr-10 1:54

Sir I am Creatign Excel Addin for sms But i cont succsess please helop me...
like smscontry.com

Re: i have problem to create excel Add-in please help me ....

Dave Kreskowiak23-Apr-10 3:36

Dave Kreskowiak

23-Apr-10 3:36

Noone is going to be able to help you becuase you haven't asked a question nor specified anything about the add-in you're writing, the problem you're having, the code you've written, ..., no nothing. So, how is annyone supposed to help you solve your problem?

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

ADO.NET cross-base transactions

Yoyosch23-Apr-10 1:41

Yoyosch

23-Apr-10 1:41

I made a simple transaction using ADO.NET:

SqlTransaction tn;<br />
SqlConnection cn = new SqlConnection(/*connection string to 'Database1'*/);<br />
<br />
            try<br />
            {<br />
                if (cn.State != ConnectionState.Open)<br />
                {<br />
                    cn.Open();<br />
                }<br />
            }<br />
            catch (SqlException ex)<br />
            {<br />
                Debug.Assert(false, ex.ToString());<br />
            }<br />
<br />
            tn = cn.BeginTransaction();<br />
            SqlCommand cmd2 = ...

This works nicely. However I would like to make some update statement in other database - 'Database2'. Is it possible to do that inside one ADO.NET transaction? If so, how?

Thank you for help in advance.

Re: ADO.NET cross-base transactions

#realJSOP23-Apr-10 1:48

#realJSOP

23-Apr-10 1:48

Delete your prior message before someone responds to it.

.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

Re: ADO.NET cross-base transactions

Yoyosch23-Apr-10 3:00

Yoyosch

23-Apr-10 3:00

dont make rubish on the forum

Re: ADO.NET cross-base transactions

#realJSOP23-Apr-10 6:59

#realJSOP

23-Apr-10 6:59

Yoyosch wrote:
dont make rubish on the forum

Look, retard... You posted the same message twice. I wanted you to delete your first message before someone replied to it because once it's replied to, it can't be deleted. Now, someone's replied to it and it has become the "rubbish" that you are so clearly averse to.

Re: ADO.NET cross-base transactions

Mirko198023-Apr-10 2:42

Mirko1980

23-Apr-10 2:42

You can include your two queries into a TransactionScope.
The framework will automatically create a distribute transaction between the two databases.

Keep in mind that your infrastructure must be configured to allow so (see Configuring MS DTC).

Re: ADO.NET cross-base transactions

Yoyosch23-Apr-10 3:02

Yoyosch

23-Apr-10 3:02

Thank you very much for help

Re: ADO.NET cross-base transactions

PIEBALDconsult23-Apr-10 4:36

PIEBALDconsult

23-Apr-10 4:36

I never knew that. I have a few places where that may be beneficial.

CLR stored procedure cross base access

Yoyosch23-Apr-10 1:33

Yoyosch

23-Apr-10 1:33

I implementd CLR stored procedure on 'Database1'. I would like to perform some UPDATE statements inside this CLR stored procedure in 'Database2'. Is is possible? If so, then how?

Re: CLR stored procedure cross base access

Dave Kreskowiak23-Apr-10 3:48

Dave Kreskowiak

23-Apr-10 3:48

Ask this in the General Database forum.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Need help with emailing a web page.

Boipelo23-Apr-10 1:20

Boipelo

23-Apr-10 1:20

How can I email a web page. My html attachments come as attachment (hope I make sense!).
In one article they use ScreenScrapeHtml but I can get it, I have imported Sytem.Net and IO as suggested but still cant get ScreenScrapeHtml.

I am using .net 2.0 vs 2005.

Thanking you in advance.

I remain joe!
"Only the best"

Re: Need help with emailing a web page.

#realJSOP23-Apr-10 1:47

#realJSOP

23-Apr-10 1:47

When you do a request for a web page (in your c# code), the response is a string of HTML. Simply set the email type to HTML, and use the response text as the body of the email.

Re: Need help with emailing a web page.

Boipelo30-Apr-10 2:55

Boipelo

30-Apr-10 2:55

Thanks, it's working.

This Tutorial[^] helps a lot.

Thanks once more for your response.

I remain joe!
"Only the best"

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