Calling a Moss2007 webservice and the 401 error - C# Discussion Boards

2-Aug-07 7:27

I need to set up an array would look something like this but I'm not sure what type

basicly i have a list of occrences lets say bob rob bob joe bob joe joe rob jay jay jay rob jay jay jay rob rob joe jay jay jay

and from that I would have to "sub total" the list into something like this

name count
bob 3
rob 5
joe 4
jay 9

1) what type of array would this be
2) how would i prevent it from adding duplicate names?

led mike2-Aug-07 7:39

led mike

2-Aug-07 7:39

Any type of array would work and "you" could prevent it from adding duplicates by checking for the existence of it right? There are many different ways to do this, I would imagine you can find one of them yes? What course is this for?

crash8932-Aug-07 8:13

2-Aug-07 8:13

its not for a class its for something at work

we have a db of incidents or tickets

and each ticket has a type for example: Microsoft word or outlook or account lockout

I make reports for my boss each month on how many of each we had but I am currently using excel for this which sucks

so I'm trying to automate it ( or at least make an app he can run himself)

I currently have it so that i can download it into a datagridview and filter it using bindingsource.filter but to graph it for him i would like to get totals and i also need to consolidate the names so that i can auto populate some of the combo boxes

I just didnt know if there was a better way to "link" the cells in the array so that if I found bob I could +1 the bob total with out it getting misaligned

led mike2-Aug-07 9:12

led mike

2-Aug-07 9:12

crash893 wrote:
we have a db of incidents or tickets

SQL can do subtotals

crash893 wrote:
its for something at work

What do you do at work? Just curious.

crash8932-Aug-07 10:32

2-Aug-07 10:32

I thought about using the count feature in a query but the data is filtered at the binding source by the user and it would be "to hard" to run sql querys allot on the server that has this info. so i basically take one huge dataset add it to a binding source then filter it from there (what ever the user wants to see)

then the idea is that they hit a button and it produces an array that goes into a graphing class and out pops a beautiful bar graph.

usatoday

I'm in IT but I'm not a programmer I'm just doing this for the fun / self education.

I have so far something like (this is quasi sudo code)

