FTP or Database Connectivity using c# - C# Discussion Boards

Navigatecomplete2Event is not getting fired

31-Mar-09 19:13

With code.

I would suggest based on your overall approach that it's probably beyond you, try learning some basics, and getting sufficiently aquainted with the web to know how to best ask questions, first.

Christian Graus

Driven to the arms of OSX by Vista.

"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )

svt gdwl31-Mar-09 18:45

svt gdwl

31-Mar-09 18:45

Hi, I want to replace the PDF files opened on browser with corresponding PDF files which are on my desktop. I had got all these with the help of BHO in c#, but a small problem in this... i.e., I have been doing all these by firing a NavigateComplete2Event, through which I can get the URL present on browser, the problem is this Event is not getting fired at all times. What may the problem? why the event is not fired for every PDF file opened on browser? can anybody help me?

Timer

yesu prakash31-Mar-09 18:45

yesu prakash

31-Mar-09 18:45

Hi,

I need to get the time diffrence between a function called.
eg:
A function called first time, after 1000 milliseconds second time called, after 500 millisecond third time called.....and go on

How can i get the time difrence between each function called?

Thankyou
YPKI

Re: Timer

Christian Graus31-Mar-09 19:12

FTP or Database Connectivity using c#

31-Mar-09 19:12

DateTime.Now is your friend.

a.hamidy31-Mar-09 18:30

a.hamidy

31-Mar-09 18:30

Dear All,
I have a database in web server and off course i have ftp account and user name of that web server too.
i have got 1mb upload bandwith, my question is very simple.
I have application which connects to database in web server, and the same i have application which connects to FTP.
for database connectivity i am using SqlConnection and for FTP Connectiviy i am using WebClient.
which of these connectiviy is fast? FtP connectiviy or Database Connectiviy?

Re: FTP or Database Connectivity using c#

Christian Graus31-Mar-09 18:43

Re: FTP or Database Connectivity using c#

31-Mar-09 18:43

Faster for what ? The connectivity will be the same, it depends on the bandwidth available. The question is, how much data needs to move to do what you require.

a.hamidy31-Mar-09 21:29

a.hamidy

31-Mar-09 21:29

thx dude, I only mean connection speed, Database connectivity is fast or FTP connectivity.
not data exchange, no query just connection

webbrowser automation with flash content

jeanbern31-Mar-09 18:14

jeanbern

31-Mar-09 18:14

Currently I'm using the following code which works fine for regular websites, it will click at the location in the browser object and everything works perfectly
When I try to use it to click on a flash section of a site however, it doesn't work.
any tips?

[DllImport("user32.dll", CharSet = CharSet.Auto, SetLastError = false)]
static extern IntPtr SendMessage(IntPtr hWnd, uint Msg, IntPtr wParam, IntPtr lParam);

[DllImport("user32.dll", SetLastError = true)]
static extern IntPtr GetWindow(IntPtr hWnd, uint uCmd);

[DllImport("user32.dll", CharSet = CharSet.Auto)]
static extern int GetClassName(IntPtr hWnd, StringBuilder lpClassName, int nMaxCount);

 int x = 283; // X coordinate of the click
 int y = 342; // Y coordinate of the click

 IntPtr handle = two.Handle;
 StringBuilder className = new StringBuilder(100);

 while (className.ToString() != "Internet Explorer_Server")//The class control for the browser
 {
     handle = GetWindow(handle, 5); // Get a handle to the child window
     GetClassName(handle, className, className.Capacity);
 }

 IntPtr lParam = (IntPtr)((y << 16) | x); // The coordinates

 IntPtr wParam = IntPtr.Zero; // Additional parameters for the click (e.g. Ctrl)
 const uint downCode = 0x201; // Left click down code
 const uint upCode = 0x202; // Left click up code
 SendMessage(handle, downCode, wParam, lParam); // Mouse button down
 SendMessage(handle, upCode, wParam, lParam); // Mouse button up

Re: webbrowser automation with flash content

Christian Graus31-Mar-09 18:57

Re: webbrowser automation with flash content

31-Mar-09 18:57

Once you have a plug in running in IE, that's the window you need to search for, not IE itself.

jeanbern31-Mar-09 19:34

jeanbern

31-Mar-09 19:34

How would I go about doing that? once I have these things down the rest of my program is fairly straightforward but these parts I have no clue what I should be looking for

Mouse Up Event Confusion

Hax0r77831-Mar-09 16:50

Hax0r778

31-Mar-09 16:50

