Ramy Mahrous 401 Postaholic Featured Poster

Yes, preferable, and we're here to help you about anything you face, really I appreciate this word from you

sounds like I need to learn

, please mark it solved.

Ramy Mahrous 401 Postaholic Featured Poster

I don't know but, did you try to send the menu to back or bring the new document to front?

Ramy Mahrous 401 Postaholic Featured Poster

As there are many users updating database, you need reflect dataset changes to the database once occurred. So you need to reflect\load and it's not good in performance perspective, so use Connected Mode, it's better in such cases.

Ramy Mahrous 401 Postaholic Featured Poster

Without writing single line of code!

Ramy Mahrous 401 Postaholic Featured Poster

Just select a background color for th GroupBox, then in form properties say that color you selected is Transparent from Form properties
Transparent Key = ?
Example
If you select Red as GroupBox background
Transparent Key = Red

Ramy Mahrous 401 Postaholic Featured Poster

loool this thread was on April :) but I don't understand your problem. Clarify please :)

Ramy Mahrous 401 Postaholic Featured Poster

Give me the keys you want to get and it's properties in that way
Exmaple
Key: HKEY_LOCAL_MACHINE\HARDWARE\DESCRIPTION\System\CentralProcessor\0
Property: ProcessorStringName

Don't worry, just show me you want to learn

Ramy Mahrous 401 Postaholic Featured Poster

Put your key in array
Dim key As String(numberOfKeys)

sorry I've mistake in this instead Dim Keys(numberOfKeys) As string

Ramy Mahrous 401 Postaholic Featured Poster

My first answer is concept :) not for special case, once you load the database tables into your dataset, forget the physical database, and when you add entry to the primary table, you add it into dataset, so get the last entry key from the main table by anyway from dataset, then use it to add entries in child tables, and when you finish your work on the dataset, reflect that changes.

Ramy Mahrous 401 Postaholic Featured Poster

Put your key in array Dim key As String(numberOfKeys) then loop and once you get value put it into ComboBox or any control you present data into

Dim registrykeys(5) As String
'fill your keys
        For Each key As String In registrykeys
            ComboBox1.Items.Add(My.Computer.Registry.GetValue(key, "property", "default"))
        Next

Your array may be 2D to maintain the property of keys

Ramy Mahrous 401 Postaholic Featured Poster

You can achieve that in various ways
1- Managed C++ within your solution.(in case you've some developers need to write their code in managed C++)
2- Add reference to library aka .dll (developed with managed C++)

Ramy Mahrous 401 Postaholic Featured Poster

Yes, and I think that's the way .eml file works, try to look into scheme to know how to attach multiple files, but don't walk in string compression algorithms, it'd talk a lot of time without proper effect.

Ramy Mahrous 401 Postaholic Featured Poster

Look, it works from Master database, and give me the SQL script and the error you get when you run it

Ramy Mahrous 401 Postaholic Featured Poster

So, what do you need?? Do you face network problem? or you survey our opinion :D?

Ramy Mahrous 401 Postaholic Featured Poster

Why you use this??

Do you use SMTPClient class? to send un\attached mails

Ramy Mahrous 401 Postaholic Featured Poster

Have a look on http://bytes.com/groups/net-xml/178906-change-node-attribute-value
You can googlize it also, I did that :)

Ramy Mahrous 401 Postaholic Featured Poster

What's the difference to run C# code on Windows Server 2003 and XP, Vista or even Windows 7?
All is one, Just read in DirectoryInfo and FileInfo classes part from System.IO namespace.
If you search in this forum you'll find a similar thread too.

Ramy Mahrous 401 Postaholic Featured Poster

As you like, but I used MS SQL Server 2000

Ramy Mahrous 401 Postaholic Featured Poster

1- I can't explain it better than MSDN http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommandbuilder.aspx

2- System.Net.Mail.SmtpClient would help you.

Ramy Mahrous 401 Postaholic Featured Poster

Multiuser phone book, it's nice :) I developed it when I was C# beginner.

Ramy Mahrous 401 Postaholic Featured Poster

