473,325 Members | 2,785 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

How to access parameterized property in C#?

i posted this problem on microsoft.public.excel.programming, but there's
no one replied till now. because this issue is time critical, i put it
here to try my fortune :)

------------------------------------------------------------------------

I am just a fresh man for C# programming, but i found that C# have no
support for optional parameter or parameterized property, which are
supported in VB.NET.

everybody kowns that Office programming is based on vb style language,
so now i have to access parameterized properties such as
Excel.WorkSheet.Cells(X, Y)
i was told that Cells is a property, not a method. i wonder how to pass
parameters to a property like Cells, if there's no way, logic will be
more complicated i think.

does some people have some good suggestions about optional parameters
and parameterized properties in Office programming, would you like to
shed some light? :)

thanks for listenning
Jul 21 '05 #1
7 3637
Wayne Wood <sa*****@gmail.com> wrote in news:ec**************@TK2MSFTNGP14.phx.gbl:
does some people have some good suggestions about optional parameters
and parameterized properties in Office programming, would you like to
shed some light? :)


COM is different than how C# handles issues itslef. For COM you pass Missing to specify the
paraameter is not being used.

For indexed properties, use [ ] instead of ( )
--
Chad Z. Hower (a.k.a. Kudzu) - http://www.hower.org/Kudzu/
"Programming is an art form that fights back"

Empower ASP.NET with IntraWeb
http://www.atozed.com/IntraWeb/
Jul 21 '05 #2
i mean, you know, there are so many "parameterized properties" and
"optional arguments" in Excel Object Model or so, and i DID deal with
that well in VB.NET, because of its support for these concepts. i also
know there are really some differences between VB.NET and C#, but after
all, they are designed for the same platform, so are you telling me that
something that can be done with VB.NET can not be done with C#? that's
critical, i think i have no time to rewrite the whole code :(

by the way, did you mean COM can support parameterized properties, but
..net can not because of another different policy?

Chad Z. Hower aka Kudzu дµÀ:
COM is different than how C# handles issues itslef. For COM you pass Missing to specify the
paraameter is not being used.

For indexed properties, use [ ] instead of ( )
--
Chad Z. Hower (a.k.a. Kudzu) - http://www.hower.org/Kudzu/
"Programming is an art form that fights back"

Empower ASP.NET with IntraWeb
http://www.atozed.com/IntraWeb/

Jul 21 '05 #3
Wayne Wood <sa*****@gmail.com> wrote in
news:Oy**************@TK2MSFTNGP10.phx.gbl:
i mean, you know, there are so many "parameterized properties" and
"optional arguments" in Excel Object Model or so, and i DID deal with
that well in VB.NET, because of its support for these concepts. i
also know there are really some differences between VB.NET and C#, but
after all, they are designed for the same platform, so are you telling
me that something that can be done with VB.NET can not be done with
C#? that's critical, i think i have no time to rewrite the whole code
This is one area that VB is eaiser. VB is looser bound than C# and does many things easier when
working with COM. I nearly exclusively use C#, but when I build COM clients or COM servers
especially I use VB because its much eaiser.
by the way, did you mean COM can support parameterized properties, but
net can not because of another different policy?


Huh?
--
Chad Z. Hower (a.k.a. Kudzu) - http://www.hower.org/Kudzu/
"Programming is an art form that fights back"

Make your ASP.NET applications run faster
http://www.atozed.com/IntraWeb/
Jul 21 '05 #4
Thanks a lot, i thought they were basically same :)

Chad Z. Hower aka Kudzu дµÀ:
Wayne Wood <sa*****@gmail.com> wrote in
news:Oy**************@TK2MSFTNGP10.phx.gbl:
i mean, you know, there are so many "parameterized properties" and
"optional arguments" in Excel Object Model or so, and i DID deal with
that well in VB.NET, because of its support for these concepts. i
also know there are really some differences between VB.NET and C#, but
after all, they are designed for the same platform, so are you telling
me that something that can be done with VB.NET can not be done with
C#? that's critical, i think i have no time to rewrite the whole code

