Oct 7th, 2009 | 1 Comment

Following code helps you to import grid values to excel,

//Import System.IO in your application for StreamWriter Object

//note: excel_file represents the complete physical address of excel file eg  C:/myexcel.xls
public  void export_datagridview_to_excel(DataGridView dgv, string excel_file)
{
int cols;
//open file
StreamWriter wr = new StreamWriter(excel_file);

//determine the number of columns and write columns to file
cols = dgv.Columns.Count;
for (int i = 0; i < cols; i++)
{
wr.Write(dgv.Columns[i].Name.ToString().ToUpper() + “\t”);
}

wr.WriteLine();

//write rows to excel file
for (int i = 0; i < (dgv.Rows.Count - 1); i++)
{
for (int j = 0; j < cols; j++)
{
if (dgv.RowsIdea.Cells[j].Value != null)
wr.Write(dgv.Rows[i].Cells[j].Value + “\t”);
else
{
wr.Write(”\t”);
}
}

wr.WriteLine();
}

//close file
wr.Close();
}

Written by Ajay Matharu

October 7th, 2009 at 1:19 pm

Aug 28th, 2009 | 1 Comment

I have been getting good response for my post Integrating blog engine into existing site. One of the guy asked me this question on how can we do the opposite? He had a BlogEngine as parent site and needed some other site to be child of BlogEngine. So He posted on that and this is the answer he got for his question.

You need to make this change in your web.config file. If you want to have a website as child of BlogEngine

<location path="." inheritInChildApplications="false">
 <system.web>
 ..... existing content .....
 </system.web>
</location>

<location path="." inheritInChildApplications="false">
 <system.webServer>
 ..... existing content .....
 </system.webServer>
</location>

Written by Ajay Matharu

August 28th, 2009 at 11:48 pm