Re: beginning a c# database - C# Discussion Boards

3-Aug-04 11:12

Can anyone help me create a Dental database system for recording patients records, I need help.

I have created the tables using Access, and want to link them to visual studio using a .SQL server, it doesnt have to be anything fancy just a start.

If you can help then email me at email2miles@yahoo.com

Or reply on here.

Nick Parker3-Aug-04 11:27

3-Aug-04 11:27

Miles Roberts wrote:
Can anyone help me create a Dental database system for recording patients records, I need help.

In short, no, however if you have a specific question in doing so, absolutely. No one on here will do your work for you, however we would all love to help if you are stuck on something specific. There are plenty of articles on CP that cover how to interact with a database, look through the articles and read MSDN[^] as well.

- Nick Parker
My Blog | My Articles

Colin Angus Mackay3-Aug-04 11:48

Colin Angus Mackay

3-Aug-04 11:48

Miles Roberts wrote:
I have created the tables using Access, and want to link them to visual studio using a .SQL server

These are two different database technologies. Which do you want to use Access or SQL Server?

"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

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

Miles Roberts3-Aug-04 11:53

3-Aug-04 11:53

yea i have designed the access part, and i think i have just linked it so i can view the tables etc in the server explorer, but this was using jet 4.0 provider.
YOu think i am alright using that?
Now i wanna design some forms and get some queries running, any advice?

Colin Angus Mackay3-Aug-04 12:12

Colin Angus Mackay

3-Aug-04 12:12

Miles Roberts wrote:
YOu think i am alright using that?

I don't know that depends on what you are trying to achieve. Access is good as a desktop database with a limited number of users. SQL Server is good at being a server database with many users. Access has lots of built in functionality to allow whole applications to be built with it. SQL Server provides functionality that supports its use in a n-tier environment. If you are not using the application side of the Access database, MSDE may be a better choice as it is a cut down version of SQL Server that supports a limited number of users, but integrated just like the full SQL Server. You can also create Stored Procedures with SQL Server which mean that you get an extra layer of protection as your application interacts with the Stored Procedure rather than directly with the tables.

Miles Roberts wrote:
Now i wanna design some forms and get some queries running, any advice?

I am assuming you mean Windows.Forms rather than the forms in Access. However I don't know what you are looking for in advice - the design aspect is entirely dependent on what you need to achieve.

You should think about the types of things that need to be recorded at certain stages of the service (e.g. when a patient arrives for an appointment, when the dentist requests a follow-up appointment, the patient calls to cancel/rearrange an appointment). This is where Use Cases come in handy. If you don't want to go to the formality of Use Cases then you can just think of lots stories where an interaction with the system occurs, where does information come from, who interacts with the system you are building, what are the outputs (e.g. Is it just an update in the database, or is an invoice printed or whatever). Once you have these stories you can begin to see what forms you will need to design and what to put on them. Some stories may overlap somewhat and you might be able to design a form that fits into two or more stories.

Does this help? If not, you may need to be more detailed in what you are trying to achieve.

Miles Roberts4-Aug-04 2:06

4-Aug-04 2:06

Yes i mean windows.forms, i have a scenario written out and want a way to record details of the patient etc and tell him/her when there next appointment will be. I dont want it to print, however if i have time i can introduce an appointment card.
Firstly i bought the wrox press beginning c# databases book and that loads an employee database up which you can run queries select etc.
I need to know how i can do that using my dentist access database, so i can design forms and select different patient records and add new patients in.

Its difficult to explain, should i send you my access database first?

Miles

Christian Graus3-Aug-04 12:19

Christian Graus

3-Aug-04 12:19

Some questions:

1. Is this your first ever C# program ?
2. Is this your first ever database program ?
3. Is this your homework ?

As has been said, Access and SQL Server are two different things. SQL Server obviously canes Access, but if you're only doing something simple, Access has some benefits, some of which can be achieved with MSDE. For starters, if this is not homework, and if someone is actually going to use this code, do they have a licence for SQL Server ?

Christian

I have drunk the cool-aid and found it wan and bitter. - Chris Maunder

Miles Roberts4-Aug-04 0:34

4-Aug-04 0:34

No this is not my first c# program
first database though
yes its for university. but i only need some advice.

Christian Graus4-Aug-04 11:01

Christian Graus

4-Aug-04 11:01

OK, well, a DataGrid provides out of the box Excel like editing for a data source, and with articles on this site you can add drop down lists that reference lists in your data. As has been said, Access and SQL Server are two very different beasts. If it's for a computing degree, I recommend using SQL Server, seeing as it is useful in the 'real world'. Apart from that, you'll need to be more specific. What does your database schema look like ? What information do you need to store in it ?

Christian

I have drunk the cool-aid and found it wan and bitter. - Chris Maunder

some parts of image still on the screen after i close the form

Looney Tunezez3-Aug-04 12:50

Looney Tunezez

3-Aug-04 12:50

Miles Roberts wrote:
Can anyone help me create a Dental database system for recording patients records

Pay me and I can do it for ! Smile | :)

;);P

