Ramy Mahrous 401 Postaholic Featured Poster

Did you try to googlize that?

Ramy Mahrous 401 Postaholic Featured Poster

To develop his one :)

Ramy Mahrous 401 Postaholic Featured Poster

Search in this forum, you'll find a lot of threads discussing the same idea tell me what you reached and let's discuss...

Ramy Mahrous 401 Postaholic Featured Poster

You should know OOP principles well. then come to the question Java or C#?. C# or Java?, you can spend all your life with people fighting to reach what the best. It's up to you. What you need to work with Microsoft technology (VS, WCF, WF, C#, Windows, SQL Server etc..) or Non-Microsoft technology??

Ramy Mahrous 401 Postaholic Featured Poster

Dear friend!!! you don't read what I wrote well! that's cost me to write the same thing more over!
I know your problem and my previous answers would solve it.
Create .setting file and add ConnectionString with proper value..

static OleDbConnection dbConnection = new OleDbConnection(Properties.Settings.Default.ConnectionString);

So, what you need to deploy it on company machine is to change the value of ConnectionString in the .setting file

Ramy Mahrous 401 Postaholic Featured Poster

It works with me! but try to debug, that's the one who you can fully trust in.

Ramy Mahrous 401 Postaholic Featured Poster

My solution is to keep your database location isolated from source code, wherever your database moved to, you just will open the .config file edit the connection string in your case (@"Provider=Microsoft.Jet.OLEDB.4.0; .....) without modifying the program code (C# code)!
Now is it understood?!!

Ramy Mahrous 401 Postaholic Featured Poster

OK. To close the Child window

Me.ActiveMdiChild().Close()
Ramy Mahrous 401 Postaholic Featured Poster

:O tell you what?, Didn't you tell that you did it and need to know how to close the child form?? or you didn't do it at all!!!!!

Ramy Mahrous 401 Postaholic Featured Poster

Are you working using MDI technique? or just you open form from another??

Ramy Mahrous 401 Postaholic Featured Poster

Put this connection string in .config file, and replace it whenever you need wherever database in.

Ramy Mahrous 401 Postaholic Featured Poster

In memory heap if it's reference type e.g (eobject from class), in memory stack if it's value type e.g (object from struct)

Ramy Mahrous 401 Postaholic Featured Poster

Get the (ACTIVE CHILD form instance).Close

Ramy Mahrous 401 Postaholic Featured Poster

No, I need you to try using it, I could tell you some code and your problem been solved! but I need you to try to learn. Please try

Ramy Mahrous 401 Postaholic Featured Poster

I want to share this Parallel Object Oriented by C# paper with you
http://www.di.uminho.pt/~jls/PaCT2005c.pdf

Ramy Mahrous 401 Postaholic Featured Poster

OK, in case you show me your effort to do that ...

Ramy Mahrous 401 Postaholic Featured Poster

ASP.NET forum is better for such questions that's relevant to Web-based application using .net technology..

Ramy Mahrous 401 Postaholic Featured Poster

Handle Textbox textchanged eventhandler! and set your code there...

Ramy Mahrous 401 Postaholic Featured Poster

Very easy...
Project->Add Reference->COM
tab and look for the Microsoft Word X.x Object Library
Use ApplicationClass class. Enjoy...

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

Simply your application on a machine and your database on another, the 2 machines connected together....

Ramy Mahrous 401 Postaholic Featured Poster

So, tell me your problem, what you did and what you got?

Ramy Mahrous 401 Postaholic Featured Poster

To connect to SQL Server by C# application you need to use ADO.NET libraries

Ramy Mahrous 401 Postaholic Featured Poster

If it's relevant to web, you can shot your question in ASP.NET forum

Ramy Mahrous 401 Postaholic Featured Poster

Give me sample row in the text file and table structure (columns and datatypes)

Ramy Mahrous 401 Postaholic Featured Poster

Great and also don't forget to mark it as solved!

Ramy Mahrous 401 Postaholic Featured Poster

Look to deploy it as windows service, should be also installed as administrator! then it'll work without any interaction with the current user.

Ramy Mahrous 401 Postaholic Featured Poster

Logical, non administrative staff can't read this information! right? so if your user is administrator he can do what we've done -> right click on your application and run it as administrator.

Ramy Mahrous 401 Postaholic Featured Poster

There is Reporting tab in Toolbox, use it :)

