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
i am exporting databsae to excel file
Aug 28 2012 4:09 AM
i am exporting database to excel file.
Design as follows
Button(one button)
code as follows
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Windows.Forms;
using Excel = Microsoft.Office.Interop.Excel;
public partial class _Default : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("Server=(local);initial catalog=Rental;Trusted_Connection=True");
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con;
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();
}
}
}
when i run i get this error:Use of unassigned local variable 'con'
Please help from the above code what is the mistake.and send the code.
Thanks,
Rao
Reply
Answers (
2
)
How to use the Report view in windows form application
printing form