Re: sql to C#.net databinding - C# Discussion Boards

JBHowl30-Jan-15 5:31

JBHowl

30-Jan-15 5:31

do you have an example, or article you can link?

Richard Andrew x6430-Jan-15 5:46

Richard Andrew x64

30-Jan-15 5:46

Here's a tutorial from MSDN:

https://msdn.microsoft.com/en-us/library/aa645740(v=vs.71).aspx[^]

The difficult we do right away...
...the impossible takes slightly longer.

Gerry Schmitz30-Jan-15 10:32

Gerry Schmitz

30-Jan-15 10:32

Make a new application (server) that references the 3rd-party dll.

Remove the references to the 3rd-party dll from the other programs(Windows app and service).

Determine how you want the other programs to access the new app (and 3rd-party dll): file directory watcher; message queue; pipes; sockets; remote automation; etc.

Send 3rd-party dll requests from the 2 programs to the new unattended app that handles requests by monitoring a file directory; or message queue; or ...

Results are returned along the same lines.

sql to C#.net databinding

jschell30-Jan-15 11:13

jschell

30-Jan-15 11:13

Gerry Schmitz wrote:
Make a new application (server) that references the 3rd-party dll.

That is what I would suggest as well.

User 1138061130-Jan-15 3:52

User 11380611

30-Jan-15 3:52

hi,

i am working on a project in which i need to transfer the data received from a query to multiple labels.

My Query: select make from dbo.cardetails;

the result of the above query is a single column with 30 rows.

now i want each row to be used as Label.text in C#

awaiting ur helpful replies.....

thanks in advance

modified 2-Aug-18 21:02pm.

OriginalGriff30-Jan-15 4:00

OriginalGriff

30-Jan-15 4:00

Don't.
What if next week someone removes three rows? Or add seven? What happens to your app?

It falls over, is what.

Instead, look at using a grid based control of some form, depending on your working environment. For WinForms, a DataGridView would be good; for a website, maybe a GridView; and so forth.

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

User 1138061130-Jan-15 4:13

User 11380611

30-Jan-15 4:13

hey buddy,
but the database will be in accessable to the users.
they could only use the front end (C# form app).
so if u could help me out with my problem, it would help me alot.

modified 2-Aug-18 21:02pm.

Simon_Whale30-Jan-15 4:13

Simon_Whale

30-Jan-15 4:13

If you want to make it flexible and avoid what Griff is saying you are going to need to be able to create these labels at runtime using something similar too

Label MakeLabel = new Label();
MakeLabel.Name = "x";
MakeLabel.Text = CardDetailsField;

Form.Controls.Add(MakeLabel);

please note that this code snippet is not complete as you need to add the looping of your resultset, positioning on the form etc.

But also Like Griff stated can't you use something different to display the data? such as a datagridview or listbox control?

Every day, thousands of innocent plants are killed by vegetarians.

Help end the violence EAT BACON

SWF File version 9 decompiling in c#

User 1138061130-Jan-15 4:27

User 11380611

30-Jan-15 4:27

thanks for ur code Simon
it worked good
but the problem is tat my Labels are already present and only their names are to be assigned such tat i cud change the db in future to avoid much work and the labels get new names as soon as the db is changed and run.

modified 2-Aug-18 21:02pm.

krvasanth30-Jan-15 1:26

krvasanth

30-Jan-15 1:26

hi,

i want to decompile SWF file from c#. my version is 9. any can help me in this

Re: SWF File version 9 decompiling in c#

Eddy Vluggen30-Jan-15 5:14

(solved) WinForms: run-time loading of UserControl .dll that implements an Interface ?

30-Jan-15 5:14

krvasanth wrote:
any can help me in this

Start here[^].

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

BillWoodruff29-Jan-15 21:17

Re: WinForms: run-time loading of UserControl .dll that implements an Interface ?

29-Jan-15 21:17

Edit: Thanks to Eddy Vluggen, and Freak30, problem resolved. The solution was that I needed to create a separate .dll containing only the Interface, and then have both the host application, and the dynamically loaded UserControl, reference the Interface .dll.

I define a Control Library in WinForms: it implements two Types: a UserControl, and an Interface, Iinterface. The UserControl, of course, implements the Interface.

Using the standard methods:

1. Assembly LoadedAssembly = Assembly.LoadFile(... filePath to usercontrol .dll ...);

2a. Type LoadedIInterfaceType = LoadedAssembly.GetTypes()[0]; // get the Type of the Interface
2b. Type LoadedUCType = LoadedAssembly.GetTypes()[1]; // get the Type of the UserControl

3. UserControl loadedUC = (UserControl)Activator.CreateInstance(LoadedUCType);

This does load, and instantiate, the UserControl at run-time. Of course, because I've cast the loaded UserControl to the "vanilla" UserControl base-Type, any public Fields/Properties/Methods I've deliberately exposed in the UserControl definition are not available.

If I have the loading Application define the same Interface:

// example
interface Iinterface
{
   // some public property in the UserControl
   // which is implemented in the UserControl
   string ID { set; get; }
}

Casting the UserControl instnace that shared that interface ... or any interface ... in the loading App would be pointless since that would just produce 'null.

Is there any way I can use the loaded interface Type from step 2a. above to cast the loaded UserControl to the Interface and thus expose its public Fields/Properties/Methods, etc. ?

I am aware I can use reflection to access the internal Fields/Methods that are prescribed by the interface, but I'd much rather ... if it's possible ... get everything in the UserControl that is prescribed in the Interface ... out there.

I can confirm I have a valid reference to the interface in step 2.a above by inserting this code and setting a break-point; all the expected elements are exposed:

var methods = LoadedIInterfaceType .GetMethods();
var types = LoadedIInterfaceType .GetProperties();
var fields = LoadedIInterfaceType .GetFields();

To use that old cliche: "what am I missing, here?"

thanks, Bill

«I'm asked why doesn't C# implement feature X all the time. The answer's always the same: because no one ever designed, specified, implemented, tested, documented, shipped that feature. All six of those things are necessary to make a feature happen. They all cost huge amounts of time, effort and money.» Eric Lippert, Microsoft, 2009

modified 30-Jan-15 11:02am.

Eddy Vluggen30-Jan-15 0:29

Re: WinForms: run-time loading of UserControl .dll that implements an Interface ?

30-Jan-15 0:29

A placeholder to program against in the main application.

Move the interface to another assembly and reference that from the main application; next you load usercontrols that implement the interface - but you'd loose the ability to update the interface without updating the main executable. You might also want a factory somewhere that determines what class to instantiate if you pass it an interface.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

BillWoodruff30-Jan-15 4:32

Re: WinForms: run-time loading of UserControl .dll that implements an Interface ?

30-Jan-15 4:32

Thanks, Eddy; I will experiment with creating a .dll containing only the Interface, although it seems weird to have to do that Smile | :)