I thought (and confirmed? with microsoft's documentation) that a mouseup event should fire when the mouse is over a control and the button is release. However, in my application the mouseup is being fire FOR THE CONTROL THAT CAPTURED THE MOUSE DOWN (not for the control which the mouse is over when the button is released). How do i change this behavior so that the control being clicked is not decided until the mouse up? Thank you very much for your help. Confused | :confused:

Re: Mouse Up Event Confusion

Christian Graus31-Mar-09 17:14

Secured Web Servce and Business Office Programming

31-Mar-09 17:14

That would indicate that somewhere the control is capturing the mouse. If you didn't write the code, that's interesting.....

ycorre31-Mar-09 14:52

ycorre

31-Mar-09 14:52

Hello,

I am coding an AddIn for Word and Excel in VS .Net 2008 in C#.
In this AddIn I want to use a secured web service.
I suppose that I need to have login and password that I'll pass in my web method.
The URL begins with "https://..."

The principle :
- I load a Word document from an authenticated website (same site that the web services)
- I have a cookie that contains my sessionID in my browser

My question :
Where can I stock the login/password I have to use for my webmethod?
Do I read these informations from the cookie of my browser (directly from my Word AddIn?)
How else?

Thanks in advance.
Yannis.

I need help. I'm a programming noob.

VB Noobie31-Mar-09 13:09

31-Mar-09 13:09

Ok, so I'm working on a project and it has to analyze an income survey. The statistics for each home include: an ID, # of members in the house, annual income, and state of residence. As data is entered into text boxes, it should be assigned from the text boxes to the elements of a structure.

There are three different reports:

Report 1: A 4 column report that displays input data
Report 2: A two-column report that lists the ID and income of any household exceeding average income. The calculated verage income should be displayed on top of report.
Report 3: Percent of households that have income below poverty level.

Here's the poverty level guidelines:

family size, 48 contiguous states, Alaska, Hawaii
1, 14700, 18375, 16905
2, 19800, 24750, 22770
3, 24900, 31125, 28635
4, 30000, 37500, 34500
5, 35100, 43875, 40365
6, 40200, 50250, 46230
7, 45300, 56625, 52095
8, 50400, 63000, 57960
Add for each
additional person, 5100, 6375, 5865

PLEASE someone help me. I've understood code until this point and it's just because I'm trying to teach myself. I just have no idea what to do. If someone could make the code so I could look at it and understand or even part of the code it'd be much appreciated. Thank you.

Christian Graus31-Mar-09 13:19

31-Mar-09 13:19

Your name is VB Noobie, but this is the C# forum ?

If you're teaching yourself, where did this assignment come from ?

Which bits are you having trouble with ? Is it the code, or the math ? Think about the math, and then think about how you'd break that into steps in code.

VB Noobie31-Mar-09 13:33

31-Mar-09 13:33

I bought an old programming 2005 book because it's out of date and was cheap because they're bringing in the 2008 book and to try and understand the basics and hopefully grasp everything sufficiently. I'm working through the book and there are normally examples in each chapter so I get a code to look at and comprehend what they're doing in the code. The chapter on arrays has a horrible example that has nothing to do with arrays. I just don't understand how to code the array itself. I just need a valid example and this is the first problem from the book I bought.

Christian Graus31-Mar-09 13:48

31-Mar-09 13:48

The big question is, do you want an example in C# or VB ?

Most people don't use arrays because they are fixed size. However, the concept is the same as a list, you can make a 2D array like myarray[5][5], and then myarray[1] is an array of five elements, which you can then iterate over, or index.

VB Noobie31-Mar-09 13:57

31-Mar-09 13:57

I'm using Microsoft Visual Studio 2005 in C#. I mixed up VB and visual studio. I told you I'm a noob. But yes, an example would be awesome in C#.

Christian Graus31-Mar-09 14:19

31-Mar-09 14:19

OK, there's a couple of things here

1 - put your data in a structure. Do you know how to do that ?
2 - it doesn't say to use an array, AND it says to store your data as you go, so I think you need a list. You don't need a 2D array at all, as far as I can see.

struct myStruct
{
public int someInt;
public string someString;

}

that's nasty in an OO sense, but it's a rudimentary struct.

List<myStruct> myList = new List<myStruct>();

there's your list.

myList.Add(myStringInstance);

is how you add an item

foreach(myStruct item in myList)
{
item.someInt = 0; // or whatever
}

is how you step over them

VB Noobie31-Mar-09 14:54

31-Mar-09 14:54

I kind of understand it, but I would really appreciate at least a partial example using the instance I stated in the first post or something similar. I'm more of a fill in the blank memorization kind of person so it would probably help a lot more. Thank you for your quick replies so far.

Christian Graus31-Mar-09 15:14

31-Mar-09 15:14

"an ID, # of members in the house, annual income, and state of residence."

struct UserData
{
public int ID { get; set;};
public int Income { get; set; };
public string State { get; set;};
public int ResidentCount { get; set; };
}

// this is a member of your main form
List<UserData> _userData = new List<UserData>();

OnClickAdd()
{
UserData data = new UserData();
int id;
if (int.TryParse(UserID.Text, out id))
{
data.ID = id;
}
// do the same for income and residents and add an 'else' for invalid data for both

data.State = comboState.SelectedItem.ToString(); // use a combo so that the states are always the same and can be searched

_userData.Add(data);
}

Now I'd use a struct that contains your three states number values and do a Dictionary which maps that struct to the number of residents. But you can just put the residents into the struct, and do a simple search to find the right one, or even assume you can get it by index.

VB Noobie31-Mar-09 15:43