|
I don't think there is a quick answer to your question, but I'd be willing to dialog with you about it for a while and share with you my techniques dealing with normalized databases. Beware though, I don't use a lot of what ADO.NET provides--instead, I tend to code client or server side SQL directly, depending on the requirements.
That said, it seems that ADO.NET can handle relationships between tables, as long as you tell it what those relationships are, and it should handle updating records correctly (I think. I've never tried this). [personal comment--I've never used this feature because I think it is really stupid to duplicate the database model in the code: what if you want to change the DB model?]
Also, have you set up foreign keys so that deletes and updates are cascaded? This can save you a lot of programming time.
Also, if you can provide some specific examples of what you are trying to do, it might be easier to consider what the different solutions are and their benefits/drawbacks.
Finally, hierarchical architectures are a PITA. Since you seem to only have a three level hierarchy, I think the best thing to do is to deal with the individual insert/update/delete/select statements. I had to create a model for a satellite company once that allowed basically infinite drill down in a hierarchy. Argh.
Marc
Help! I'm an AI running around in someone's f*cked up universe simulator.
|
|
|
|
|
How can Create a binary registry entry (Binary Value) to save a login or access password?
Jassim Rahma
|
|
|
|
|
Your problem is writing to registry or you have problem to change password to binary value?
If your problem is first one,search this site,you can find an article about it.If it is second one you can write a function that get password string and return it like this:
public static byte[] EncryptPassword(string password)
{
UnicodeEncoding encoding = new UnicodeEncoding();
byte[] hashBytes = encoding.GetBytes( password );
SHA1 sha1 = new SHA1CryptoServiceProvider();
byte[] cryptPassword = sha1.ComputeHash ( hashBytes );
return cryptPassword;
}
Mazy
"And the carpet needs a haircut, and the spotlight looks like a prison break
And the telephone's out of cigarettes, and the balcony is on the make
And the piano has been drinking, the piano has been drinking...not me...not me-Tom Waits
|
|
|
|
|
How can I create my own binary database file just like MS access? I need to use my own extension (e.g. *.mod - my own database)?
Jassim Rahma
|
|
|
|
|
Hey Jassim Rahma,
Check out this site:
http://www.c-sharpcorner.com/database/SharpHSQL.asp
It is a database implementation in C#. Perhaps this should give you some idea.
Deepak Kumar Vasudevan
Deepak Kumar Vasudevan
http://deepak.portland.co.uk/
|
|
|
|
|
How can I:
1. Create a DLL which contains WMA files called 01.wma, 02.wma, etc. So DLL files will be indivisually 01.dll, 02, dll, etc.
2. Read the audio file from the DLL file and play it without creating a temporary WMA file on the local machine.
Jassim Rahma
|
|
|
|
|
|
How can I change the keyboard language between Arabic and English? I need to force the textBox to write Arabic for textBox1 and English for textBox2 even if the user tried to change the language?
|
|
|
|
|
I think InputLanguage class is what you need. I think when these controls are focused,you can use this class to set the language.
Mazy
"And the carpet needs a haircut, and the spotlight looks like a prison break
And the telephone's out of cigarettes, and the balcony is on the make
And the piano has been drinking, the piano has been drinking...not me...not me-Tom Waits
|
|
|
|
|
I need to send an output text to a specific line on the printer because I have a fixed template and I have to use it. How can tell C# to print to x, y on the paper from a textBox on my form?
Many Thanks,
Jassim Rahma
|
|
|
|
|
Hi all
I dont wanna learn regex, but some is bound to have done this already.
I need to replace all ' 's with " 's that is between tags < >. I dont even know how to work the Regex class, help on that would be appreciated too.
Cheers 
"I dont have a life, I have a program." Also, I won't support any software without the LeppieRules variable.
|
|
|
|
|
Well you scratched my back before leppie, so....
<br />
<br />
<br />
string s= @"<here is='a little' bit='of'>xml</here>";<br />
Regex rx=new Regex(<br />
@"(?<tag><)((?<prequote>.*?)')+(?<tag>[^']*?>)",<br />
RegexOptions.Compiled|RegexOptions.ExplicitCapture|RegexOptions.Singleline);<br />
string results=rx.Replace(s,new MatchEvaluator(this.tagEvaluator));<br />
Console.WriteLine(results);<br />
<br />
<br />
string tagEvaluator(Match m) {<br />
string r=m.Groups["tag"].Captures[0].Value;<br />
for (int i=0; i< m.Groups["prequote"].Captures.Count;i++) {<br />
r+= m.Groups["prequote"].Captures[i].Value + "\"";<br />
}<br />
return r + m.Groups["tag"].Captures[1].Value;<br />
}<br />
<br />
"Outside of a dog, a book is Man’s best friend. And inside of a dog, it’s too dark to read."
-Groucho Marx
|
|
|
|
|
So here it is with codeproject.com formatting:
string s= @"<here is="a little" bit="of">xml";
Regex rx=new Regex(
@"(?<tag><)((?<prequote>.*?)')+(?<tag>[^']*?>)",
RegexOptions.Compiled|RegexOptions.ExplicitCapture|RegexOptions.Singleline);
string results=rx.Replace(s,new MatchEvaluator(this.tagEvaluator));
Console.WriteLine(results);
string tagEvaluator(Match m) {
string r=m.Groups["tag"].Captures[0].Value;
for (int i=0; i< m.Groups["prequote"].Captures.Count;i++) {
r+= m.Groups["prequote"].Captures[i].Value + "\"";
}
return r + m.Groups["tag"].Captures[1].Value;
}
"Outside of a dog, a book is Man’s best friend. And inside of a dog, it’s too dark to read."
-Groucho Marx
|
|
|
|
|
I'm just going to email you dude. my xml is dissapearing on this message board.
"Outside of a dog, a book is Man’s best friend. And inside of a dog, it’s too dark to read."
-Groucho Marx
|
|
|
|
|
Bog wrote:
I'm just going to email you dude. my xml is dissapearing on this message board.
 I hate that too! Thanx