"Creating tomorrow's LEGACY systems today.....
.... One CRISIS at a time!" -- Unknown

"If you build it....
.....BUGS will come!" -JB

this.Dispose();

"A Bug is a piece of code that knows whatz itz purpose" - I Dunnnnooooooo

mostafa hamed3-Aug-04 10:21

mostafa hamed

3-Aug-04 10:21

i have a problem some parts of the image of the form still on the screen after i close the form which affect the form under it

Re: some parts of image still on the screen after i close the form

Nick Parker3-Aug-04 10:35

Re: some parts of image still on the screen after i close the form

3-Aug-04 10:35

Read into the Control.Invalidate[^] method.

- Nick Parker
My Blog | My Articles

Jay Shankar3-Aug-04 15:16

Jay Shankar

3-Aug-04 15:16

1.Are you using API function LockWIndowUpdate(hwd handle)any where in the code???
Please make sure that window should get unlocked, before closing the form.
2.If you are not using LockWindowUpdate, then as Mr. Nick has recommended, you should Invalidate the region behind the form.

I have had this problem due to LockWindowUpdate, that is why I added the point.

Hope this helps.

Re: some parts of image still on the screen after i close the form

Anonymous5-Aug-04 4:33

Anonymous

5-Aug-04 4:33

merci for reply
1- i don't call any api function in my code it is all C#
2- i know the solution of Invalidate but i think that the under form must be restore with out using invalidate to invalidate the region behind the form

Thumbnails with large files

Gambit_Sunob3-Aug-04 10:03

Gambit_Sunob

3-Aug-04 10:03

I'm trying to creat a program that will scan a directory for all image files and add them to a list box. I have that all under control. However when I select 5 megapixel pictures which can be over 2 meg a piece the program will have extreme difficulties. I tried using it and selected 40 some 2 meg pictures to turn them into thumbnails by simply resizing them. However my PF usage went to over a gig! So what can I do to create a thumbnail of these pictures without a 1 gig PF usage?

Gambit

Re: Thumbnails with large files

Nick Parker3-Aug-04 10:28

C# call method from array

3-Aug-04 10:28

When you are done with your Bitmap object, explicitly call Dispose(). Alternatively, when you create your Bitmap object, use the C# using syntax which will emit a try/finally block around your code and in the finally statement it will cast your Bitmap object to an IDisposable and call the Dispose() method for you. You can only use the using syntax when the object you create implements the IDisposable interface. The syntax would look as follows.

using(Bitmap b = new Bitmap(16, 16))
{
// use b here...
}

- Nick Parker
My Blog | My Articles

Tab Control

sreejith ss nair3-Aug-04 6:57

sreejith ss nair

3-Aug-04 6:57

hi there,
I have one tab control with three tab in my form. Background color of my form and tabe control is ControlDrak. How can i change the heading part of tab controls backcolor to controldark.

**************************
S r e e j i t h N a i r
**************************

[HUN]Slater3-Aug-04 5:55

[HUN]Slater

3-Aug-04 5:55

This is the code:

public void foo(){
MessageBox.Show("Me");
}

public System.Collections.Hashtable methods_list = new Hashtable();
public System.Collections.Hashtable objects = new Hashtable();

private void Form1_Load(object sender, System.EventArgs e){
methods_list.Add("First",(new string[] {"foo","param","param"});
Button elem = new Button();

elem.Text = ((string[])(methods_list["First"]))[0];
elem.Location = new Point(10,10);
//
// elem.Click += new System.EventHandler(foo);
//
// ((string[])(methods_list["First"]))[0] ->>> "foo"
elem.Click += ?????? How to convert the methods_list["First"][0] to call the foo method ????
objects.Add("First", elem);
ablak.Controls.Add((Control)(objects["First"]));
}

Slater

Re: C# call method from array

Nick Parker3-Aug-04 8:29

Re: C# call method from array

3-Aug-04 8:29

It looks as if you are trying to dynamically call methods. I am giving a presentation tomorrow night at a .NET User Group meeting covering reflection, which is an example of how this can be done. Here is a quick example.

private string[] GetRoles()
{
    MethodInfo mi = typeof(WindowsIdentity).GetMethod("GetRoles",
	   	BindingFlags.Instance | BindingFlags.NonPublic);	   	
    string[] roles = (string[])mi.Invoke(WindowsIdentity.GetCurrent(),null);
    return roles;
}

The MethodInfo class provides a method called Invoke which will allow you to dynamically call your methods. This should get you started.

- Nick Parker
My Blog | My Articles

[HUN]Slater3-Aug-04 23:18

[HUN]Slater

3-Aug-04 23:18

Thx

Thats work

PHP Session value

Alex Getman3-Aug-04 5:55

Alex Getman

3-Aug-04 5:55

Hi Gurus!
I got some php page that put some value into session and I want to ask you if there is any way to get this value in C# win/web application? Or in otherwords could I view somehow what Internet pages put to my session during I'm viewing them?
Thanx.

xedom developers team

Re: PHP Session value

Nick Parker3-Aug-04 8:24