How to Export Data to Excel from an ASP.NET Application + Avoid the File Format Differ Prompt

 ExportToExcel class contains public scoped method Export, which converts data passed in the form of datatable to excel.


public static class ExportToExcel

{

///

/// This Method takes DataTable and Page as input parameter and

/// renders the converted excel data to given page instance.

///

/// DataTable instance

/// The Sytem.Web.UI.Page instance.

public static void Export(string fileName, GridView gv, string title)

{

HttpContext.Current.Response.Clear();

HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", fileName));

HttpContext.Current.Response.Charset = "";

//HttpContext.Current.Response.ContentType = "application/ms-excel";

HttpContext.Current.Response.ContentType = "application/vnd.xls";

using (StringWriter sw = new StringWriter())

{

HtmlTextWriter htw = new HtmlTextWriter(sw);

try

{

// render the table into the htmlwriter

RenderGrid(gv).RenderControl(htw);

// render the htmlwriter into the response

HttpContext.Current.Response.Write("" + title + "");

HttpContext.Current.Response.Write(sw.ToString());

HttpContext.Current.Response.End();

}

finally

{

htw.Close();

}

}

}
 
More Coding Mehtods:
 
http://blogs.msdn.com/b/erikaehrli/archive/2009/01/30/how-to-export-data-to-excel-from-an-asp-net-application-avoid-the-file-format-differ-prompt.aspx

Unable to connect to database

hi friends,

You receive a "Cannot connect to the configuration database" error message when you access your Windows SharePoint Services Web site

http://support.microsoft.com/kb/833183

You receive an "Unable to connect to database" error message when you install SharePoint Portal Server 2003 or Windows SharePoint Services

http://support.microsoft.com/kb/831105

Troubleshooting Server and Database Connection Problems

http://msdn.microsoft.com/en-us/library/ms156468.aspx

DOTNet Sent Mail Coding

protected void SendMail(string FromUserName, string ToUserName, string strContent, string strSubject)
        {
            try
            {
                string mstrContents;
                //Retrives the contact mail ids
                if (FromUserName != null && FromUserName.Trim() != "" && ToUserName != null && ToUserName.Trim() != "")
                {
                    //Retrives the mailing contents

                    string strSiteName = DefaultSettings.SiteID;//ConfigurationManager.AppSettings["siteId"].ToString().Trim(); ;
                    SPSite site = new SPSite(strSiteName);
                    SPWeb web = site.OpenWeb();
                    string ToEmailid = web.AllUsers[ToUserName].Email;
                    string FromEmailId = ConfigurationManager.AppSettings["FromEmailId"].ToString().Trim(); ;
                    SmtpClient objSmtp = new SmtpClient(ConfigurationManager.AppSettings["SMTP"].ToString().Trim());


                    if (SPUtility.IsEmailServerSet(web))
                    {

                        MailAddress from = new MailAddress(FromEmailId);
                        MailAddress to = new MailAddress(ToEmailid);
                        MailMessage message = new MailMessage(from, to);
                        message.Subject = strSubject;
                        mstrContents = strContent;
                        message.Body = mstrContents;
                        objSmtp.Send(message);
                    }
                    site.Close();
                    site.Dispose();
                    web.Close();
                    web.Dispose();
                }
            }
            catch (Exception ex)
            {
                string strError = ex.Message.ToString();
                objErrorLog.WriteintoLogFile(ex.Message);
                objErrorLog.WriteintoLogFile(ex.StackTrace);
            }
        }

.Net SmtpClient e-mail send with attachments coding