"I dont have a life, I have a program." Also, I won't support any software without the LeppieRules variable.
|
|
|
|
|
Could someone tell me how to fire off a menu item click event from a UserControl. The menu is contained in the UserControls parent form.
Thanks,
Paul
|
|
|
|
|
if you have for instance a menuFileOpen_Click method for you file open on your menu and you wanted to use it for an open button you would just assign it to the buttons cick handler.
btnOpen_Click()
{
menuFileOpen_Click();
}
I hope that is what you ment.
|
|
|
|
|
I want to use DirectoryEntry class for my IIS.Both I have a problem in giving connection string to it.
In msdn said:
"LDAP://" or "IIS://" + path
But I don't know which pah I should give.Any suggestion?
Mazy
"And the carpet needs a haircut, and the spotlight looks like a prison break
And the telephone's out of cigarettes, and the balcony is on the make
And the piano has been drinking, the piano has been drinking...not me...not me-Tom Waits
|
|
|
|
|
Mazdak wrote:
want to use DirectoryEntry class for my IIS.Both I have a problem in giving connection string to it.
In msdn said:
"LDAP://" or "IIS://" + path
But I don't know which pah I should give.Any suggestion?
Quoted from MSDN:
The Path property uniquely identifies this entry in a networked environment. This entry can always be retrieved using this Path.
Setting the Path retrieves a new entry from the directory store; it does not change the path of the currently bound entry.
The classes associated with the DirectoryEntry component can be used with any of the Active Directory service providers. Some of the current providers are Internet Information Services (IIS), Lightweight Directory Access Protocol (LDAP), Novell NetWare Directory Service (NDS), and WinNT.
Note The portion of the Path that identifies the provider (precedes "://") is case sensitive. For example, "LDAP://" or "WinNT://".
The syntax for the Path property varies according to the provider. Some common scenarios are:
WinNT
Connect to a group on a computer. For example, "WinNT:// domain/ computer/ group ". If you are connecting to a local computer, "WinNT:// computer/ group ".
Connect to a user on a computer. For example, "WinNT:// domain/ computer/ user ". If you are connecting to a local computer, "WinNT:// computer/ user ".
Connect to services on a computer. For example, "WinNT:// domain/ computer/ service ". If you are connecting to a local computer, "WinNT:// computer/ service ".
Discover all domains on the network. For example, "WinNT:". The domains can be found by enumerating the children of this entry.
LDAP
Connect to a group in a domain. For example, "LDAP://CN= group-name, CN=Users, DC= domain-controller1, DC= domain-controller2,... ".
Connect to a user in a domain. For example, "LDAP://CN= full-user-name, CN=Users, DC= domain-controller1, DC= domain-controller2,...".
Connect to computers in a domain. For example, "LDAP://CN= computer-name, CN=Computers, DC= domain-controller1, DC= domain-controller2,...".
IIS
Connect to a Web directory. For example, "IIS://LocalHost/W3SVC/1/ROOT/ web-directory-name ".
"I dont have a life, I have a program." Also, I won't support any software without the LeppieRules variable.
|
|
|
|
|
Thank you very much.
Mazy
"And the carpet needs a haircut, and the spotlight looks like a prison break
And the telephone's out of cigarettes, and the balcony is on the make
And the piano has been drinking, the piano has been drinking...not me...not me-Tom Waits
|
|
|
|
|
When I do this to one of my projects
using System.Messaging;
I get the following error :
The type or namespace name 'Messaging' does not exist in the class or namespace 'System' (are you missing an assembly reference?)
What the heck is wrong with this picture ?
I am actually missing the namespace ?????
It's all over in the help system. It can't be missing!
Can someone please help me out ?
tia,
Pilgrim
|
|
|
|
|
You need to reference the assembly containing the System.Messaging namespace, in this case "System.Messaging.dll".
In VS.NET, right click on the "References" entry for that project and choose Add Reference. On the command line add "/r:System.Messageing.dll"
James
- out of order -
|
|
|
|
|
Hey Pilgrim,
Did u add reference to System.Messaging.dll from VS.NET Solution Explorer?
deepak
Deepak Kumar Vasudevan
http://deepak.portland.co.uk/
|
|
|
|
|
Hi all,
Is there a way to keep the same form (title bar, menus, etc.) but dynamically change the client area and event handlers? You know, like the MFC CView class.
I would like to have a SDI application that changes the view based on a menu selection. Do I have to create a different forms for the different views, but add the same title & menu?   
|
|
|
|
|
What about using Forms inheritance?
Then just expose additional methods/properties to handle the delegates.
Cheers,
Simon
"From now on, if rogue states want to buy weapons of mass destruction, they're going to have to go on eBay," Mr. Bezos said.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
