error while exporting datagrid details to excel?

Question

0.00/5 (No votes)

See more:

hi am getting error while exporting datagrid details to excel

here is my btnExport code..

   private void btnExport_Click(object sender, EventArgs e)
        {
            lblMessage.Text = "";
            // Export all the details
            try
            {
                // Get the datatable to export			
                DataTable dtEmployee = dsEmployee.Tables["tblTicketing"].Copy();

                // Export all the details to Excel
                RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Win");
                objExport.ExportDetails(dtEmployee, Export.ExportFormat.Excel, "C:\\Ticketing.xls");
                lblMessage.Text = "Successfully exported to C:\\Ticketing.xls";
            }
            catch (Exception Ex)
            {
                lblMessage.Text = Ex.Message;
            }

        }
error is like object reference is not set to an instance...

can any one suggest me?
thank u

Posted 10-Jul-12 4:35am

ythisbug

Updated 10-Jul-12 4:37am

v2

Add a Solution

Comments

Shemeer NS 10-Jul-12 11:08am

in which line you are getting error?

ythisbug 10-Jul-12 11:21am

DataTable dtEmployee = dsEmployee.Tables["tblTicketing"].Copy();

this line am getting error

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kiran Susarla · Answer 1 · 2012-07-10T05:07:00

Solution 1

This means that one of the variable is not instantiated and it is throwing NullReferenceException.
Run the code in Debug mode and you can find which variable is throwing the exception.

Posted 10-Jul-12 5:07am

Kiran Susarla

Comments

ythisbug 10-Jul-12 11:21am

DataTable dtEmployee = dsEmployee.Tables["tblTicketing"].Copy();

in this line am getting error..
is dat code is correct?

Kiran Susarla 10-Jul-12 12:13pm

This means dsEmployee is null or dsEmployee does not contain a table tblTicketing.
If dsEmployee is null, create an instance of dataset and populate the dataset. There a bunch of samples available on how to populate the dataset.

Shemeer NS · Answer 2 · 2012-07-10T05:26:00

Solution 2

Your code is syntactically right

DataTable dtEmployee = dsEmployee.Tables["tblTicketing"].Copy();

make sure that "dsEmployee" contains a datatable named "tblTicketing"

Posted 10-Jul-12 5:26am

Shemeer NS

Comments

ythisbug 10-Jul-12 11:42am

thanks .not der can u suggest me.acually am using datagrid..

Shemeer NS 10-Jul-12 11:46am

if you are using datagrid or gridview this is same for all.. the actual probelm is dsEmployee is null or thetre is no table tblTicketing in dsEmployee... try debugging your code to see the actual values of dataset

ythisbug 10-Jul-12 12:01pm

ya dsEmployee is null..better solution for this?

Kiran Susarla 10-Jul-12 12:14pm

I missed this comment. You can create an instance of dataset and populate the dsEmployee with the required data.

ythisbug 10-Jul-12 13:29pm

ok thank u kiran

Shemeer NS 10-Jul-12 13:52pm

problem resolved?

ythisbug 11-Jul-12 1:34am

no shemeer.not solved.thanks for ur reply

Shemeer NS 11-Jul-12 5:45am

have you populated value to the dsEmployee, before calling this method... if not populated then read this from msdn this will help you... http://msdn.microsoft.com/en-us/library/system.data.dataset.aspx