C# Discussion Boards - CodeProject

30-Jun-04 6:56

The simplest way is to use SQL-DMO. Right-click on your project and select Add Reference. Click the COM tab and find "Microsoft SQLDMO ..." in the list. Double-click to add it.

Your code is then as easy as this:

SQLDMO.Application app = new SQLDMO.ApplicationClass();
SQLDMO.NameList servers = app.ListAvailableSQLServers();
if (servers != null)
  foreach (string server in servers)
    Console.WriteLine(server);

You can also P/Invoke dbserverenum, though this is rumored to be unsupported in future versions (it's from an old C library). If you use SQLDMO, you'll need to redistribute the interop assembly that VS.NET will create when you add the COM reference to the SQL-DMO library. SQLDMO must be installed, however, on the target machine (this is done by SQL Server and the MSDE).

If you don't want to rely on such client requirements, you'll have to google the net to see if you can find the protocol used to detect SQL Servers on the network.

Microsoft MVP, Visual C#
My Articles

How to implement

John L. DeVito29-Jun-04 22:00

John L. DeVito

29-Jun-04 22:00

Heyas all,

I'm comming from a unix/c background here and trying to learn .NET. I'm attempting to make a simple cd-database program. What would be the best way to implement the data storage portion of the program (ie. sql database, text file, access database, etc.) The user would have complete control over the datbase create new ones ect.

Thanks all!

kha0s

"There are 10 types of people in this world; Those that know binary and those that do not."

Colin Angus Mackay29-Jun-04 23:14

Colin Angus Mackay

29-Jun-04 23:14

What do you mean by "cd-database program"? You are going to run it from CD, or you're going to install it from the CD?

If you are installing to the HD you could look at MSDE which is the Desktop Edition of SQL Server and is redistributable.

"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar

The Second EuroCPian Event will be in Brussels on the 4th of September

Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way!

My Blog

misterbear30-Jun-04 0:55

misterbear

30-Jun-04 0:55

My guess is he probably means a cd-collection-catalog. Am I right?

John L. DeVito30-Jun-04 8:17

John L. DeVito

30-Jun-04 8:17

Hi!

Sorry for the confusion. What I am writing is a program that simply catologs a persons cd's. they enter the information in manually like name, author, etc etc THe user can search using the same fields for a particular cd entered in the catalog. they can add or remove entries as well.

kha0s

"There are 10 types of people in this world; Those that know binary and those that do not."

Colin Angus Mackay30-Jun-04 8:56

Colin Angus Mackay

30-Jun-04 8:56

I would go with using MSDE as your database engine as you can redistribute it. You can access it via the classes in the System.Data.SqlClient namespace.

John L. DeVito30-Jun-04 13:27

John L. DeVito

30-Jun-04 13:27

Heya,

I've decided to hgo with the MSDE route. However, I've installed the package MSDE2000A.exe. The package extract fine and go to MSDE\ and run setup SAPWD="whatever". THe process compeltes successfully however after rebooting, there is no MSSQLSERVER service listed under services on my machine. I'm running XP with all available updates. Anyone have a clue as to what's going on. Sorry for such a newb question but this is really frustrating me.

Also, I have SQL Server 2000 available to me as well. Would I get the same functionality from that program? Should I use that if I have it instead?

Thanks All.

kha0s

"There are 10 types of people in this world; Those that know binary and those that do not."

Werdna30-Jun-04 5:46

Werdna

30-Jun-04 5:46

Using DataSet would be an easy solution because you can create those on the fly, from XML or from any database and save changes to those sources.
You can have all the data pre-loaded and have parent/child relations. You can search, sort, filter without depending on the database. Can save to local storage, access database, etc.
In other words, most flexible solution.

Collection class with different class members

Werdna30-Jun-04 5:47

Werdna

30-Jun-04 5:47

and I have also written something to what you want to write:
http://www.adersoftware.net/?page=oyster

You can download it for free, and if you want to look at the source code, let me know and I can send it to you.

pxp29-Jun-04 21:31

29-Jun-04 21:31

Hi all,

i would like to set up a logic like this:

A Collection class School which holds different class-members like:

* student
* teacher
* table
* chair
* classroom
* stairs

Member classes have different values (and methods), like:

- student   has: name, age and classroom <small>(link to classroom id?)</small>
- teacher   has: name
- table     has: pointF position, color and tabletype <small>(an enum)</small>- classroom has: pointF[] polyline, ID, classroomtype and MaxPersons
- stairs    has: pointF startpoint and pointF startpoint

I would like to get information for all elements in the main class collection using the foreach statement.
Then using it's type i can act on it. For a classroom i could show the position PointF[] on an image and for the students i could show only the students which are in that particular classroom.

Pseudo code:

Foreach element in MainSchoolCollection
  
  If element.type is typeClassroom
  
    // draw all points on a picture canvas
    PointF[] thePoints = element.vertices[]
    element.DrawMyClassroom(thePoints)
    // it's ID
    int ClassID = element.ID
    // All students which are in this classroom
    Foreach element in MainSchoolCollection
      If element.type is typeStudent
        MessageBox.Show(element.name)
      EndIf
    EndForeach
      
  EndIf
  
  If element.type is typeStairs
    // draw the line of the stair
    element.StairsToLine(element.startpoint, element.endpoint)
  EndIf
  
EndForeach

So the main issue is that each element in the collectionclass has different properties and methods. When looping through the main collection i would like to use/modify the element's property based on it's type.

Can anyone point me in the right direction here?

Thanks,

Me.

Rakker7129-Jun-04 23:07

Rakker71

29-Jun-04 23:07

first, you have to define element and give it a common description, i.e., something that goes for all items. Then, you can implement the IEnumerable interface in all items, so you can use an enumerator.

You might even use an emty interface, which can be used as element in the foreach loop, and then cast the element to the containing type, just as you did.

pxp30-Jun-04 5:05

30-Jun-04 5:05

Hoi Rakker,

klink Nederlands,... Blush | :O

)