foreach (DataRowView view in myBindingSource)
{
If ( array.find((string)view["cat_name"] != 1)
{
array.add((string)view["cat_name"] ,1)
// the ,1 is the total feild so im having some trouble with that
}
else "find index of catname and add +1 to the total"
}
return array

crash8934-Aug-07 6:12

Calling a Moss2007 webservice and the 401 error

4-Aug-07 6:12

anyone?

sameerhanda2-Aug-07 7:10

sameerhanda

2-Aug-07 7:10

Ok here's the deal:
I am testing / mocking up calling a Moss2007 webservice from a windows form and populating a listview with the results. Very simple( at least that's what I thought). Here is the code:

webSvcWebs.PreAuthenticate = true;
webSvcWebs.Credentials = System.Net.CredentialCache.DefaultCredentials;
//new System.Net.NetworkCredential(mysignon, mypassword, mydomain);
XmlNode sites = webSvcWebs.GetWebCollection();

here webSvcWebs = "http://rvisp02/_vti_bin/webs.asmx".

Well as you can see above I have tried both credential ways and I still get the 401 unauthorized error. Any ideas. I seeing to be running out of them.

Thanks for your help.

Sameer

Invoke C# dll from Excel

Bert delaVega2-Aug-07 7:05

Bert delaVega

2-Aug-07 7:05

I've always used com interop to talk to office apps. Now, I need an Excel app to talk the my C# app.

It's actually a really simple request. When a user clicks on a button in the Excel spreadsheet, I want my C# process to come to life and do it's thing. My C# app can be an exe or dll, it doesn't really matter much.

But I'm stumped as to the how (use VBA? com? what?) I can modify the macro for the button click event to invoke my process.

I'm not sure if this is really a com question or what, but thought I would ask it here first since I may need to make changes to my C# code.

Any help pointing me in the right direction would be greatly appreciated. Thanks!

Re: Invoke C# dll from Excel

wilcodk2-Aug-07 23:47

wilcodk

2-Aug-07 23:47

Hi there

Try this code in your button :

Private Sub CommandButton1_Click()
Dim RetVal
RetVal = Shell("CALC.EXE", 1)
End Sub

You should compile your c# program and call it as above.

Yours

Wilco

Re: Invoke C# dll from Excel

Bert delaVega3-Aug-07 2:54

Bert delaVega

3-Aug-07 2:54

That's what I needed. Thanks a lot!

c#.net windows application without framwork ?

hk779212-Aug-07 6:57

hk77921

2-Aug-07 6:57

hi Frnds
can i run c#.net windows application on client machine . where framework is not installed.

please guide me for this problem.

Thanks in advance.

Vicky

Bert delaVega2-Aug-07 7:07

Bert delaVega

2-Aug-07 7:07

No, you can't. But it's a one time download that you can auto-detect and install .net (whatever version your application uses).

hk779212-Aug-07 7:18

hk77921

2-Aug-07 7:18

can u please tell me how to create a setup. including DB coonection also?

Vicky

led mike2-Aug-07 7:23

led mike

2-Aug-07 7:23

master vicky wrote:
can u please tell me how to create a setup.

You should report to your ISP that you can't can't get to Google and Micrsoft.com

hk779212-Aug-07 8:13

hk77921

2-Aug-07 8:13

i am not able to create the setup for my c#.net aplication.
after runing the its copying the source file to the client machine

please help me

Vicky

mav.northwind3-Aug-07 2:44

mav.northwind

3-Aug-07 2:44

master vicky wrote:
after runing the its copying the source file to the client machine

Born to rune...
(old T. Pratchett quote) Smile | :)

Regards,
mav

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

Judah Gabriel Himango2-Aug-07 10:13

Judah Gabriel Himango

2-Aug-07 10:13

Vicky, go into Visual Studio->New-> Project...->Other Project Types->Setup and Deployment->Setup Project.

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Minnesota Bridge Collapses
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

Pete O'Hanlon2-Aug-07 9:41

Pete O'Hanlon

2-Aug-07 9:41

Your installer will have the .NET framework as a dependency. The .NET runtime will be installed by the installer.

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

originSH2-Aug-07 22:00

originSH

2-Aug-07 22:00

master vicky wrote:
can i run c#.net windows application on client machine . where framework is not installed.

It's like asking "How do I run a Windows Application in Dos?".

WebService [modified]

tranzformerz2-Aug-07 5:47

tranzformerz

2-Aug-07 5:47

I've recently discovered the usage of WebService. You could say I'm a newbie. So far I've been having difficulties understanding it's limitation publishing a [WebMethod]. Is there a rule of thumb to what kind of methods that should be exposed using [WebMethod]?

For example, if I have a method that sets a datasource to an "Object" such as a WebControl GridView. Is this logical? Thing is I've mainly seen examples that only return strings. I've attempted to associate objects with [WebMethod] but came across many errors. Learning is definately trial and error, but need a boost in finding the right path.

Example of simple object associated Method:
[WebMethod]
public void setVisibility()
{
GridView gridView = new GridView();
gridView.Visible = False;
}

If anyone can offer tips, I'd appreciate it.

tranzformerz2-Aug-07 6:26

tranzformerz

2-Aug-07 6:26

Ok, I was lucky enough to find a great source off the web. Now I have this understanding that WebService is more like transferring data rather than "objects". DUH!

If anyone wish to elaborate, that would be helpful as well. I now understand what is is mainly used for.

pmarfleet2-Aug-07 6:32

pmarfleet

2-Aug-07 6:32

I think you're misunderstanding the purpose of web services. Typically, web service are used in distributed applications where one part of the application needs to consume some service e.g. request data or initiate a process on another remote part of the application. Web services are part of the business layer of an application. They are not suitable for UI-related operations.

Paul

kubben2-Aug-07 6:32

kubben

2-Aug-07 6:32

I don't think you would want to try and control the visibility of a gridview in a webservice. You may want a webservice to return a dataset which is the data that the gridview is displaying.

Ben