C# Discussion Boards - CodeProject

tiem12-Dec-04 14:24

12-Dec-04 14:24

Hi all,have you got any sample code in C# to process with ACCESS database such as:Read,WRite,Delete,etc...using 3 tiers model.Give me please,i know nothing about it,but i need it.Thanks for your helping!

God save all of you!

Re: ADO.Net 3 tiers

Christian Graus12-Dec-04 14:55

Christian Graus

12-Dec-04 14:55

tiem wrote:
using 3 tiers model

Well, so long as you have no presentation code in the example ( which you wouldn't ), it'll be suitable for 3 tiered development.

The MSDN is full of examples, I believe you pass the path to the Access DB to a SQL Connection constructor, then treat it as any other DB, passing in SQL, etc.

Christian

I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer

Re: ADO.Net 3 tiers

Christian Graus12-Dec-04 15:05

Christian Graus

12-Dec-04 15:05

You say in your email that you don't have time to look in MSDN. I found this link in less than a minute, using google.

http://visualbasic.about.com/od/usingvbnet/l/aa050303c.htm[^]

Christian

I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer

Re: ADO.Net 3 tiers

Nick Parker13-Dec-04 10:10

Nick Parker

13-Dec-04 10:10

Christian Graus wrote:
You say in your email that you don't have time to look in MSDN.

Sounds like a homework assignment coming due huh? Wink | ;)

- Nick Parker
My Blog | My Articles

Re: ADO.Net 3 tiers

Christian Graus13-Dec-04 10:30

Christian Graus

13-Dec-04 10:30

Either way, it's a worry when someone 'doesn't have the time' to use the best tools for the job.

Christian

I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer

Deploy Add-in trouble

Anonymous12-Dec-04 10:09

Anonymous

12-Dec-04 10:09

Hi
i had some add-in project in C#.
When i begin one add-in wizard create for me also setup project.
When i compile this project one create setup.exe file and some other files in Debug folder,further more when i launch this setup.exe file from this folder all work fine, but when i remove this file to an other directory and launching
one rised error "not found ...ini file".My question is "How i should compile my setup project in oredr to setup.exe launching be available without some other auxiliarity files"

Thank.

maximize a form

TyronX12-Dec-04 9:26

TyronX

12-Dec-04 9:26

I've tried for about all possible functions, searched thru articels, messageboards and the rest of the internet but nothing works.

When my Program starts up, i create a second window (titled Reminder) but hide it immediately. Various timers cause this Reminderwindow to pop up. But if my main window is minimized to taskbar the reminderwindow will also be minimized and visible in the taskbar. So... how do i avoid this so that the remidnerwindow pops up again?

Re: maximize a form

DavidNohejl12-Dec-04 10:05

DavidNohejl

12-Dec-04 10:05

Setting Form.WindowState to FormWindowState.Maximized doesn't work?
( too lazy to try right now Blush | :O

)
best regards,
David 'DNH' Nohej

Never forget: "Stay kul and happy" (I.A.)

Re: maximize a form

TyronX12-Dec-04 10:18

TyronX

12-Dec-04 10:18

No, it doesn't

Re: maximize a form

DavidNohejl12-Dec-04 10:46

DavidNohejl

12-Dec-04 10:46

oh, I see. Strange behaviour! anyway, I was playing with it... I don't whow what exactly are you doing, bt I made this work:

<br />
private void timer1_Tick(object sender, System.EventArgs e)<br />
		{<br />
			if(m_popUpForm.IsDisposed)<br />
			{			<br />
				m_popUpForm = new Form();<br />
			}						<br />
			m_popUpForm.WindowState=FormWindowState.Maximized;<br />
			m_popUpForm.Show();<br />
		}<br />

where m_popUpForm is protected member and it's basic Form class.

It pops up maximized nicely every tick event... even when "parent" form is minimalized!

Is it behavour tou want? I can send you whole app if you want.

I have to admit it's not the best way how to debug Blush | :O

bt it works and time is valuable, so forgive me so unprofessional approach Smile | :)

David

Never forget: "Stay kul and happy" (I.A.)

Re: maximize a form

TyronX13-Dec-04 2:11

TyronX

13-Dec-04 2:11

ah. Now i found the Problem.
I had the set the WindowState, Show the Form and Activate it.
[Form.WindowState=FormWindowState.Normal;
Form.Show();
Form.Activate();]

The Problem occurs when you generate a hidden
Winform on startup
Subform blah = new Subform();
blah.Hide();
and then try to show it when the main Form is minimized

private void button1_Click(object sender, System.EventArgs e) {
this.WindowState = FormWindowState.Minimized;
blah.WindowState = FormWindowState.Normal;
blah.Show();
blah.Activate();
}

It won't show up without bla.Activate();

Re: maximize a form

DavidNohejl12-Dec-04 10:11

DavidNohejl

12-Dec-04 10:11

Is it MDI app?

David

Never forget: "Stay kul and happy" (I.A.)

Re: maximize a form

TyronX12-Dec-04 10:20

TyronX

12-Dec-04 10:20

What's that?

I just created a new WinForm

Re: maximize a form

DavidNohejl12-Dec-04 10:50

DavidNohejl

12-Dec-04 10:50

MDI stands for Multiple Document Interface. It's old school way how to organise UI... if interested, check out IsMDIContainer property of Form in MSDN Smile | :)

David

Never forget: "Stay kul and happy" (I.A.)

