Trying to work out how this pertains to asp.net...... Christian Graus Driven to the arms of OSX by Vista.

If the relations are simple (and a small number), then it's better doing things "by hand", and keep the database separated: 1. Create triggers to enforce what would be foreign keys, and to keep data in sync. 2. Create views to ease SELECTs. Yes, even I am blogging now!

I dont know, I did a search and came up with a lot to do with Excel. But here is the address anyway: www.codeproject.com/csharp/Excel_using_OLEDB.asp

Thanks for your guide. I know how can I catch the exceptions in my codes. Also I know if a column does not belong to a table, I couldn't access the column. But if you read my message again I describe that this error is appeared so rarely. So I couldn't catch it. regards, Mehdi

Easy: It is not a problem. Just alter the Project output path to point to a local drive (c:\nt\myprojects\projectname\bin) or whatever. Otherwise, use a CVS (Perforce, Subversion, whatever) and work with local project data. Cheers Sebastian

Edit the data itself and update the DataGrid. This works different than in ASP.NET because it is different that in ASP.NET. In Windows Forms, it's a control. In ASP.NET, it simply generates different HTML based on state. There's a big difference. Once you've edited the data (like a DataSet, which you should use the DataTable.DefaultView to take into account any re-ordering), you can re-data-bind your control either by setting the DataSource property to null and then back to the DataSet (or whatever), or refresh the CurrencyManager like so: CurrencyManager cm = (CurrentyManager) dataGrid1.BindingContext[dataGrid1.DataSource, dataGrid1.DataMember]; if (cm != null) cm.Refresh(); Microsoft MVP, Visual C# My Articles

Thanks Mazdak, It works correctly.

Doing this via FTP would be difficult - if even possible. About the only way is to poll the folders and check for recent changes. A better way would be to write a program that uses the FileSystemWatcher component to watch the directories on the server (i.e., not via FTP but on the file system itself) and alerts you of changes. -----BEGIN GEEK CODE BLOCK----- Version: 3.21 GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++ -----END GEEK CODE BLOCK-----

You should be using the FileSystemWatcher component instead. It already wraps all the native functionality up in an easy-to-use component. You can configure the FileSystemWatcher to watch for new, changed, or deleted files and it will fire events when what you want to watch occurs (like changed files or directories) with information about what was changed (one tip: the Changed event is fired three times for each change regardless of file size - after lots of research into event the native methods that the FileSystemWatcher wraps, I still can't figure out why - just make sure your code accomodates that). As far as your problem goes, are you actually doing this using C#? INFINITE is actually a pre-proc definition for 0xffffffff (you could declare this as a const in C#) and if you're passing this as a string, the function will most likely use the default timeout. -----BEGIN GEEK CODE BLOCK----- Version: 3.21 GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++ -----END GEEK CODE BLOCK-----

label1.Font = new Font(label1.Font, FontStyle.Bold); or label1.Font = new Font(label1.Font, FontStyle.Italic); Roger Stewart "I Owe, I Owe, it's off to work I go..."

Let me to made some changes in problem. I want to match quoted strings, using \' as an escape to place quotes in the string. Valid strings: 'Alex' 'John\' Burg' '\'' Invalid strings: 'test\' 'not'Valid' Is it possible to define a Regular Expression to this situation? Mehdi

Hi mkomasi, I have'nt tried much on SQL Server. Although, you may like to try http://www.connectionstrings.com/[^] for a variant of ConnectionString that can faciliate connecting to a different port. Alternatively, does OLEDB allow that? A suitable connectionstring should help you there too? Try that URL. Deepak Kumar Vasudevan http://deepak.portland.co.uk/

Mehdi, If you add the code I gave, or the following modified version of it, at the end of the TransferItem method in your previous posting it should work: CurrencyManager cm = BindingContext[ListBoxA.DataSource] as CurrencyManager; if (cm != null) cm.Refresh(); cm = BindingContext[ListBoxB.DataSource] as CurrencyManager; if (cm != null) cm.Refresh(); Chris Jobson

There is a weird problem with Windows Installer on Win 2K which makes the icon not appear correctly if the Installation is per-user. Microsoft's work-around is to make the installation per-machine (ALLUSERS=1), but that's not always a perfect solution. It's a trade-off, you have to decide how important your icon is compared to per-user installation. I was lucky, we actually needed per-machine installs in the end anyway. Paul We all will feed the worms and trees So don't be shy - Queens of the Stone Age, Mosquito Song

mkomasi wrote: OleDbCommandBuilder custCB = new OleDbCommandBuilder(myDataAdapter); myDataAdapter.SelectCommand.CommandText = "Select * from Customers"; myDataAdapter.Fill(custDS, "Customers"); myDataAdapter.SelectCommand.CommandText = "Select * from Orders"; myDataAdapter.Fill(custDS, "Orders"); myDataAdapter.SelectCommand.CommandText = "Select * from Products"; myDataAdapter.Fill(custDS, "Products"); You need to run the COmmandBuilder each time after you change your "select" statement. But then u have a problem with the Update (you will have to do the whole thing again). I recommend setting up a dataadapter for each table. MyDUMeter: a .NET DUMeter clone