Look when you treat with dataset you treat with database (I don't know if you've to set Enforce relationship property to true or it's set by default) so you can update it then reflect these changes to the physical database.

Ramy Mahrous 401 Postaholic Featured Poster

What the problem?

Ramy Mahrous 401 Postaholic Featured Poster

After the last "." get the string is after
you may have file, its name readme.program.user.txt!!
It's the time to play with string class, you can also use regular expression and you can use FileInfo.

Ramy Mahrous 401 Postaholic Featured Poster

You can use string class to fetch the extension from its name or you can use FileInfo class.

Ramy Mahrous 401 Postaholic Featured Poster

Because the main thread doesn't terminated. You just hide the main form, I think you close application from staff form, right?
so, in its close event add this Application.Exit

Ramy Mahrous 401 Postaholic Featured Poster

Dear, if you've time to read I can send you a book about Data warehouse.
About your questions
Say we've business man who has super market with a lot of branches...
The business man interested to know net profit by year\region\product\sales persons
Fact table: is th point of interest the decision maker needs to know (simple business definition about it)
Fact table: net profit
Dimension table: the categorization used to spread out an aggregate measure aka fact (net profit) to reveal its constituent parts.
Dimensions tables: Year, Region, Product and Sales persons.

Send me email @ <EMAIL SNIPPED> if you need a book regarding this.

Ramy Mahrous 401 Postaholic Featured Poster

Yes, I tried it, did you?

Ramy Mahrous 401 Postaholic Featured Poster

and??

Ramy Mahrous 401 Postaholic Featured Poster

System.Diagnostics

Ramy Mahrous 401 Postaholic Featured Poster

With pleasure ProcessStartInfo commandPromptProcess = new ProcessStartInfo("cmd.exe"); Find out how to make use of this.

Ramy Mahrous 401 Postaholic Featured Poster

I think there no method to do so, you can use DOS commands and call\send parameters to them from C# application.

Ramy Mahrous 401 Postaholic Featured Poster
Ramy Mahrous 401 Postaholic Featured Poster

neither... nor ... represents some table(s) and their relationships in memory it may contain 1 or more tables.

Ramy Mahrous 401 Postaholic Featured Poster

You can make it directly from DataSet, also read in DataSet class
DataSetObject. ??
The idea I don't mean to be silly with you, but you've to try and read in help more than copying code, I hope you understand me well.

Ramy Mahrous 401 Postaholic Featured Poster

Yes, check auto number column properties. but I also prefer to do the generator on your application side.

Ramy Mahrous 401 Postaholic Featured Poster

You can check if the Command Object's Text value has (Select, Insert, Update or Delete) ? using string operations ? I don't know how to use Cci !! Did you try googlize it?

Ramy Mahrous 401 Postaholic Featured Poster

We don't give code!! which made you able to make them separately, let's you do this task.

Ramy Mahrous 401 Postaholic Featured Poster

After assign ComboBox your datasource (your department table) navigate in ComboBox properties you'll find which help you doing your task.

Ramy Mahrous 401 Postaholic Featured Poster

sorry??!

Ramy Mahrous 401 Postaholic Featured Poster

So, relation is One-To-Many
One Question has many Answers and Answer has many Comments
So...
Question(QID, QSubject, QText,....)
Answer(AID, QID, AText,......)
Comment(CID, AID, CText,.....)

haa?

Ramy Mahrous 401 Postaholic Featured Poster

Close this thread, I think you open similar one and it's solved!

Ramy Mahrous 401 Postaholic Featured Poster

Mark it as solved, to be used as reference later.

Ramy Mahrous 401 Postaholic Featured Poster

It's not the place friend :) go to VB forum and ask there.

Ramy Mahrous 401 Postaholic Featured Poster

In your case don't use [auto number] rather generate it yourself in your front end application.

Ramy Mahrous 401 Postaholic Featured Poster
Ramy Mahrous 401 Postaholic Featured Poster

If you need me to work with you it's much appreciated from you, unemployed state feels me sadness :)

Ramy Mahrous 401 Postaholic Featured Poster
Ramy Mahrous 401 Postaholic Featured Poster
Ramy Mahrous 401 Postaholic Featured Poster

What's your Office SDK version?

Ramy Mahrous 401 Postaholic Featured Poster
Dim numbers As List(Of Int32)
while(numbers.Count > 100)
{
if Not numbers.Contains(GetRandomNumber()) 
numbers.Add(GetRandomNumber())
}