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 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/
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/
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/
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.
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/
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/
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/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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
|
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...
|
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 =...
|
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...
|
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...
|
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 :)
...
|
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...
|
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
|
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...
|
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...
|
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...
|
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)...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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
|
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...
| |