I know that there are many Weather Report applets in Linux, one of them's hosted here: http://freshmeat.net/projects/zweatherapplet/ It may be worth firing off a brief, polite email to the developer. Hope this helps.

Hi all, I'm really struggling to do something very simple using a DataGridView control. I'm setting the DataGridView DataSource to an existing DataSet. All the data is displayed fine. I now want to select a range of cells using the DataGridView, and when I click a button, have the selected cells copied to a new (previously empty) dataset. I just can't figure out how to get the data I've selected in the DataGridView control into the new dataset. By putting a watch on the DataGridView control, I can see the list of items contained in the control, but they're all non-public so I have no way of getting at them programmatically. Any assistance would be very much appreciated.

Firstly, are you using Windows Security (trusted connection) or SQL Server security (you have a separate username and password for SQL Server)? Does everyone who's going to use your application access SQL Server the same way? Do all your users have access to SQL Server? These are the things that you need to determine before going forwards. If everyone in your workplace has a trusted connection to SQL Server and access to the DB, then you don't need to provide username and password information in your connection string. Otherwise, you'll have to get a username and password from each user (to include in the connection string) before they can get access to the SQL Server DB. I hope this helps.

Guffa, You are correct. I am an idiot. I have fixed that small oversight, and am hopeful it will be plain(ish) sailing from here on in. Thanks very much for your help!

Guffa, thanks for your response. I'm new to C# and I've not used HashTables before, could I just clarify how this would work in my example? From looking at what I can find on HashTables, would my code look like this? System.Collections.Hashtable h = new Hashtable(); foreach (Microsoft.Office.Interop.Excel.Worksheet ws in wrkBook.Worksheets) { if (ws.Name != null) { this.lstSheets.Items.Add(ws.Name); strWorksheet = ws.Name.ToString(); h.Add(strWorksheet, ws); } } For anyone else reading this post looking for further information, I found a short tutorial on HashTables here: http://abstractvb.com/code.asp?A=1026

Have you looked under C:\WINDOWS\TEMP\Temporary Internet files?

Hi, I'm hoping someone can help me with a problem I'm having with an app that reads in an Excel spreadsheet. For each worksheet in the spreadsheet I want to create a DataTable that has the same name as the Excel worksheet. My code currently looks like this: foreach (Microsoft.Office.Interop.Excel.Worksheet ws in wrkBook.Worksheets) { if (ws.Name != null) { this.lstSheets.Items.Add(ws.Name); strWorksheet = ws.Name.ToString(); System.Data.DataTable ws.Name = new System.Data.DataTable(); } } This doesn't work as it thinks I'm trying to reassign an existing object, rather than create a new object with the name of an existing object's property. Can anyone explain how I can create as many datatables as exists in the spreadsheet file I open, and programmatically give each DataTable the same name as the worksheet from the spreadsheet? Any assistance would be gratefully recieved!

Hi Colin, Thanks for responding. I should have written in my initial post that I'd tried not passing a username or password, but was getting the following error: No overload for method 'Connect' takes '1' arguments(CS1501) As such, I thought that the Connect Method forced me to put in a username and password, even if they shouldn't be required.

Firstly, I apologise if this is the wrong group to post in, my problem involves technologies covered in three different groups. C# is the language, .NET 2.0 is the platform, SQL Server is the DBMS. I'm developing on my local machine and have a named instance of SQL Server running. I'm trying to connect to the instance of SQL Server using SQLDMO (because I want the connection to return a list of all the databases available on that server, and SQLDMO seems the best way of doing it) My user account is set up as a trusted connection via Enterprise Manager, but I'm unable to log onto the server. The app returns an error message of: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'foo' The code in question looks like: SQLDMO.SQLServer srv = new SQLDMO.SQLServerClass(); srv.Connect(this.cmbServer.SelectedItem.ToString(),this.txtUser.Text,this.txtPassword.Text); I have also tried connecting without providing username or password details, but have had the same result. Any ideas?