C# network programming issue

Opa Knack12-Dec-04 8:15

Opa Knack

12-Dec-04 8:15

I've an server/client application, for sending single commands to specific clients connected to the server.
The server has an array object with the clients and their informations.

For more detailed informations I have to send a complicated string like "inetStats:PC1!online:PC2!offline"
and then I'm using String.Split(':') btw.: String.Split('!'). (I know it's veeery unprofessional!)

So, I just read about remote objects and MarshalByRefObject and I think it's a rather better way:
With a remote object I could make an array with the inetStates accessible for all connected clients.
I tested it by implementing the code, and it still works fine.

But is that a good idea, making a TCP channel for remote objects next to my Socket connection?
I'd like to replace the socket connection(working with delegates) with the TCP channel method.
But I don't know how to send commands to specific single clients, like in my socket connection?!

I'm looking forward to any suggestions.

(Sry for my bad english Blush | :O

)

Re: C# network programming issue

Gary Thom14-Dec-04 5:08

Gary Thom

14-Dec-04 5:08

I'm not sure exactly what you are asking, however

each client is likely to be on a different IP address, so they can all share the same port number. The remoting call can tell the different between clients.

Does that make sense?

Gary

Re: C# network programming issue

Opa Knack14-Dec-04 5:52

Opa Knack

14-Dec-04 5:52

What's exactly "The remoting call"? Confused | :confused:

How does the remoting call can tell me the differents between the clients?

Thx for (trying to) helping me.

Knack

Re: C# network programming issue

Gary Thom14-Dec-04 5:57

Gary Thom

14-Dec-04 5:57

Here's how I would do it.

The Server, waiting for a client to connect (similar to what you do now with the sockets). When the client connects you can determine (or pass) the IP address of the client. When the "server" wants to talk back to the client, it makes a remoting call to the <ip address="" of="" the="" client="">/Object so it can talk to a single client.

Gary

While you're waiting, read the free novel we sent you. It's a Spanish story about a guy named 'Manual.'
- Dilbert

Re: C# network programming issue

Opa Knack14-Dec-04 6:25

Opa Knack

14-Dec-04 6:25

yes, that's the way I want to do it.

But how would you let the server listen for any clients, like that?

-------------------------- server code snippet-------------------------------------------------
m_socListener = new Socket (AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp);
IPEndPoint ipLocal = new IPEndPoint (IPAddress.Any, port);
m_socListener.Bind (new IPEndPoint (aryLocalAddr[0], port));
m_socListener.Listen (maxClients);
m_socListener.BeginAccept (new AsyncCallback (OnClientConnect), m_socListener);
-------------------------- server code snippet-------------------------------------------------

Re: C# network programming issue

Opa Knack14-Dec-04 6:27

Opa Knack

14-Dec-04 6:27

(my client connection part Smile | :)

-------------------------- client code snippet-------------------------------------------------
m_socClient = new Socket (AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp);
IPAddress ip = IPAddress.Parse (remoteIP);
IPEndPoint ipEnd = new IPEndPoint (ip.Address, port);
m_socClient.Connect (ipEnd);
-------------------------- client code snippet-------------------------------------------------

And I have to use a tcp channel for marshaling objects, right?!

right after listening on socket the server opens a tcp channel for remote objects:

Re: C# network programming issue

Gary Thom14-Dec-04 7:45

Gary Thom

14-Dec-04 7:45

With remoting the server doesn't have to listen or block.

I usually have the server waiting on a keypress (or as a NT service).

When the client 'connects' by creating the remoting object .Net takes care of the TCP part. The object is created in the server and a proxy is created for the client, the client uses the object as if it were created locally.

Gary

While you're waiting, read the free novel we sent you. It's a Spanish story about a guy named 'Manual.'
- Dilbert

Re: C# network programming issue

Gary Thom14-Dec-04 6:01

Gary Thom

14-Dec-04 6:01

http://www.csharphelp.com/archives/archive187.html

http://www.c-sharpcorner.com/Network/RemotingInNETM.asp

http://www.codeproject.com/csharp/DotNetRemotingBasicTutor.asp

Maybe these will help Smile | :)

Gary

While you're waiting, read the free novel we sent you. It's a Spanish story about a guy named 'Manual.'
- Dilbert

Re: C# network programming issue

Opa Knack14-Dec-04 6:33

Opa Knack

14-Dec-04 6:33

(my client connection part Smile | :)

Re: C# network programming issue

Opa Knack14-Dec-04 6:34

Opa Knack

14-Dec-04 6:34

-----------------------------server code snippet2--------------------------
m_TcpChan = new TcpChannel(9999);
ChannelServices.RegisterChannel(m_TcpChan);
sets = new Interface.settings();
obj = RemotingServices.Marshal(sets,"settings");
-----------------------------server code snippet2--------------------------

client connects with:
sets = (Interface.Server.IServer)Activator.GetObject(typeof(Interface.Server.IServer),"tcp://localhost:9999/settings");

With the socket connection i'm able to send single string commands, and the client can pass his IP for identifiy it later.
Do I need an extra tcp channel for my purposes?

Knack

Re: C# network programming issue

Gary Thom14-Dec-04 7:40

Gary Thom

14-Dec-04 7:40

I think you can use the same/existing channel.

Gary

While you're waiting, read the free novel we sent you. It's a Spanish story about a guy named 'Manual.'
- Dilbert

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