|
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
|
|
|
|
|
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!
|
|
|
|
|
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?
|
|
|
|
|
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.
"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!
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
No this is not my first c# program
first database though
yes its for university. but i only need some advice.
|
|
|
|
|
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
|
|
|
|
|
Miles Roberts wrote:
Can anyone help me create a Dental database system for recording patients records
Pay me and I can do it for !  ;);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
|
|
|
|
|
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
|
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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))
{
}
- Nick Parker
My Blog | My Articles
|
|
|
|
|
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
**************************
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
|
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
|
|
|
|
|
Alex Getman (leTaon) wrote:
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?
The most practical means would be to persist the values from your PHP session to a database or XML file and then read the values back into a Hashtable within your C# application.
- Nick Parker
My Blog | My Articles
|
|
|
|
|
Hi!
What I would like to do is code a form that has semi-transparent image as background and rounded corners, also some controls on it.
I tried a sample, per-pixel alpha, i think, but it doesn't allow you to add any other controls to the form
I really need such sample code, quickly.
Thanks in advance
|
|
|
|
|
|
leppie wrote:
just click search
Be careful, someone it apt to claim they didn't get the results they wanted by simply clicking 'search'. 
- Nick Parker
My Blog | My Articles
|
|
|
|
|
Hi there..
I have a question concerning the dotNet garbage collector. I have a Singleton class, whose static instance is available till i recompile it explicitly.
Example:
public class Test
{
private static Test instance;
private Test()
{
Dosomething();
}
// Returns the singleton instance of that class
public static Test Singleton()
{
if (instance == null)
instance = new Test();
return instance;
}
}
First time calling "Singleton()" everthing works fine (->Dosomething() will be called).
Then, i terminate the application and start it again, but "Singleton()" still returns the old "instance" object!
I have to recompile the class "Test" to remove the "instance" object.
Is this a known error? Or a feature? 
Greetings,
Philip
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
