COALESCE simply takes the first nonnull value from the list given. You would do it as a bit of SQL, running on a connection/sql command, not a datasource, it just returns a single column. Hopefully this clarifies things Bob Ashfield Consultants Ltd

Cool,Great and Good News... :-D I Love T-SQL Don't torture yourself,let the life to do it for you.

The course ID is in the query string of the page. Ive managed to get it now working. Thanks Adam

Ill give it a go, what i want to do is allow the user to upload a picture of themselves which is then resized automatically before it is saved. The image is just getting saved to file rather than in a database. Thanks

Its a sqldatasource. What code would i need in to create the datatable from this in the first place? Thanks

Hi I have the same problem. I spent a lot of time trying to fix this but without any success. I added some bounded and template fields to detailsview, witch may caused the problem. If you find a solution, can you please share it with me? Thanks

Its how I put this process into practice I didnt know how to do though... Ive sorted it by doing a for loop in the code now. Thanks

omg I'm so sorry... my mind was in VB.NET when I wrote this. (VB uses the keywork SELECT instead of SWITCH that is used in C#" private void Speciality_SelectedIndexChanged(object sender, System.EventArgs e) { switch(Speciality.SelectedItem.Value.ToLower()) { case "breast surgery": SpecialityBreastSurgery.Visible = true; break; case "cardiology": SpecialityCardiology.Visible = true; break; default: //In case you want to do something "else" break; } } Also remember that your strings for your CASE statements MUST be all lowercase in this instance because I used a .ToLower() in the switch. (I have a habit of doing this to remove casing errors). If you want to use exact case, just simply remove the .ToLower() from the switch.

Hi Thanks for the reply. I am aware of how to upload files to the server yes, it was how best to code a page to upload the excel sheet and the conversion to sql data after I needed to know. I shall have a look through those articles and see how I get on:) Thanks Adam

Thanks for this, that works great, however:rolleyes: what im looking to do is put the results in a hidden text field which I then put a compare validator on in visual studio. Ill have a go at fiddling with this to do it, but any tips will be appreciated!

when you get an image out it may be too big to come in one go so this is how i get an image out using a web service [WebMethod] public byte[] GetPic(int iId) { MemoryStream ms = new MemoryStream(); try { string sSql="select Picture from tblPics where id="+iId.ToString(); SqlConnection objConn = new SqlConnection(msConnection); SqlCommand objCommand = new SqlCommand(sSql,objConn); objConn.Open(); SqlDataReader objData = objCommand.ExecuteReader(CommandBehavior.SequentialAccess); int bufferSize = 1024; byte[] buffer = new byte[bufferSize]; if(objData.Read()) { long startIndex = 0; long retval = objData.GetBytes(0, startIndex, buffer, 0,bufferSize); while (retval == bufferSize) { ms.Write(buffer,0,buffer.Length); startIndex += bufferSize; retval = objData.GetBytes(0, startIndex, buffer, 0, bufferSize); } ms.Write(buffer,0,buffer.Length); } objData.Close(); objConn.Close(); } catch(Exception ex) { Debug.WriteLine(ex.Message); } return ms.GetBuffer(); }