Thanks for your help. That worked great.

Dictionary stringProbe = new Dictionary (); stringProbe[textBox1.Text] = null; ... stringProbe[textBox25.Text] = null; if (stringProbe.ContainsKey(mustBeUniqueTextBox.Text)) { // Text is not unique }else { //Text is unique }

Yes I am using an Access database and I have tried to use Admin as the username but still is not working.

What code are you using? I suspect that you didn't call the Close() method right after you created the file. We can't do much without seeing the actual code you use. But anyways, here's a sample code I use when creating/writing text files: FileStream fs = null; string tmpFile = "C:\\sample.txt"; // Create file and close it so that it can be re-opened for writing further on fs = File.Create(tmpFile, 1024); fs.Close(); // Prepare file for writing by assigning a new textWriter to it TextWriter wr = new StreamWriter(tmpFile); // Write stuff into the file wr.WriteLine("Stuff 1"); wr.WriteLine("Stuff 2"); wr.WriteLine("Blah blah blah......"); // Eventually close the file wr.Close(); Regards, Polis Can you practice what you teach? -- modified at 9:53 Thursday 15th December, 2005

So then the other thing I mentioned is still valid: dispose your connection. The C# using block statement is handy for that: using (OleDbConnection conn = new OleDbConnection("...")) { OleDbCommand cmd = conn.CreateCommand("..."); // ... } This will make sure the connection is closed. If you don't want to close and re-open the connection all the time, defined your OleDbConnection as a field and in your Form's Dispose override call Dispose on your connection field inside the if block (that's where you free mananaged objects; outside the condition - so that it always runs - you free native resources like window and file handles). This posting is provided "AS IS" with no warranties, and confers no rights. Software Design Engineer Developer Division Customer Product-lifecycle Experience Microsoft [My Articles] [My Blog]

Why don't you write a query that doesn't cause the error ? Ideally you should not send duplicate data to the database, but your proc for doing an insert should first check if the unique ID exists, and perhaps if it does, do an update instead. Christian Graus - Microsoft MVP - C++

Did you try using DTSWizard that comes with SQLServer Tools? Vasudevan Deepak Kumar Personal Web: http://www.lavanyadeepak.tk/ I Blog At: http://deepak.blogdrive.com/

Thanks for Replying. Sorry if I wasn't clear. What I want to do is to write the contents of the memory stream to the field Photo2. I used the "?" but it still did not work. I am able to write the contents of the memory stream to a picture box. It is writing to the Photo2 field though because it says "Long binary data" in the Photo2 field. Any ideas

AFAIK there is no class similar to the BindingManagerBase which is resposible for binding datasource to a web control. As I said earlier in the previous post, data binding in web pages is different than it is in windows forms, for example web forms data binding is read-only (one way), so if you want to achieve the same thing in an ASP.NET application, you must provide code to implement the logic, and there is no available data binding layer which is responsible for doing that for you like you see in windows forms. An example I found in the ASP.NET application looks similar to what you want is the paging in a datagrid web control. For example, at a time you can specify to make the grid to display the first 10 records of the datasource, to display the next 10 records you need to specify the new page index and bind the data source again to the control. Perhaps, there is a class which may help you to some extent, it's the PagedDataSource[^] class which basically helps the developer to perform paging on the data source If you are still not clear, can you be more specific about the current context of your ASP.NET application where you want to navigate through items of the data source.

Got it. Thanks a lot.

One thing you can do is compile the JavaScript code as JScript.NET (look at jsc.exe compiler in the DotNet SDK). Once compiled as .NET code, C# code could call the JScript.NET functions without hassle. Tech, life, family, faith: Give me a visit. I'm currently blogging about: He has a funny face. And he's my son. Judah Himango

There is no difference weather you use textbox's or datagrid's. Both are just a method of displaying and editing data. The updating is done by the DataAdapter. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Not enough information. Move what file? Is your application writing it? Are you holding it open? Where does this file come from that your trying to move? The problem is obvious - "being used by another process". This means that you can't move a file that is open for reading and/or writing. So what has the file open? RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

There could be several things wrong, but you need to be more specific about how you're dealing with your splash screen, since it could be implemented in countless different ways. The important thing is that you always modify a control - like change the PictureBox.Image property if that's what you're doing - in the thread on which the control was created. You can do this using the InvokeRequired property and the Invoke method, both of which include an example of using them (they're defined by the Control class and, thus, inheritted by every derivative class). If you're doing this on a timer's event handler (like the System.Windows.Forms.Timer component), than you are doing this in a different thread and the results are undefined. This is, most likely, the problem you're having. Now, if you mean the GIF is animated and your PictureBox isn't animating it, please post some additional code to help us understand how you're using the control. This posting is provided "AS IS" with no warranties, and confers no rights. Software Design Engineer Developer Division Sustained Engineering Microsoft [My Articles]

Thanks for replying. I was able to open the default mail program with that code. I am still not able to insert a pdf as an attachment. I am using crystal reports to generate a report. I then export the report as a pdf file and open the default mail program. I am stuck on how to insert the pdf file that I exported as an attachment file. Thanks for your help.