Posts by Ramy Mahrous

As MS is running and when you run a query it executes it, so the problem from the front-end application!

Don't be angry, I'm not enforced to answer your question!
Then, what about [DllImport] ?
http://www.csharphelp.com/archives/archive52.html

Do you think it's related to MS SQL Server? or do you mean MySQL\Java forum?

And the first too, I didn't mean to use my code as it's!

What about Project->Add reference!!

string[] allData = YourMethodWhichReadFromFile();
foreach (string line in allData)
string[] lineItems = line.Split(' ');
//insert lineItem to database

Depends on how they communicate with each other.

1- Use paging
2- You'll use QueryString which holds row ID, in this page load handler you will fill DataList\GridView\... with data by this ID (Googlize it)

Put ComboBox.Select(); in the form_load event handler.

The same my friend :) I don't underestimate your question I just give you quick way.

Should we understand these lines of codes!!

You're welcome :) I'm happy you solved the problem.

First based on first post you said you can Just Insert\Delete record and that's enough for my algorithm.

I am unsure how to pursue the steps you stated above, as in trying to do so i ended up damaging the add record function in the process.

debug your code and see from where the damage happen.

When you say Put the Data in memory, do you mean in a Temporary File or a Variable.

YES

If you run it against SQL Server or MS Access take this statement and run it there, see if there's error or not.

I hosted my website on server, some pages load data from Analysis services 9.0
It works in development machine.
It doesn't work on deployment machine and through this exception

Exception type: OleDbException
Exception reason: Unspecified error The following system error occurred: The system cannot find the file specified.
Exception source: Microsoft OLE DB Service Components.
Exception stack trace:
The following system error occurred: The system cannot find the file specified. . NewLook Microsoft OLE DB Service Components at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.

I expect deployment machine doesn't have analysis services client components, but I'm not sure!

P.S: both deployment\development machine works on remote server (Analysis services)

Username\password encrypted in .config file, or you can use SQL Server public\private keys 2005 and later

Give us your code, we can't work with prediction!

Friend, see the documentation and play with this method as you need don't expect someone writing code for you. I guided you :)

ADO.NET used to help you do that.
Go to http://www.asp.net and search on ADO.NET

Search on Google "Implementing threads" you'll find a lot of articles, it's very hard to write a new one here, but I prefer you to search.

Did you try System.IO.File.WriteAllText(path, data, encoding) ?? what about the third parameter?

Then, what's the problem?
In ListView IndexChanged event handler

If listView1.SelectedItems.Count > 0
System.Diagnostics.Process.Start(listView1.SelectedItems(0).Text)

P.S: I don't code in VB.NET, if there's any syntax error please try to solve it.

This link http://social.msdn.microsoft.com/Forums/en-US/winformssetup/thread/d30ffbb7-2a50-4d71-9369-7452bb9f9c32/ answers your question

which border? and where is it if it's not inside the form?!!

For sure, they got error: ambiguity error, maybe the two tables have some same columns name, I see the syntax is correct.

What about to debug and go through your code to know in which method has infinite loop or deadlock like Comatose says...

Yes you can but not in the picture you draw in your imagination, through WCF, web services, or even shared database on internet and each of which has its pros\cons.
- Clients should have windows application on machine they work on.
- Windows application won't be on web browser.
- There's no direct interaction.

Please clarify your question, use code tag, and don't use Caps Lock.
I tried to read it but I didn't mange to.

http://www.daniweb.com/forums/thread179020.html

Did you try ComboBox.Focus()

Update = Get data from file -> put data in memory -> delete data from file -> update the data in memory -> insert data into file.

P.S: data may be record or records.

Good, but where is your questions? Just begin and if you faced any problem drop a question after your approaches to solve it.

After your replies I realized that you don't have enough experience in C# and it's not a lack at all, but you need to study well. Microsoft certifications doesn't mean you're expert in the technology you took the certification on. Rather you need to study OOP, OOP design and analysis and how to apply that by .NET technology, develop a lot of different projects and so on... then you won't have any any any barrier to wake up sleeping go to any Microsoft Center to take any exam without looking back to "Test King" or similar....
Best of luck :)

And He should have reputation points as well :)

http://www.microsoftlearning.com where you can find a lot of resources :)

Let me see to learn from you, and if it solved please mark it as solved to be used as reference for people facing this problem. Thanks

Yes

Database scheme contains all create scripts for objects, that's allow you to create the same structure of the database you run this scheme on.
Sample database scheme:

Use Master
Go
Create Database CVz
Go
Use Cvz
Go
Create Table tbl_Cvz1 (
ID int primary key,
Name nvarchar(Max) not null, /* Max supported in 2005 and later versions of SQL Server*/
Mobile nvarchar(15) null
)

Scheme can't hold objects data, i.e table date..

Yes, SQL Server 2005 has better performance over SQL Server 2000, and I think migration to 2005 is essentially.
No problem from your side else remove * and replace it with columns names. Yes it makes sense.

If you create this function through SQL CLR it'd be great, readable code, changes is straightforward, and so on, I don't know really why you didn't reply my post!

My opinion is to remove the initiation of the new thread in the class

Dim ThreadX As New System.Threading.Thread(AddressOf doSomethingElse)
          
          ThreadX.IsBackground = True
          ThreadX.Start()

          While ThreadX.ThreadState <> System.Threading.ThreadState.Aborted AndAlso ThreadX.ThreadState <> System.Threading.ThreadState.Stopped

rather creating this new thread in the class you call DoSomething

1- Dim str As String
2- Dim x As New myClass
3- Dim thrd As new Thread(new ThreadStart(x.DoSomthing)
' Try to modify DoSomthing to be void to work in this wasy
'4- x.closeSomething()

Or you can read more about threading, talk to thread from another, etc.. it may help http://msdn.microsoft.com/en-us/library/system.threading.thread_members.aspx

That's normal because you don't stop the main thread, your process or application in line 3 has 2 threads working in parallel..

Better to ask at ASP.NET forum http://www.daniweb.com/forums/forum18.html
Here's generic C# forum..

Read that http://en.wikipedia.org/wiki/Boyce-Codd_normal_form
And if any part is not understood, tell me to clarify.

It may need full qualified name [DatabaseName].[SchemeName].[FunctionName]

Try that and reply me!

mmm, maybe, but I recommend you to search about how to publish windows application, what are the requirements, and so on....
You're welcome :)

P.S: I remember once a time, I published windows application over network, and it doesn't ask me to connect, more over question the machine you need to publish the application to, has .net framework?

At first, it's not forum for web problems you can post on ASP.NET forum http://www.daniweb.com/forums/forum18.html
Second, remove your try and catch, let the program crashes and give us the error.

If it's windows\web-based application that would be published on a machine on the intra you don't need Internet connection, and vise verse.

I prefer for each forum a man of forum each month, that's would be good idea

Very nice, I'm happy you solved it :) you're more than welcome :)