baseclass.cs

把datagrid,datagridview,gdridview,datatable里的数据导出excel

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;
/// <summary>
/// baseclass 的摘要说明
/// </summary>
public class baseclass
{
	public baseclass()
	{
		//
		// TODO: 在此处添加构造函数逻辑

		//
    }
        String M_str_sqlcon="Server=weihongge;Database=SBJX;User=SBJXuser;Password=userpass";

        public SqlConnection getcon()
        {
           
               
           SqlConnection myCon = new SqlConnection(M_str_sqlcon);

               
                    return myCon;

        }

        public void getcom(string M_str_sqlstr)
        {
            SqlConnection sqlcon = this.getcon();
            sqlcon.Open();
            SqlCommand sqlcom = new SqlCommand(M_str_sqlstr,sqlcon);
            sqlcom.ExecuteNonQuery();
            sqlcom.Dispose();
            sqlcon.Close();
            sqlcon.Dispose();
         }
        public SqlDataAdapter getdata(string str, string stable)
        {
            SqlConnection sqlcon = this.getcon();
            SqlDataAdapter sqlda = new SqlDataAdapter(str, sqlcon);
            return sqlda;
        }
            

        public DataSet getds(string M_str_sqlstr, string M_str_table)
        {
            SqlConnection sqlcon = this.getcon();
            SqlDataAdapter sqlda = new SqlDataAdapter(M_str_sqlstr, sqlcon);
            DataSet myds = new DataSet();
            sqlda.Fill(myds, M_str_table);
            return myds;          
        }

        public SqlDataReader getread(string M_str_sqlstr)
        {
            SqlConnection sqlcon = this.getcon();
            SqlCommand sqlcom = new SqlCommand(M_str_sqlstr, sqlcon);
            sqlcon.Open();
            SqlDataReader sqlread = sqlcom.ExecuteReader(CommandBehavior.CloseConnection);
            return sqlread;

        }

}