Export DBF, and provide download [go]

Export DBF, and provide download

#region Declare

String mfilepath = MapPath (".. /datatmp/");
String mtablename = "Wyks";
String mstrconn = @ "Provider=Microsoft.Jet.OLEDB.4.0; Data source= "+ Mfilepath + @"/; Extended properties= "" DBASE IV; Hdr=yes; ""; ";

System.Data.OleDb.OleDbConnection moldbconn = new System.Data.OleDb.OleDbConnection (mstrconn);
if (System.IO.File.Exists (Mfilepath + "//" + Mtablename + "). DBF ") = = True)
{
System.IO.File.Delete (Mfilepath + "//" + Mtablename + "). DBF ");
}
#endregion Declare

#region Creating a dbf Table file

#region CREATE TABLE

String sqlt = "CREATE TABLE" + Mtablename + "(" +
"KSH varchar (18)," +
"KSCJ varchar (1)," +
"Kyzk varchar (1)," +
"Yyyd varchar (1)" +
")";
System.Data.OleDb.OleDbCommand Oldbcomm = new System.Data.OleDb.OleDbCommand (SQLT, moldbconn);
Moldbconn.open ();
Oldbcomm.executenonquery ();
Oldbcomm.dispose ();
Moldbconn.close ();

#endregion CREATE TABLE

#region Delete Tabledate

System.Data.OleDb.OleDbCommand oldbcommin = new System.Data.OleDb.OleDbCommand ("Delete * from" + mtablename, Moldbconn) ;
Moldbconn.open ();
Oldbcommin.executenonquery ();
Oldbcommin.dispose ();
Moldbconn.close ();

#endregion Delete Tabledate

#endregion Creating a dbf Table file

#region Export Data to DBF

String mwhere = "1=1";
if (This.txtExamsPoint.Text.Length > 0)
{
Mwhere = Mwhere + "and Examspoint = '" + This.txtExamsPoint.Text.Trim () + "'";

if (This.txtExaminationRoom.Text.Trim (). Length > 0)
{
Mwhere = Mwhere + "and Examinationroom in (select Examinationroom from t_examinationroom Where examinationroomname = '" + This.txtExaminationRoom.Text.Trim () + "' and Examspoint = '" + This.txtExamsPoint.Text.Trim () + "')";
}
}
if (This.txtKSHStart.Text.Trim (). Length > 0)
{
Mwhere = Mwhere + "and KSH >= '" + this.txtKSHStart.Text.Trim () + "'";
}
if (This.txtKSHEnd.Text.Trim (). Length > 0)
{
Mwhere = Mwhere + "and KSH <= '" + this.txtKSHEnd.Text.Trim () + "'";
}

System.Data.DataSet mdsoralacademic = new System.Data.DataSet ();
OralExam.Entity.T_OralAcademic meoralacademic = new OralExam.Entity.T_OralAcademic ();

Meoralacademic.wherecondition = Mwhere;

OralExam.Data.T_OralAcademic.pro_T_OralAcademic_SelectDynamic (meoralacademic, ref mdsoralacademic, OralExam.BaseC.GlobeValues.ConnString);

for (int i = 0; i < mdsoralacademic.tables[0]. Rows.Count; i++)
{
Meoralacademic = OralExam.DataToEntity.T_OralAcademic.GetEntity (mdsoralacademic, i);

String msqlexport = "Insert into" + Mtablename + "(ksh,kscj,kyzk,yyyd)";
Msqlexport = Msqlexport + "SELECT";
Msqlexport = Msqlexport + "'" + Meoralacademic.ksh + "' as KSH";
Msqlexport = Msqlexport + "'" + Meoralacademic.academiccode + "' as KSCJ";
Msqlexport = Msqlexport + "'" + mEOralAcademic.OralStatus.ToString () + "' as Kyzk,";
Msqlexport = Msqlexport + "'" + mEOralAcademic.ToneStatus.ToString () + "' as Yyyd";

System.Data.OleDb.OleDbCommand Oldbcomminsert = new System.Data.OleDb.OleDbCommand (Msqlexport, moldbconn);
Moldbconn.open ();
Oldbcomminsert.executenonquery ();
Oldbcomminsert.dispose ();
Moldbconn.close ();
}
#endregion Export Data to DBF

Download Available #region

System.IO.FileStream fs = new System.IO.FileStream (Mfilepath + "//" + Mtablename + ". DBF ", System.IO.FileMode.Open, System.IO.FileAccess.Read);

Byte[] B = new Byte[fs. Length];
Fs. Read (b, 0, b.length);
Fs. Flush ();
Fs. Close ();

System.IO.File.Delete (Savepdfpath);
Response.Clear ();
Response.ClearHeaders ();
Response.Clear ();
Response.ClearHeaders ();
Response.Buffer = false;
Response.ContentType = "Application/octet-stream"; ContentType;
Response.appendheader ("Content-disposition", "attachment;filename=" + httputility.urlencode (MFilePath + "//" + Mtablename + ". DBF ", System.Text.Encoding.UTF8));
Response.appendheader ("Content-length", b.length.tostring ());
Fs. Close ();
Fs. Close ();
if (B.length > 0)
{
Response.OutputStream.Write (b, 0, b.length);
}

Response.Flush ();
Response.End ();

Download available #endregion

Other Related:
transferred from:http://www.cnblogs.com/jyshi/

Export DBF, and provide download [go]