Re: Sleep in an application - C# Discussion Boards

Re: Is this doable?

ed^nrgc26-Oct-06 3:49

ed^nrgc

26-Oct-06 3:49

You can ask a question once. By posting the same question 3X, it might get ignored.

Re: Is this doable?

sharma sanjeev26-Oct-06 3:52

sharma sanjeev

26-Oct-06 3:52

I POSTED IT IN THREE DIFF PLACES TO GET A WIDER RANGE OF SCHOLARS TO ANS MY QUE........IT WAS URGENT FOR ME AND NOT WRONG I THINK

Re: Is this doable?

ed^nrgc26-Oct-06 3:58

ed^nrgc

26-Oct-06 3:58

The "SCHOLARS" you seek are smart enough to see one post. They don't need 3. All posts here are important to the person posting it. Most are urgent requests caused by some business request. This board is a community that gives answers to people who have attempted to program a specific task and are stuck.

Re: Is this doable?

Colin Angus Mackay26-Oct-06 4:13

Colin Angus Mackay

26-Oct-06 4:13

sharma sanjeev wrote:
I POSTED IT IN THREE DIFF PLACES

First, please don't shout. It is considered rude.

You posted this question three times in one forum in the space of a couple of minutes.

Upcoming Scottish Developers events:
* UK Security Evangelists On Tour (2nd November, Edinburgh)
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog

Re: Is this doable?

sharma sanjeev26-Oct-06 17:41

sharma sanjeev

26-Oct-06 17:41

it was my mistake........apologies from my side ....

Sleep in an application

C-Scharbe25-Oct-06 21:58

C-Scharbe

25-Oct-06 21:58

hello,

can i some how sleep a process in an application?:
my problem is i want to execute a sql string.
if it failed i want wait some (milli)seconds before i repeat the execution

thank you

Re: Sleep in an application

baerten25-Oct-06 22:04

baerten

25-Oct-06 22:04

Hi,

use a sleep(x); in your function

Regards

Re: Sleep in an application

C-Scharbe25-Oct-06 22:10

C-Scharbe

25-Oct-06 22:10

but where can i find it?!

Re: Sleep in an application

Nader Elshehabi25-Oct-06 23:10

Nader Elshehabi

25-Oct-06 23:10

Call

Thread.Sleep(1000);

to sleep for one second. Yet, if you do this in your main Thread, this will cause your UI to freeze.

Regards

Re: Sleep in an application

abhinish25-Oct-06 23:10

abhinish

25-Oct-06 23:10

hi!
use
Thread.Sleep(5000); // this will sleep the thread for 5 seconds

abhinav

Re: Sleep in an application

C-Scharbe26-Oct-06 4:14

C-Scharbe

26-Oct-06 4:14

yes, thank you.

thats it.

create a control array in C#

chathu03j25-Oct-06 20:49

chathu03j

25-Oct-06 20:49

how do you create a control array in C#?

Re: create a control array in C#

Nader Elshehabi25-Oct-06 21:26

Nader Elshehabi

25-Oct-06 21:26

Control[] MyArray = new Control[X];

Was that what you were looking for?

Regards

connect a mysql database to c# project

chathu03j25-Oct-06 20:46

chathu03j

25-Oct-06 20:46

I'm quite new to c#. Can smbody pls tell me how to connect a mysql database to a c# project? Thanks

Re: connect a mysql database to c# project

seee sharp25-Oct-06 21:13

seee sharp

25-Oct-06 21:13

You may like to have a look at this

http://www.codeproject.com/cs/database/ConnectMySQL.asp[^]

- ashish

Re: connect a mysql database to c# project

Polar2226-Oct-06 1:51

Polar22

26-Oct-06 1:51

you need to install an ADO.NET driver for mysql, you can find one here:
http://dev.mysql.com/downloads/connector/net/5.0.html[^]

Once installed, new components, like MysqlDataset and MysqlDataTable, will appear in your toolbox in visual studio. Documentation on how to use them should also be included in the download, otherwise you can lookup the documentation for the ADO.NET components, like Dataset and DataTable, in the visual studio documentation, they are used the same way.

HowTo make a dll, which can be called by VBA

Ariadne25-Oct-06 19:34

Ariadne

25-Oct-06 19:34

Hi,
are there any roules for a dll written in C#, which can be called by a VBA Macro?

Private Declare Function foo Lib "foo.dll" (sfoo as string) as string

How does the C# code for such dll look like?

Ariadne

Re: HowTo make a dll, which can be called by VBA

mav.northwind25-Oct-06 21:07

mav.northwind

25-Oct-06 21:07

Hi!
You'll have to create a COM object for this, VBA cannot access a function in a .NET assembly.

Regards,
mav

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

Re: HowTo make a dll, which can be called by VBA

Nader Elshehabi25-Oct-06 21:24

Nader Elshehabi

25-Oct-06 21:24

What Mav said is true. But as an addition, you can write your code as C# and make your C# dll, then register it as COM dll then use it from your VBA macro.

I think this post[^] would be helpful.

Regards

Re: HowTo make a dll, which can be called by VBA

Ariadne25-Oct-06 21:32

Ariadne

25-Oct-06 21:32

Really?
Is it complicate to register a dll as com?

Ariadne

Re: HowTo make a dll, which can be called by VBA

Nader Elshehabi25-Oct-06 21:34

Nader Elshehabi

25-Oct-06 21:34

Well, not really. You can follow the link to the post I gave you in the previous reply.

Here is the link again[^].

Regards

Re: HowTo make a dll, which can be called by VBA

ed^nrgc26-Oct-06 3:53

ed^nrgc

26-Oct-06 3:53

you should check : ServicedComponent

Re: HowTo make a dll, which can be called by VBA

Ariadne25-Oct-06 23:03

Ariadne

25-Oct-06 23:03

Thanks.
If I use tlbexp I get only my class exposed, but not my methods. Any ideas? (I suppose, the methods have to have a certain format.)

Nevertheless I do not belive, that a COM-object is the only way to get a connection to VBA. With a COM-object you do not need a Declare Function statement. But with a Declare Function one can access all routines eg. in the kernel.dll. (And that are not COM's in kernel.dll).

Ariadne

Re: HowTo make a dll, which can be called by VBA

Nader Elshehabi25-Oct-06 23:08

Nader Elshehabi

25-Oct-06 23:08

If you got your class exposed, how come not the methods in it?? Aren't they public?

If there is some sort of a VBA .Net language then this would be a solution to your problem, bur otherwise there is no other direct conection between umanaged-to-managed code that I know of.

Regards

Re: HowTo make a dll, which can be called by VBA [modified]

Ariadne25-Oct-06 23:13

Ariadne

25-Oct-06 23:13

public class PW
{
  public static string Convert5Bit(byte[] abytID)
  {
    //do somthing here ...
    return sConv;
  }
}

This is the declaration. But only PW as class is exposed.

-- modified at 5:19 Thursday 26th October, 2006

Ariadne

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