Database

Blend / C# / Design / MSSQL / Programming / SQLite — 5 Comments
20
Oct 10

My first blog post series, are you interested in it?

I was thinking to write blog post series about process of developing WPF applications.

The series would be about WPF and:

  1. Main architecture of Client/Server application (the big picture)
  2. Using Entity Framework with SQL Server, SQLite (or SQL CE)  and WPF (+Advanced topic on Error handling on Model level)
  3. Authentication and Authorization
  4. Navigation through Forms in WPF app. Continue reading →
C# / Database / Programming — 10 Comments
15
Feb 10

ExportData Table to Excel using C#

Here is little class that I wrote some time ago that helps you export data from DataTable into Excell xls file. It format fields in xls file based on data type from data table.

It’s not a perfect but it will help you to quickly save data from Data Table to Excel file.

Example of usage:

Common.Data.Export2Excel(dataTableWithData, "exported.xls");

Continue reading →

C# / MSSQL / MySQLd / Programming / SQLite — 2 Comments
31
Dec 09

Escape string in C#

I have searched more than 30 min. for string escape method in C#, and finally here it is.

You can find it deep inside Security namspace

string safeString = System.Security.SecurityElement.Escape("St'ring to escpa");

You can use it to sanitize values before saving to database.