TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
narasiman rao
NA
519
765.8k
Exporting database to excel file
Aug 29 2012 1:13 AM
i am exporting database to excel file.
Code as follows,
public partial class _Default : System.Web.UI.Page
{
SqlConnection con ;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
con== new SqlConnection("Server=(local);
initial catalog=Rental;Trusted_
Connection=True");
string sql = null;
string data = null;
int i = 0;
int j = 0;
Excel.Application xlapp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorksheet;
object misvalue = System.Reflection.Missing.
Value;
xlapp = new Excel.ApplicationClass();
xlWorkBook = xlapp.Workbooks.Add(misvalue);
xlWorksheet = (Excel.Worksheet)xlWorkBook.
Worksheets.get_Item(1);
//cnn = new SqlConnection(
connectionstring);
con.Open();
sql = "Select * from mis";
SqlDataAdapter da = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
da.Fill(ds);
for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
for (j = 0; j <= ds.Tables[0].Columns.Count - 1; j++)
{
data = ds.Tables[0].Rows[i].
ItemArray[j].ToString();
xlWorksheet.Cells[i + 1, j + 1] = data;
}
}
MessageBox.Show("Excel file created , you can find the file
E:\\excel.
xls ");
}
private void releaseObject(object obj)
{
try
{
System.Runtime.
InteropServices.Marshal.
ReleaseComObject(obj);
obj = null;
}
catch (Exception ex)
{
obj = null;
MessageBox.Show("Exception Occured while releasing object " + ex.ToString());
}
finally
{
GC.Collect();
}
}
}
From the Above Code there is one line called
MessageBox.Show("Excel file created , you can find the file E:\\
excel
.
xls");
when click the button the message shows "Excel file created,you can find the file
E:\\
excel
.
xls.
but when i see the E folder under
excel,
the excel is not there.what is the mistake in the above code line. please help me.
Thanks,
Rao,
Reply
Answers (
1
)
C# using linq to parse xml
Login & logout coding for C# windows application