The easiest thing to do is do DR("StatusName").ToString(). This will automatically convert any nulls to String.Empty Torin Blair - MCSD.NET
'In the immortal words of Socrates - "I drank what?".'

You probably are specifying a Max Connections for your connection string, OR you have a maximum connections set in your database. Ask your DBA to increase the max number of connections. Torin Blair - MCAD
'In the immortal words of Socrates - "I drank what?".'

Threading is my weak spot, so I'll give you a potential different path. You could use Process.Start instead. Place the logic for sending the emails in a separate exe on your server. Have this exe pull the data for the emails from a data store of some sort, and then run the exe with Process.Start. (The default setting for Start is to kick it off without you waiting for it to return results.) Torin Blair - MCP
'In the immortal words of Socrates - "I drank what?".'

Web services don't really support overloading. You can implement both methods with the same name, but you will need to have different names for the WebMethod. So you could have [WebMethod(MessageName="AddInt")] public int Add(int op1, int op2) {} [WebMethod(MessageName="AddDouble")] public double Add(double op1, double op2){} To the outside world there will be two different methods. That is the closest you can come to overloading with Web Services. (Hopefully someday it will be different.) Torin Blair - MCP
'In the immortal words of Socrates - "I drank what?".'

That is correct, without strongly typed datasets you should add this line right before you call myAdapter.Fill. myAdapter.FillSchema(ds, SchemaType.Source, "MyTable"); Torin Blair
'In the immortal words of Socrates - "I drank what?".'

I don't know the structure of your tables so I can't write any of the sql statements. Torin Blair
'In the immortal words of Socrates - "I drank what?".'

I can't think of anything else. It is true that you need these additional things if you aren't using a strongly typed dataset. But that should be it. Torin Blair
'In the immortal words of Socrates - "I drank what?".'

If you drag a data adapter to a form, then it will open a wizard for you. No worries you can do this the manual way. OleDbCommand cmdUpdate = new OleDbCommand(_SQLCOMMAND_); OleDbCommand cmdInsert = new OleDbCommand(_SQLCOMMAND_); myAdapter.UpdateCommand = cmdUpdate; myAdapter.InsertCommand = cmdInsert; And that's how it's done. For a more detailed explanation you can look at the .NET sdk documentation or this example from csharpcorner. http://www.csharpfriends.com/Articles/getArticle.aspx?articleID=103[^] Torin Blair
'In the immortal words of Socrates - "I drank what?".'

In order for you to be able to update or insert from your dataadapter, you need to specify an insert SQL statement in the OleDbDataAdapter.InsertCommand, and an update SQL statement in the OleDbDataAdapter.UpdateCommand. If you used the wizard to create your adapter, you probably already have these statements. In debug, or by writing out to a label on the screen, you should output both of these properties and see if their SQL Syntax is correct. This will allow you see the sql commands you are using with the database. These strings are probably also listed in the WinForms or WebForms generated code if you are using Visual Studio .NET Torin Blair
'In the immortal words of Socrates - "I drank what?".'

You might look at this example of using streams from the quickstart tutorials. http://samples.gotdotnet.com/quickstart/util/srcview.aspx?path=%2fquickstart%2fwinforms%2fSamples%2fGDIPlus%2fImages%2fImages.src[^] Torin Blair
'In the immortal words of Socrates - "I drank what?".'

What is the syntax for your myAdapter.UpdateCommand and myAdapter.InsertCommand? Torin Blair
'In the immortal words of Socrates - "I drank what?".'

FTP has very little capability built into it. You won't be able to execute anything other than a file transfer or directory listing using it. You'll need to write a proc on the server to save a snapshot out of the database to a file. Then you'll need to write a set of code that does a put to the FTP site. If you are looking to code part of this in .net you can look into the FTP library from edt http://www.enterprisedt.com/downloads/csftp/csftp.html[^] Hope that at least points you in the right direction. Torin Blair
'In the immortal words of Socrates - "I drank what?".'

Have you tried Running a Query from enterprise manager on the table? You can get only the row or rows you need and then update from the results pane in the Query builder. Torin Blair
'In the immortal words of Socrates - "I drank what?".'

I don't think Visual Studio .NET provides intellisense for COM, so it won't work for VBScript. Editors such as PrimalScript from sapien software provide great intellisense for VBScript, you might look into that if you need it. Torin Blair
'In the immortal words of Socrates - "I drank what?".'

Hmmm... sounds like your Event Wiring is not set up right. Look at the InitializeComponent() method (you'll need to toggle the Web Form generated code region). It should have something that looks like this in it (if you are using C#) this.DropDownList1.SelectedIndexChanged += new System.EventHandler(this.DropDownList1_SelectedIndexChanged); if you are using VB, I believe there should be a "Handles DropDownList1.SelectedIndexChanged" on the end of the selectedIndexChange method. If it doesn't, then try double clicking on the control from your web form again and see if the delegate or handler shows up. If you have a delegate (C#) or a handler (VB) and it still doesn't work, you might check your IE settings to verify that scripting is enabled. Hope that helps. Torin Blair
'In the immortal words of Socrates - "I drank what?".'

Since this is an unhandled error in your application, I would recommend starting out by writing code into the Application_Error method of the Global.asax. In the Application_Error method, discover what the error is. Write out some diagnostic information to a file, and then the next time the error occurs you can look at the log file to see what happened. Torin Blair
'In the immortal words of Socrates - "I drank what?".'

make a datagrid EditItem method from the Properties window of the datagrid. (Use the lightning bolt icon at the top to get to the methods.) In this method do this (Don't quote me on the signature, I don't know it off the top of my head.) private void dg_EditCommand(object source, DataGridCommandEventArgs e) { dg.EditItemIndex = e.Item.ItemIndex; dg.DataBind(); } And then for your cancel use. private void dg_CancelCommand(object source, DataGridCommandEventArgs e) { dg.EditItemIndex = -1; dg.DataBind(); } Torin Blair
'In the immortal words of Socrates - "I drank what?".'

Nope... you need to control the user's browser so this can only be done on the client side. Take a look at this javascript. http://forums.devshed.com/t53270/s.html[^] Torin Blair
'In the immortal words of Socrates - "I drank what?".'

This is not an entirely straightforward issue. Some clients such as outlook or msn explorer automatically link any detected hyperlinks. But if the user is using any webmail client or aol, then you need to add the hyperlink into your email. I think that on a majority of current email clients if you place the hyperlink into your Body string it will work as expected. But... there are other items you won't be able to get around. Some users still use Text Only mail as a security precaution. Some companies might strip HTML out of messages before it reaches a user's inbox, etc. Your best bet is probably to go with with placing the hyperlink <a href="http://www.mycompany.com">http://www.mycompany.com</a> into your email string and then maybe put just your companies URL in the footer of the message in case the user is a text only client. Torin Blair
'In the immortal words of Socrates - "I drank what?".'

The img tag only accepts image files. Since you are passing it a web page it is getting confused. Make your aspx into dymImg.ascx. Expose a public String in the class called Name. Then dynamically load the ascx into your web page in the 5 locations you need it. Use the public "Name" field in the ascx, and then render the controls on the screen. This should give you the desired result. Torin Blair
'In the immortal words of Socrates - "I drank what?".'