Ramy Mahrous 401 Postaholic Featured Poster

I don't know if there're some important instruction or not, so read "read me" file or the associated documentation.

Ramy Mahrous 401 Postaholic Featured Poster

Have a look http://msdn.microsoft.com/en-us/library/system.data.sqlserverce.sqlcetransaction.rollback(VS.80).aspx
It may should be defined in IsolationLevel member... I don't know I need to help, wish for you th best..

Ramy Mahrous 401 Postaholic Featured Poster

Add what?? to compile it to Class library (.dll) or executable, use project properties and Control + F5

Ramy Mahrous 401 Postaholic Featured Poster

To get processes you need to work with System.Diagnostics.Process class.
To get currently opened files with MS Word, ect... you need to automate with them, did you try to play with Word from your C# application?

Ramy Mahrous 401 Postaholic Featured Poster

I've attached my draft...if anything not clear reply...

Ramy Mahrous 401 Postaholic Featured Poster

You need to list all files with these extensions (.doc, .xsl, etc...) in a directory? or you need to get opened files in some applications?

Ramy Mahrous 401 Postaholic Featured Poster

Use FileInfo and DirectoryInfo classes would help you.

Ramy Mahrous 401 Postaholic Featured Poster

Not recommended to work with MySQL via OLE libraries, better use MySQL libraries for .net.

Ramy Mahrous 401 Postaholic Featured Poster

Go to mysql.org and install the .net libraries

Ramy Mahrous 401 Postaholic Featured Poster

Is it relevant to vb.net?

Ramy Mahrous 401 Postaholic Featured Poster

Try...

Ramy Mahrous 401 Postaholic Featured Poster

hmmm, default scenario is to encrypt username and password in .config file, and just decrypt them while application is running. you'll just decrypt 1 time.

Ramy Mahrous 401 Postaholic Featured Poster

- Entity-relation diagrams, it's diagram contains your entites (tables in physical design) and their relationship, find more on wikipedia.org
- Dataset represent your database in memory, used in disconnected mode, you can read about it, I gave you the key "disconnected mode"

Ramy Mahrous 401 Postaholic Featured Poster

Attach your entity-relationship diagram and tell us what you need to extract from your database, and what're your tryings??

Ramy Mahrous 401 Postaholic Featured Poster

I don't know much about security but let us discuss
1- we use dynamic IPs, not all ISPs provide static IPs for their client.
2- OK
3- What's user reaction, how you'll handle it??
4- It's default.

I think there're sites manage and secure financial transactions.

Ramy Mahrous 401 Postaholic Featured Poster

I am proud I could solve it to my expert :)

Ramy Mahrous 401 Postaholic Featured Poster

You told me you'll read, after reading come here back and tell me what did you do? you'll say I can use it well :) just try it's very

Ramy Mahrous 401 Postaholic Featured Poster

Mark it as solved to be referenced!

Ramy Mahrous 401 Postaholic Featured Poster

this.Controls.Add(......)

Ramy Mahrous 401 Postaholic Featured Poster

Play with registry... and I assumed it as Windows-based application.

Ramy Mahrous 401 Postaholic Featured Poster

Like you create an array from a simple data type, Get the number of files in the folder, and create the array at runtime.

Ramy Mahrous 401 Postaholic Featured Poster

1- Rename your entites may we can expect the relation and imagine the design....
2- Attach yours to let us help you better.

Ramy Mahrous 401 Postaholic Featured Poster

But test of you've write access on the "C:\", check it.. I recommend such question to be in ASP.NET forum!! what do you see?

Ramy Mahrous 401 Postaholic Featured Poster

int value type.. TextBox reference type you should new it...

ddanbe commented: Arrrghhg! Thanks Ramy I should indeed KNEW it! +4
Ramy Mahrous 401 Postaholic Featured Poster

First of all it's VB.NET forum you should put your question on C# forum.
Get us the code which you delete\update records by.

Ramy Mahrous 401 Postaholic Featured Poster

One of my dreams, is to see this thread solved!!

Ramy Mahrous 401 Postaholic Featured Poster

When I need to get them, I do that