Do you happen to know if this subject is explained in a tutorial somewhere,... i'm relative new to interfaces.

Thanks.

Heath Stewart30-Jun-04 5:56

30-Jun-04 5:56

This is one thing that object-oriented programming solves. Define an abstract base class with all the properties and methods that are shared by every derivative class. Some of these properties may even be abstract themselves, declaring that derivative class must override them (perhaps to provide a friendly name of the object, rather than just returning the class name).

A simple hierarchy of classes I see from your list is like so:

abstract SchoolObject
+abstract Person
|+Student
|+Teacher
+abstract Item
|+Table
|+Chair
|+Classroom
|+Staircase

So the abstract SchoolObject would define the properties you need for everything. Your SchoolCollection accepts types of SchoolObjects, which can be an instance of any derivative class. As you're enumerating your collection, you can access the shared properties of SchoolObject, which - if virtual - the derivative classes can override to return different results.

This is really a core concept of object-oriented programming. If you're new to object-oriented programming or programming in general, I recommend you pick up a good book or two on object-oriented programming with .NET, such as Learn to Program with C#[^] (top-rating from a quick Amazon.com search). Object-oriented programming is also taught in most college curriculums, and can be picked pretty easily by reading through the documentation and looking at examples (CodeProject has thousands of examples).

Microsoft MVP, Visual C#
My Articles

pxp30-Jun-04 7:32

30-Jun-04 7:32

Hi Heath,

thanks for the reply and info.

Comming from a VB background and using collection classes there i thought things would be similar, but i could not get the properties of the elements in my collection.

In VB i used like:

collection class:

Private mCol As Collection

Public Function AddClassRoom(ByVal Name As String, ByVal MyCenter As Coord) As ClassRoom
Public Function AddStudent(ByVal FirstName As String, ByVal Lastname As String) As Student

Both Student and ClassRoom are seperate classes with different properties and methods.

Problem is that there seems no simple translating to the Private mCol As Collection part.

