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
768.9k
i am exporting databsae to excel file
Aug 28 2012 5:50 AM
i am exporting databsae to excel file
this is my 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 c:\\csharp.net-informations.
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();
}
}
}
In the above code there is one line as follows
MessageBox.Show("Excel file created , you can find the file c:\\csharp.net-informations.
xls");
Whether can i change it as follows
MessageBox.Show("Excel file created , you can find the file C:
\\
Documents and Settings
\\ram
\Desktop
\\
excel
.
xls"); (this is the path name where i want to save the record from database to excel)
please help me and send the code.
Reply
Answers (
1
)
printing form
Code in C# + BINARY_DOUBLE data type Problem on Oracle Database