Ramy Mahrous 401 Postaholic Featured Poster

Right click on VS icon, and run it as administrator.

Ramy Mahrous 401 Postaholic Featured Poster

1- Please when embedding code, use code tags to make yout code readable

Dim result As Decimal
        result = Decimal.Divide(Decimal.Parse(TextBox1.Text), Decimal.Parse(TextBox2.Text))
        result = FormatNumber(result, 2, TriState.False)
        Label1.Text = String.Format("the result = {0} ", result)
Comatose commented: Nice Code And Replies +8
Ramy Mahrous 401 Postaholic Featured Poster

Just! did you try it?? :)

Ramy Mahrous 401 Postaholic Featured Poster

Please format your code to be able to read it...

Ramy Mahrous 401 Postaholic Featured Poster

Try to run your application as administrator, right click on your executable then Run as Administrator, try and tell me what you get.

Ramy Mahrous 401 Postaholic Featured Poster

hmmmm. What I need from you is to read in ltrim, rtrim, charindex functions in T-SQL, and have a look on the script again.

Ramy Mahrous 401 Postaholic Featured Poster

If you're sure everything is well, try to re-install the .net framework!

Ramy Mahrous 401 Postaholic Featured Poster

You just read in Mail!! I need to from you to read in all classes in the namespace iff you need to learn, but if you want to develop it regardless learning you can search on this type of application and you'll find a lot.

Ramy Mahrous 401 Postaholic Featured Poster

Read in System.Net classes it may help you, and tell me where you reached...

Ramy Mahrous 401 Postaholic Featured Poster

You can use some containers and play with them, to show one and hide others.

Ramy Mahrous 401 Postaholic Featured Poster

The problem I don't treat with GridViews, so wait you'll find someone helps you or try to search in msdn or googlize your problem.

Ramy Mahrous 401 Postaholic Featured Poster

Eyo, so don't create similar thread, of if you need you've to re-post your question\errors\problems...

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

Try to move your thread to C# or VB.NET forum.

Ramy Mahrous 401 Postaholic Featured Poster

You create 1 solution holds your 2 project (exe and dll)
From your (exe) project add reference to your dll project then press Ctr + F5

Ramy Mahrous 401 Postaholic Featured Poster

Did you try SELECT * FROM [ea] WHERE ([ea_name] LIKE '%' + @ea_name2 + '%' or [ea_name] is null) ??

Ramy Mahrous 401 Postaholic Featured Poster

Excuse me!

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

I searched I found this Function

CREATE FUNCTION dbo.Split
(
	@RowData nvarchar(2000),
	@SplitOn nvarchar(5)
)  
RETURNS @RtnValue table 
(
	Id int identity(1,1),
	Data nvarchar(100)
) 
AS  
BEGIN 
	Declare @Cnt int
	Set @Cnt = 1

	While (Charindex(@SplitOn,@RowData)>0)
	Begin
		Insert Into @RtnValue (data)
		Select 
			Data = ltrim(rtrim(Substring(@RowData,1,Charindex(@SplitOn,@RowData)-1)))

		Set @RowData = Substring(@RowData,Charindex(@SplitOn,@RowData)+1,len(@RowData))
		Set @Cnt = @Cnt + 1
	End
	
	Insert Into @RtnValue (data)
	Select Data = ltrim(rtrim(@RowData))

	Return
END

It returns table each row represents the string after the split
So select * from dbo.Split(N'ramy,abdalla,mahrous', N',') returns
ID Data
1 ramy
2 abdallah
3 mahrous

I got it from http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50648

Ramy Mahrous 401 Postaholic Featured Poster

It's not SystemFileWatcher class it's FileInfo class, show us your effort as said!

Ramy Mahrous 401 Postaholic Featured Poster

Tell me sample data and illustrate what you need to get from them