Eddy Vluggen30-Jan-15 5:11

Re: WinForms: run-time loading of UserControl .dll that implements an Interface ?

30-Jan-15 5:11

BillWoodruff wrote:
although it seems weird to have to do that

It sounds weird to not do that, from my point of view.

What would you use as a base-class to reference the control in the application? Both UserControl and Object will not know any specifics - you'd have to use reflection to invoke anything, which defeats the reasoning on using an interface.

It sounds like you want to have a "general" way of talking to dynamic loaded UserControls.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

BillWoodruff30-Jan-15 6:45

Re: WinForms: run-time loading of UserControl .dll that implements an Interface ?

30-Jan-15 6:45

Eddy Vluggen wrote:
It sounds like you want to have a "general" way of talking to dynamic loaded UserControls.

I would have guessed ... before today ... that given a valid reference to a Type (an Interface) one could somehow cast another valid reference (to an instantiated object that implements the Interface) to the Interface.

But, looks like this is not possible.

Thanks again, for your reply.

Eddy Vluggen30-Jan-15 7:15

Re: WinForms: run-time loading of UserControl .dll that implements an Interface ?

30-Jan-15 7:15

One can; if your IUserControl is in assembly A, and the implementation in B (with a reference to A), you could use A from your mainapp to reference the UserControl.

I don't know whether it would accept a "similar looking" interface from another assembly, even if they have the same name - AFAIK, they'd be treated as different types since they are located in different assemblies.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Freak3030-Jan-15 3:22

Freak30

30-Jan-15 3:22

I second the suggestion of moving the interface definition a .dll shared by the executable and the control library. The interface shouldn't change that often.

Also I wouldn't call the interface Iinterface. IUserControl is probably more fitting.

The good thing about pessimism is, that you are always either right or pleasently surprised.

Re: WinForms: run-time loading of UserControl .dll that implements an Interface ?

BillWoodruff30-Jan-15 4:33

getting os info of local network

30-Jan-15 4:33

Thanks for your reply. I'll try it. I used a nonsensical name because I was just pasting in the minimal amount of code, to keep the post brief.

JSingh_Freelancer29-Jan-15 20:47

JSingh_Freelancer

29-Jan-15 20:47

Hello everyone,

In one of my project i have a requirement of getting OS Name,version information etc of local network.

Is anyone have any idea of getting Non-Windows OS infomation from Windows machine using c#,c++,or Win32 API.

Thanks in Advance.

Regards,
Jitendra Singh

Richard MacCutchan29-Jan-15 22:59

Richard MacCutchan

29-Jan-15 22:59

A network does not have OS information, it's just a bunch of wires connecting a group of systems. And what exactly do you mean by "Non-Windows OS infomation from Windows machine"?

OriginalGriff30-Jan-15 0:08

OriginalGriff

30-Jan-15 0:08

If you mean "I want to run software on my Windows machine to find out what OS all the other equipment on my network is running" then AFAIK you can't. Partly because some if it is unlikely to be a computer at all - printers, router, dedicated IoT devices and so forth; and mostly because security on most systems prevents it. If you advertise your OS, then you advertise your vulnerabilities - so it's kept within the machine for the most part to make it harder for attackers. You can guess by checking which ports are open - different OSes tend to open a different set of ports by default, so if they haven't been changed it might be indicative, but it won't be conclusive.

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

JSingh_Freelancer30-Jan-15 0:16

JSingh_Freelancer

30-Jan-15 0:16

I mean i will provide a IP range that belongs to same local network.
For instance i give IP range 192.168.1.20 to 192.168.1.30

IP OS

192.168.1.20 Windows 7 x64 bit
192.168.1.21 Linux OS
192.168.1.22 Mac (Lion 10.7) x64 bit
192.168.1.23 Windows 7 x32 bit

I hope now the picture becomes more clearer.

Regards,
Jitendra Singh

OriginalGriff30-Jan-15 0:23

OriginalGriff

30-Jan-15 0:23

And as I said: AFAIK, you can't do that.

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...