This is one area that VB is eaiser. VB is looser bound than C# and does many things easier when
working with COM. I nearly exclusively use C#, but when I build COM clients or COM servers
especially I use VB because its much eaiser.

Jul 21 '05 #5
Wayne Wood <sa*****@gmail.com> wrote in
news:Og**************@TK2MSFTNGP10.phx.gbl:
Thanks a lot, i thought they were basically same :)


Mostly they are, but there are some key differences. C# has a lot of things that VB doesnt, while
the reverse is not so true.
--
Chad Z. Hower (a.k.a. Kudzu) - http://www.hower.org/Kudzu/
"Programming is an art form that fights back"

Develop ASP.NET applications easier and in less time:
http://www.atozed.com/IntraWeb/
Jul 21 '05 #6
could you please take some for example? i'm so fresh to C# really :)

Chad Z. Hower aka Kudzu дµÀ:
Wayne Wood <sa*****@gmail.com> wrote in
news:Og**************@TK2MSFTNGP10.phx.gbl:
Thanks a lot, i thought they were basically same :)

Mostly they are, but there are some key differences. C# has a lot of things that VB doesnt, while
the reverse is not so true.
--
Chad Z. Hower (a.k.a. Kudzu) - http://www.hower.org/Kudzu/
"Programming is an art form that fights back"

Develop ASP.NET applications easier and in less time:
http://www.atozed.com/IntraWeb/

Jul 21 '05 #7
Wayne Wood <sa*****@gmail.com> wrote in
news:#y**************@TK2MSFTNGP14.phx.gbl:
could you please take some for example? i'm so fresh to C# really :)


Google will turn up huge discussions on this, in fact there was on just a few days ago.

VB: Easier COM support, both using clients and building servers,
Optional arguments

C#: Implicit overloads, operator overloads, using statement, and a few others that esape me right
now.
--
Chad Z. Hower (a.k.a. Kudzu) - http://www.hower.org/Kudzu/
"Programming is an art form that fights back"

Empower ASP.NET with IntraWeb
http://www.atozed.com/IntraWeb/
Jul 21 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Antoine Pitrou | last post by:
Hi, I've been looking at writing parameterized metaclasses and here are the two solutions I've come to: (my goal was to build a way to automatically add a hash function that would take into...
1
by: gary b | last post by:
Hello When I use a PreparedStatement (in jdbc) with the following query: SELECT store_groups_id FROM store_groups WHERE store_groups_id IS NOT NULL AND type = ? ORDER BY group_name
0
by: totierne | last post by:
comp.databases.ms-access, I want to know how to use Oracle views with session variables in Access. The parameterised views in access, are migrated to views with per session variables. The...
8
by: deko | last post by:
I'm trying to open a Recordset based on a parameterized query. I'm kind of new to parameterized queries, so I'm sure I'm missing something simple. Set qdfs = db.QueryDefs Set qdf =...
1
by: Preston | last post by:
hello all... My friend using vb.net made a DLL file which contains a Property Kkk(ByVal key As Object) in it, I use CSharp and reference this DLL file, but in csharp object browser, there is no...
0
by: Ahmet GUNES | last post by:
Hi all, Although I tried several different ways, I wasn't able to succeed databinding a parameterized property. Can anyone help? Thanks in advance, AG In a form with two text boxes on...
14
by: Wayne Wood | last post by:
i posted this problem on microsoft.public.excel.programming, but there's no one replied till now. because this issue is time critical, i put it here to try my fortune :) ...
5
by: elena | last post by:
Hi, All I need help: I have VS .NET 2003 version 1.1 (C#) and MS Access What will be the best way to create parameterized reports? Please, help I don't know where to start, any linkss to this...
1
by: Yaman Gupta | last post by:
SIR PLS KNOW TO ME WHAT IS .NET PARAMETERIZED PROPERTY AND DEFAULT PROPERTY .and GIVE ME SOME EXAMPLE s Regards Yaman Gupta
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.