Reading to do for me,... Cry | :((

Thanks again.

mav.northwind30-Jun-04 8:31

mav.northwind

30-Jun-04 8:31

If you really want arbitrary objects to be in your collection you could simply use the base collection classes from System.Collections.
They usually have object derived items, so you can stuff in what you like.
When you're enumerating these collections you can determine the type of each item by something similar to (in C#):

ArrayList myCollection = new ArrayList();
// fill in the objects
[...].// enumerate the objects
foreach (object o in myCollection)
{
  if (o is Teacher)
  {
    Teacher t = o as Teacher;
    t.DoSomethingOnlyTeachersDo();
  }
  if (o is Chair)
  {
    Chair c = o as Chair;
    c.StandThere();
  }
}

mav

pxp30-Jun-04 23:41

30-Jun-04 23:41

Hi Mav,

Thanks, that did the trick !

I have the setup correct in general:

collection class with elements called obj which is an interface and all objects i store in the collection 'derive' from obj.

So, using class objects like:

public class objTeacher : obj

public class objStudent : obj

My problem (major error D'Oh! | :doh:

) was that i did not 'copy' the properties of a 'general' object to the object i need like your example:

if (o is Teacher)
{
    Teacher t = o as Teacher;
    string test = t.TeacherName;
    t.DoSomethingOnlyTeachersDo();
}

in my case i could not access the propertie TeacherName because it is an object/class specific property.

Casting it as a Teacher object did the trick !

How live can be sweet and simple sometimes Big Grin | :-D

So to understand the logic here, the Teacher is a derivate of the obj interface.

Is this the propper structure to enumerate and use different objects in 1 collection, or am i on a dangerous path here?

Me.

mav.northwind1-Jul-04 0:29

mav.northwind

1-Jul-04 0:29

I think it's the easiest way to go.
In fact you wouldn't even have to derive from obj, because all classes in .NET implicitely inherit object, which is the item type of most base collections.

Using an obj interface might be the cleaner way if you want to ensure type safety at compile time. But then you have to make the collections typesafe (for example by deriving from CollectionBase and overriding the required methods). And find a meaningful interface.
I usually doubt if an empty marker-interface/base class (I think somebody suggested this) is a good idea from an object oriented view. By defining an interface you extract all common properties and behaviour into the interface, but if you can't find anything the different classes implementing your interface have in common then why should you create an interface?

One caveat remains, though. Using object derived items will allow you to add anything to your collection at compile time, even if this might not be desireable. You will not be able to check this until run time.

Regards,
Mav

pxp1-Jul-04 3:28

1-Jul-04 3:28

I now removed the interface and use object to enumerate,... works perfectly.

Thanks !

Heath Stewart30-Jun-04 8:35

30-Jun-04 8:35

Despite what Microsoft marketing tries to tell you, VB6 is nothing like VB.NET (which is just a language which targets the CLR and uses a common class library). Collections are objects all by their lonesome and you can extend CollectionBase if you want to avoid a lot of the mess but still provide typed parameters (you could override Add, for example, and provide a parameter type as the base class).

You'll still want to go with an abstract object model as everyone here so far has told you. This is something VB couldn't do and is very powerful and leads to clearner designs than prototyping functions like you did in your snippet (having one method to add the base class defined on the collection itself).

Microsoft MVP, Visual C#
My Articles

pxp30-Jun-04 22:47

30-Jun-04 22:47

Thanks Heath and Mav,

yes VB is a whole different cookie to eat then C#,...noticed Blush | :O

)

Will do some reading/investigating regarding the abstract model or go for the mav-version [ArrayList-logic].

Base, Abstract, Virtual, Interface and Derivative classes.

A class collection with a collection of 1 class i got covered.

Mostly i work of examples / snippets but did not find anything regarding various calsses in one collection.

So, welcoming myself to the new world Blush | :O

)

Heath Stewart1-Jul-04 3:54

1-Jul-04 3:54

Mav's way, IIRC, uses interfaces. Interfaces and abstract classes differ mostly in the fact that abstract classes can at least contain some functionality. Take the top-most class from which all classes derive: System.Object. It's ToString method is available on any class with default behavior to return the namespace-qualified type name, but classes can override it to return something else. With an interface, each implementing class would have to override it; they don't have a choice. Also, a class can implement multiple interfaces, but can only extend one class.

pxp wrote:
yes VB is a whole different cookie to eat then C#,...noticed

Actually, even VB.NET is different. The syntax is mostly the same, yes, but the output is very different. VB.NET, C#, MC++, and any other managed languages can use assemblies written in any other language because the language compiler for each language compiles to Intermediate Language (IL). Some languages may not support all the features of the Common Language Infrastructure (CLI) and, in many cases, would only be able to use CLS-compliant (Common Language System) types. JScript.NET is a good example.

pxp wrote:
Mostly i work of examples / snippets but did not find anything regarding various calsses in one collection.

Don't think of it as multiple classes but as one class - the abstract class. Sure, in actually the collection contains multiple instances but since each one of those classes derives from the base class (and your collection's methods and properties use that base class).

Microsoft MVP, Visual C#
My Articles

pxp1-Jul-04 4:05