C# Discussion Boards - CodeProject

DaveyM693-Mar-08 1:30

3-Mar-08 1:30

I'm trying to get the namespace that a class resides in within a static method of that class.

this.GetType().Namespace; works if the method is not static but obviously this is not valid in a static method.

Edit:
I've found that this way works but I'm sure there's a better way!

private class dummy
{ }

static string GetNamespace()
{
    dummy temp = new dummy();
    return temp.GetType().Namespace;
}

Dave

modified on Monday, March 3, 2008 7:52 AM

Re: Get Namespace Name

TJoe3-Mar-08 2:07

TJoe

3-Mar-08 2:07

You can simply use typeof(MyClass).Namespace.

Take care,
Tom

-----------------------------------------------
Check out my blog at http://tjoe.wordpress.com

Re: Get Namespace Name

DaveyM693-Mar-08 2:35

DaveyM69

3-Mar-08 2:35

Thanks Tom, it works and will solve my problem but I was looking for a more general way if there is one.

The static method must already be in a class, so surely it should know what MyClass is without me having to specify it?

Dave

Re: Get Namespace Name - Solved

DaveyM693-Mar-08 3:09

DaveyM69

3-Mar-08 3:09

This works!
System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.Namespace;

Dave

Re: Get Namespace Name

Pete O'Hanlon3-Mar-08 3:09

Pete O'Hanlon

3-Mar-08 3:09

You could always do this with the StackFrame. Here's a quick sample:

using System;
using System.Collections.Generic;
using System.Text;
using System.Diagnostics;

namespace TestApp
{
  class Program
  {
    static void Main(string[] args)
    {
      StackFrame sf = new StackFrame();

      Console.WriteLine(sf.GetMethod().DeclaringType.Namespace);
    }
  }
}

GetMethod has a property called DeclaringType which returns the type of the class the method is implemented in, and from there it's trivial to find the namespace.

Deja View - the feeling that you've seen this post before.

My blog | My articles

Re: Get Namespace Name

DaveyM693-Mar-08 3:21

DaveyM69

3-Mar-08 3:21

Cheers Pete, I actually found and posted the solution at the same time as you!

I used System.Reflection.MethodBase.GetCurrentMethod() instead of StackFrame.GetMethd()

Are there any advantages of either one?

Dave

Re: Get Namespace Name

Pete O'Hanlon3-Mar-08 3:25

Pete O'Hanlon

3-Mar-08 3:25

DaveyM69 wrote:
Cheers Pete, I actually found and posted the solution at the same time as you!

I used System.Reflection.MethodBase.GetCurrentMethod() instead of StackFrame.GetMethd()

Are there any advantages of either one?

Well, the StackFrame always implicitly returns MethodBase information, plus it returns line and file information if it's a debug build (obviously no line/file info should be returned for a release build). So, no real benefit of either one.

Deja View - the feeling that you've seen this post before.

My blog | My articles

How do I display contents of a spreasheet in a listView or datagrid

Walaza3-Mar-08 1:18

Walaza

3-Mar-08 1:18

Hi,
I need to display the contents of a spreadsheet document in a listView or dataGrid. The code that I have opens the document, but only prints the first column's data. I need it to print all the data. I also need to add a new column in the spreadsheet as it loads. Please help!

Regards,

Mvelo Walaza
Developer
Telkom SA

Re: How do I display contents of a spreasheet in a listView or datagrid

Ashish Derhgawen3-Mar-08 4:57

Ashish Derhgawen

3-Mar-08 4:57

Check this - http://www.c-sharpcorner.com/UploadFile/mgold/HowtoOepnandReadanExcelSpreadsheetinaListViewin.NET11282005034134AM/HowtoOepnandReadanExcelSpreadsheetinaListViewin.NET.aspx[^]

Ashish

Time flies like an arrow;
Fruit flies like a banana.

Ashish Derhgawen - http://ashishrd.blogspot.com[^]

Re: How do I display contents of a spreasheet in a listView or datagrid

Walaza3-Mar-08 6:10

Walaza

3-Mar-08 6:10

Hi,
thanks for the reply, but I saw this article and the listView does not display the contents of my spreadsheet properly. It only displays the first column.

Mvelo Walaza
Developer
Telkom SA

Using a Stored Procedure in C#

Vimalsoft(Pty) Ltd3-Mar-08 1:03

Vimalsoft(Pty) Ltd

3-Mar-08 1:03

Good Afternoon All

An new in C#, i have been doing Ado.net in vb.net. i want to use a Stored Procedure to do my database work, and i want to tell my command object that we are going to use a StoredProcedure. if i try this

