Runtime Debugger - kannan M ambadi's blog - All Comments

re: Exporting Dataset as CSV

Steve — Thu, 01 Oct 2009 12:31:45 GMT

Here's an alternative that returns the CSV as a string:

public static string ConvertDataSetToCSV(DataSet ds)

{

const string LC_COMMA = ",";

const string LC_DBLQUOTE = "\"";

const string LC_DBLQUOTE_ESC = "\"\"";

StringBuilder csv = new StringBuilder();

foreach (DataTable tbl in ds.Tables)

{

// Append the table's column headers.

foreach (DataColumn col in tbl.Columns)

{

csv.Append(LC_DBLQUOTE + col.ColumnName + LC_DBLQUOTE + LC_COMMA);

}

csv.Length -= 1;

csv.Append(Environment.NewLine);

// Append the table's data.

foreach (DataRow row in tbl.Rows)

{

foreach (object val in row.ItemArray)

{

csv.Append(LC_DBLQUOTE + val.ToString().Replace(LC_DBLQUOTE, LC_DBLQUOTE_ESC)

+ LC_DBLQUOTE + LC_COMMA);

}

csv.Length -= 1;

csv.Append(Environment.NewLine);

}

// Add an empty line between this and the next table.

csv.Append(Environment.NewLine);

}

return csv.ToString();

}

re: Improve ASPX page performance by reducing HTTP Response size by combining Skin & CSS

kannan.ambadi — Mon, 22 Jun 2009 08:19:28 GMT

Dear Wes,

you are right, but still we can use HTML Tables without writing HTML Style attributes. Write your style definitions into an external file and call it.

Cheers,

kannan

re: Improve ASPX page performance by reducing HTTP Response size by combining Skin & CSS

Wesley Bakker — Mon, 22 Jun 2009 07:21:05 GMT

"Use XHTML markups with CSS always rather than using HTML tables with inline HTML style attributes unless it is required"

I disagree on that one. You should use markup that fits the intention of the contained data. It's recommended to use tables when you actually have table data.

Cheers,

Wes

re: Improve ASPX page performance by reducing HTTP Response size by combining Skin & CSS

Acronyms — Mon, 22 Jun 2009 05:31:04 GMT

Unfortunately, some third party controls write default inline css which can be changed only by using skin files. Not good ...

re: ORM Technology - nHibernate vs Linq

kannan.ambadi — Fri, 23 Jan 2009 04:11:13 GMT

thanks man, but the nhibernate is, its quite difficult to find the exact location of error. it would be tough to find if its in HBM files. You got to be careful while desigining the architecture and database design.

re: ORM Technology - nHibernate vs Linq

afsharm — Thu, 22 Jan 2009 05:03:16 GMT

Nice article, but I prefer to learn Nhibernate instead of LINQ, because I can use my ORM skills in Java too.

afsharm

ORM Technology - nHibernate vs Linq

DotNetShoutout — Fri, 16 Jan 2009 18:16:44 GMT

Thank you for submitting this cool story - Trackback from DotNetShoutout

re: ORM Technology - nHibernate vs Linq

juan carlos peinado pereira — Fri, 16 Jan 2009 16:26:39 GMT

Hey Buddy, I think to compare the two technologies requires having worked in both power and thus give a better contribution to the community.

My comment is that the two technologies have different efoques see how those born nhibernate and both are born linq ORM tools, but for different nhibernate developed a framework that gives you a lot of freedom to incorporate it into the platform. NET is already linq part of a framework that is already a native and has its own characteristics such as linq to objects, Dataset, xml, sql that can be used well or badly in software development.

nhibernate born with the need for a tool that enables a transparent objects in a traditional relational schema.

In this issue we could talk a lot deeper and a lot of advantages and disadvantages, but focused on the purpose of the two technologies.

greetings.

JCP.

re: Exporting Dataset as CSV

samreen — Thu, 20 Nov 2008 11:10:28 GMT

i like it n want to use it

re: Simple way to check your code performance

kannan.ambadi — Wed, 08 Oct 2008 11:33:50 GMT

Thanks guys. Stopwatch gives u precised results.

Stopwatch sw = Stopwatch.StartNew();

PerformWork();

sw.Stop();

Console.WriteLine("Time taken: {0}ms", sw.Elapsed.TotalMilliseconds);

N.B : Please visit link for more information

stackoverflow.com/.../is-datetimenow-the-best-way-to-measure-a-functions-performance