 public void SendMail(string FromUserName, string ToUserName, string strContent, string strSubject, string strAttachmentPath, bool IsAttachment)
        {
            try
            {
                string mstrContents;
                //Retrives the contact mail ids
                if (FromUserName != null && FromUserName.Trim() != "" && ToUserName != null && ToUserName.Trim() != "")
                {
                    //Retrives the mailing contents

                    string strSiteName = DefaultSettings.SiteID;//ConfigurationManager.AppSettings["siteId"].ToString().Trim(); ;
                    SPSite site = new SPSite(strSiteName);
                    SPWeb web = site.OpenWeb();
                    string ToEmailid = web.AllUsers[ToUserName].Email;
                    string FromEmailId = ConfigurationManager.AppSettings["FromEmailId"].ToString().Trim(); ;
                    SmtpClient objSmtp = new SmtpClient(ConfigurationManager.AppSettings["SMTP"].ToString().Trim());


                    if (SPUtility.IsEmailServerSet(web))
                    {

                        MailAddress from = new MailAddress(FromEmailId);
                        MailAddress to = new MailAddress(ToEmailid);
                        MailMessage message = new MailMessage(from, to);
                        Attachment data = new Attachment(strAttachmentPath, MediaTypeNames.Application.Octet);
                        // Add time stamp information for the file.
                        ContentDisposition disposition = data.ContentDisposition;
                        if(strSubject.Contains("Workflow Status Report"))
                        {
                        disposition.FileName = "WorkflowStatusReport.xls";
                        }
                        if(strSubject.Contains("Live Agreement Report"))
                        {
                        disposition.FileName = "LiveAgreementReport.xls";
                        }
                        disposition.CreationDate = System.IO.File.GetCreationTime(strAttachmentPath);
                        disposition.ModificationDate = System.IO.File.GetLastWriteTime(strAttachmentPath);
                        disposition.ReadDate = System.IO.File.GetLastAccessTime(strAttachmentPath);
                        // Add the file attachment to this e-mail message.
                        message.Attachments.Add(data);

                        message.Subject = strSubject;
                        mstrContents = strContent;
                        message.Body = mstrContents;
                        objSmtp.Send(message);
                        data.Dispose();
                    }
                    site.Close();
                    site.Dispose();
                    web.Close();
                    web.Dispose();
                }
            }
            catch (Exception ex)
            {
                string strError = ex.Message.ToString();
                objErrorLog.WriteintoLogFile(ex.Message);
                objErrorLog.WriteintoLogFile(ex.StackTrace);
            }
        }

Sharepoint Custom Search Coding

using Microsoft.Office.Server.Administration;
using Microsoft.Office.Server.Search;
using Microsoft.Office.Server.Search.Query;