ComboBox1.AutoCompleteMode = System.Windows.Forms.AutoCompleteMode.SuggestAppend
            ComboBox1.AutoCompleteSource = System.Windows.Forms.AutoCompleteSource.AllUrl

I don't know, what done behind the scene, but your question will le me work around this, thanks a lot :)

Ramy Mahrous 401 Postaholic Featured Poster

You need multithreading :) to do that

Ramy Mahrous 401 Postaholic Featured Poster

Use database... there's table (word and meaning)..

Ramy Mahrous 401 Postaholic Featured Poster

Send me your ideas, any draft you did, show me your effort to show you my help.

Ramy Mahrous 401 Postaholic Featured Poster

I know Comatose, but it was my last chance to get him solve his problem!!!

Ramy Mahrous 401 Postaholic Featured Poster

oooh, sorry, really sorry I didn't notice that!!
You can't do such thing :$

Ramy Mahrous 401 Postaholic Featured Poster

In form load event handler tabControl1.SelectedTab = tabControl1.TabPages[1]; it's zero based.

Ramy Mahrous 401 Postaholic Featured Poster

Drag a comboBox and drop it into your form
Edit Comatose's code

For Each skName In rk.GetSubKeyNames()            
sk = rk.OpenSubKey(skName)            
comboBox1.Items.Add(sk.GetValue("DisplayName"))        
Next skName
Ramy Mahrous 401 Postaholic Featured Poster

haa?

pclfw commented: The poster has not properly read either the starting post or the post he is replying to. He is acting very arrogant with this post. Not good at all for the newbies in the forum. -1
Ramy Mahrous 401 Postaholic Featured Poster

Look :)

Use Master
GO
Create proc GetResult
@studentFirstName varchar
AS
SELECT [ID]
      ,[FirstName]
      ,[LastName]
      ,[Grade]
      ,[dt]
  FROM [BlogEngine].[dbo].[Student]
WHERE [FirstName] = @studentFirstName
UNION
SELECT [ID]
      ,[FirstName]
      ,[LastName]
      ,[Grade]
      ,[dt]
  FROM [MaxMinManufacturingDM].[dbo].[Student]
WHERE [FirstName] = @studentFirstName

GetResult 'a'
Ramy Mahrous 401 Postaholic Featured Poster

Look I am not involved with this topic so much, and I see you're not someone come to ask and take an answer rather you want to discuss, so let's start
I see EER: is pretty used in complex database design like if I've inheritance in my tables and so on, generally if my entities is designed in conceptual level, I'll apply this design in RDBMS

I see ORM: the same as above but I take into account I'll apply this design in OODBMS

Ramy Mahrous 401 Postaholic Featured Poster

Try Comatose's code, and tell what you get?

Ramy Mahrous 401 Postaholic Featured Poster

Great!

Ramy Mahrous 401 Postaholic Featured Poster

Take this pesudo code
for each tab page
Just get control either they are TextBox or ComboBox
array[incremented index] <- TextBox -> .Text property
[incremented index] <- [incremented index] +1
array[incremented index] <- ComboBox->. SelectedItem Proprerty

haa? I think it's better than C# code

Ramy Mahrous 401 Postaholic Featured Poster

Yes, It could be, understand the C# code, and if you fail to convert any line of code to VB.NET, drop a reply soon.

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

Did you try Anchor property of the control?

Ramy Mahrous 401 Postaholic Featured Poster

Is ID a string?

Ramy Mahrous 401 Postaholic Featured Poster

Did you hear about Cosmos?

Ramy Mahrous 401 Postaholic Featured Poster

You've to. Better management, new features, greater scalability, I never thought there any companies still work with SQL 7.0
Anyway if you need anything regarding MS SQL Server 2000\2005\2008, drop a thread :)
Best of luck.

Ramy Mahrous 401 Postaholic Featured Poster

Do you've any problem to migrate to MS SQL 2000\2005 or 2008?

Ramy Mahrous 401 Postaholic Featured Poster

Debug!

Ramy Mahrous 401 Postaholic Featured Poster

Maybe... I don't know!

Ramy Mahrous 401 Postaholic Featured Poster

Can you send me your code to examine it myself if there's no problem.