<br />
<br />
 cmdselect.CommandType = CommandType = StoredProcedure;<br />
<br />

I get an Exception that says

The Name StoredProcedure does not Exists in the current context

i have googled and my line looked ok, but i dont know what is wrong with this line

Thanks

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

Re: Using a Stored Procedure in C#

Obaid ur Rehman3-Mar-08 1:11

Obaid ur Rehman

3-Mar-08 1:11

When the CommandType property is set to StoredProcedure, the CommandText property should be set to the name of the stored procedure.
http://msdn2.microsoft.com/en-us/library/x8ybe6s2(VS.80).aspx[^]

Re: Using a Stored Procedure in C#

Vimalsoft(Pty) Ltd3-Mar-08 1:19

Vimalsoft(Pty) Ltd

3-Mar-08 1:19

hi Thanks for your Reply

like this

<br />
         cmdselect.CommandText = "get_me";<br />
 <br />
         cmdselect.CommandType = CommandType = StoredProcedure;<br />

"get_me" is the name of the Procedure.
and this is how i wrote my code, what is Wrong ?

Thanks

Re: Using a Stored Procedure in C#

Colin Angus Mackay3-Mar-08 3:06

Colin Angus Mackay

3-Mar-08 3:06

Vuyiswa wrote:
and this is how i wrote my code, what is Wrong ?

Since this code would generate a compiler error, surely the error message would be able to pinpoint where the error is.

Try:
cmdselect.CommandType = CommandType.StoredProcedure;

Note the dot instead of the second equals sign.

Upcoming FREE developer events:
* Developer Day Scotland

Recent blog posts:
* Mixins in C#3.0

My website | Blog

Re: Using a Stored Procedure in C#

Vimalsoft(Pty) Ltd3-Mar-08 19:14

Vimalsoft(Pty) Ltd

3-Mar-08 19:14

Thanks it worked

Re: Using a Stored Procedure in C#

mav.northwind3-Mar-08 1:12

mav.northwind

3-Mar-08 1:12

Hi!
The first place to look for parameters should be the documentation - MSDN still is the authority to ask.
Try explaining what your cmdselect.CommandType... line does (not what you want it to do, but what the meaning of the statements you've written is!).
You'll see that the two assignments you're performing are nonsense.
StoredProcedure is an enum value and you have to tell which enum it's a part of.
Btw., you don't get an Exception but a syntax error during compilation - that's a huge difference!

Regards,
mav

--
Black holes are the places where God divided by 0...

Re: Using a Stored Procedure in C#

Vimalsoft(Pty) Ltd3-Mar-08 1:54

Vimalsoft(Pty) Ltd

3-Mar-08 1:54

Thanks man i saw the Problem

Thanks

Re: Using a Stored Procedure in C#

Walaza3-Mar-08 1:23

Walaza

3-Mar-08 1:23

//Try the ff:
cmdselect.CommandType = System.Data.CommandType.StoredProcedure;
cmdselect.CommandText = "Name_Of_StoredProcedure";

Mvelo Walaza
Developer
Telkom SA

Re: Using a Stored Procedure in C#

Vimalsoft(Pty) Ltd3-Mar-08 1:56

Vimalsoft(Pty) Ltd

3-Mar-08 1:56

Thanks man it Worked

Thanks

Re: Using a Stored Procedure in C#

Walaza3-Mar-08 1:59

Walaza

3-Mar-08 1:59

Glad to know Wink | ;)

Mvelo Walaza
Developer
Telkom SA

Re: Using a Stored Procedure in C#

Vimalsoft(Pty) Ltd3-Mar-08 19:15

Vimalsoft(Pty) Ltd

3-Mar-08 19:15

Thanks Bro

Re: Using a Stored Procedure in C#

baala.m3-Mar-08 2:28

baala.m

3-Mar-08 2:28

this is my suggestion check it out. the line should be
cmd.CommandType = CommandType.StoredProcedure;

Re: Using a Stored Procedure in C#

Vimalsoft(Pty) Ltd3-Mar-08 19:18

Vimalsoft(Pty) Ltd

3-Mar-08 19:18

Thanks i get your point

transaction

SVb.net3-Mar-08 0:54

SVb.net

3-Mar-08 0:54

i'm using C#2005
i need to doing my two sqldatadpaters or more then in one transaction , and when happend error rollback all operation .

123

Re: transaction

Xmen Real 3-Mar-08 4:36

Xmen Real

3-Mar-08 4:36

use

Try...Catch..Finally

google it for more info

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87??6?N8?BcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-i?TV.C\y<p?jxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can

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