        public DataSet getSearchResults(string strSqlString)
        {
            DataSet dsResults = null;
            string strSiteUrl = ConfigurationManager.AppSettings["siteId"].ToString();
            try
            {
                SPSecurity.RunWithElevatedPrivileges(delegate()
                {
                    using (SPSite site = new SPSite(strSiteUrl))
                    {
                        FullTextSqlQuery query = new FullTextSqlQuery(site);
                        query.QueryText = strSqlString;
                        query.RowLimit = 30000;
                        query.ResultTypes = ResultType.RelevantResults;
                        ResultTableCollection coll = query.Execute();

                        if ((int)ResultType.RelevantResults != 0)
                        {
                            ResultTable tblResult = coll[ResultType.RelevantResults];
                            if (tblResult.TotalRows > 0)
                            {
                                DataTable dtResults = new DataTable("tblResults");
                                dsResults = new DataSet();
                                dsResults.Tables.Add(dtResults);
                                dsResults.Load(coll[ResultType.RelevantResults], LoadOption.OverwriteChanges, dtResults);
                            }
                        }
                    }
                });
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return dsResults;
        }

Sharepoint Server 2007 common Errors

You cannot visit any site collection from an Office SharePoint Server 2007 content database after you attach the content database to a SharePoint Server 2010 environment

http://support.microsoft.com/kb/981910

You receive a "Cannot connect to the configuration database" error message when you connect to  your Windows SharePoint Services 2.0 Web site

http://support.microsoft.com/kb/823287

The User Profile Synchronization service does not start on a stand-alone installation of SharePoint Server 2010

http://support.microsoft.com/kb/983061

SharePoint Draft items not crawled

http://support.microsoft.com/kb/2304855

How to add lots of users to a site, to a list, or to a document library in Windows  SharePoint Services 3.0 and in SharePoint Server 2007

http://support.microsoft.com/kb/953132

You cannot use the Item Updating event to retrieve an updated value in SharePoint  Server 2007 or in Windows SharePoint Services 3.0

http://support.microsoft.com/kb/948324

Error message when you try to take an external list offline after you uninstall and then reinstall SharePoint Server 2010: "Failed to obtain signing certificate"

http://support.microsoft.com/kb/981224

You receive a "Service Unavailable" error message  when you browse a Windows SharePoint Services 2.0 Web site

http://support.microsoft.com/kb/823552

How to rename a computer that is running  SharePoint Portal Server 2003

http://support.microsoft.com/kb/830970

How to automate the deletion of backups in SharePoint Server 2007 and in Windows SharePoint Services 3.0 by using a Visual Basic script

http://support.microsoft.com/kb/941330

How to defragment Windows SharePoint Services 3.0  databases and SharePoint Server 2007 databases

http://support.microsoft.com/kb/943345

Using Microsoft Windows SharePoint Services with a content database  that is configured as read-only in Microsoft SQL Server

http://support.microsoft.com/kb/894631

Microsoft Most important Sharepoint Sites

Microsoft Enterprise Search Blog

http://blogs.msdn.com/b/enterprisesearch/

Microsoft Enterprise Content Management (ECM) Team Blog

(Learn about the Enterprise Content Management features in SharePoint and Office 2010 and engage with the people who build and deliver the products)

http://blogs.msdn.com/b/ecm/

Microsoft Records Management Team Blog

A blog about the business challenges we are all facing and the opportunities to address these challenges using technology, as we encounter the problems of records keeping, planning, retention, disposition, litigation response, holds, and so on.

http://blogs.msdn.com/b/recman/

Microsoft InfoPath 2010

http://blogs.msdn.com/b/infopath/

Microsoft Project 2010 The official blog of the Microsoft Office product development group. Learn how to manage your work effectively 

http://blogs.msdn.com/b/project/

Performance Point Services

http://blogs.msdn.com/b/performancepoint/

Microsoft SharePoint Developer Documentation Team Blog

http://blogs.msdn.com/b/sharepointdeveloperdocs/

GetThePoint

http://sharepoint.microsoft.com/blogs/GetThePoint/default.aspx

Enterprise Project management Content

http://blogs.technet.com/b/epmcontent/

Microsoft Business Connectivity Services Team Blog

http://blogs.msdn.com/b/bcs/

Sharepointcomic

http://blogs.technet.com/b/sharepointcomic/

Microsoft Records Management Team Blog

http://blogs.msdn.com/b/recman/

Microsoft Dynamics Mobile Team blog

http://blogs.msdn.com/b/dynamicsmobile/

SharePoint Developer Building Blocks: Technologies for Creating SharePoint Applications:

http://blogs.msdn.com/b/ericwhite/archive/2010/10/26/sharepoint-developer-building-blocks-technologies-for-creating-sharepoint-applications.aspx

Office SharePoint Server 2007 Training Resources:

http://blogs.msdn.com/b/sharepointserver2007trainingcanada

Windows SharePoint Services Manageability Controls (Governance Series Part 1 of 5)

http://sharepoint.microsoft.com/blog/Pages/BlogPost.aspx?PageType=4&ListId={72C1C85B-1D2D-4A4A-90DE-CA74A7808184}&pID=732


SharePoint History

http://sharepoint.microsoft.com/blog/Pages/BlogPost.aspx?PageType=4&ListId={72C1C85B-1D2D-4A4A-90DE-CA74A7808184}&pID=467

SharePoint Resources:

http://blogs.msdn.com/b/arpans/archive/2004/10/11/241116.aspx


Microsoft Office SharePoint Server 2007

http://blogs.msdn.com/b/arpans/archive/2006/05/30/611165.aspx


SharePoint Thinks, Links and Clinks:

http://blogs.msdn.com/b/tadd/

The Microsoft MVP Award Program Blog

http://blogs.msdn.com/b/mvpawardprogram/