Deepankar's profile.NET Rocks!!!PhotosBlogListsMore  |  Tools Help |
Paint BallHave started working on a new site www.urbanpaintball.co.nz, very interesting game, where people hit each other with colored balls and pretend to be dead. Can you believe this game has national and international tournaments.
Will keep you posted more on this game as we progress with the site:) Convert a DataSet to a String VariableCoverts a DataTable into an Excel string. Use this method to save a datatable as an Excel file. It loops through each of the DataTables in the DataSet. There is also an option of whether to print the table headers (column names). public static string DataSetToString(DataSet dataSet, string title , bool printHeaders) // Start the excel worksheet for (int table = 0; table < dataSet.Tables.Count; table++) for (int iCol = 0; iCol < dataSet.Tables[table].Columns.Count; iCol++) for (int iRow = 0; iRow < dataSet.Tables[table].Rows.Count; iRow++) sb.Append("</table><table><tr><td></td></tr></table>"); Strip HTML Tags from a StringThe function below will strip the passed string of all HTML Tags. Usage string StrippedString = StripHTML ( HTMLString ) Public static string StripHTML ( string value ) { // Strip the html tag string pattern = "<(.|\n)+?>"; string strOutput = string.Empty; Regex regex = new Regex ( pattern, RegexOptions.IgnoreCase ); // Replace all HTML tag matches with an empty string strOutput = regex.Replace(value, string.Empty); // Replace all < and > with < and > strOutput = strOutput.Replace("<", "<"); strOutput = strOutput.Replace ( ">", ">"); return strOutput; } Code SnippetsI will over the next week keep posting a code snippets which are very useful in development of web applications
Keep watching this space. Reading Excel SheetsSo, I've been writing a little app to combine some Excel spreadsheets. These sheets all have header rows, so I cand open them up with an OleDbConnection, do a "SELECT * FROM [Sheet1$]" and go along my merry way. The problem is, two of the columns I need to work with just aren't there. They're on the excel sheet just fine, but my OleDbDataReader finds nothing in those columns on any row. Looking at the sheet, I see that in those columns, there isn't any data for about 12 rows. So, I put in zeros at the top of those columns, and then it works fine.
Is the OleDbConnection really making assumptions about the dataset based on the first row? After much googling and little success, I try to find a definition of the connectionstring, hoping there's some attribute like "rows to scan for schema" I can set, to tell it to actually read my data. Nathan points me to an excellent resource, Connectionstrings.com, and they kindly let me know that I can specify
HDR=Yes; to indicate that I have a header row in my sheets, and IMEX=1; which, according to Connectionstrings.com: tells the driver to always read "intermixed" data columns as text.Apparently, the two columns in question were, in fact "intermixed" data columns, and once I set that in my connectionstring, all worked fine.
If you have, for instance, both strings and numerics in one external data column, you can get unexpected results - like some of your data doesn’t show up and the above solution doesn't work for you, then again after a lot of googling and research, i tried to change the registry keys as mentioned in this article External Data - Mixed Data Types
The mixed use of "1" and "Yes" aside, why the hell would your database driver just silently ignore data? I mean, if "intermixed" data columns is an error condition, then have the balls to throw a exception, warning, event log entry, anything. Don't just not work and expect me to magically know where the problem is. I almost reimplemented the whole damn thing using Excel objects and the Office API, and that would've taken me another couple of days. A pox on the Excel team! |
|
|
