if you want export fine,you used row[m][n],each other cell, you'll format fields to excel.

suggest used JS, U'll know the file size befor U loadup.

modify web.config file,about crystal report configure, .net frameword3.5 and 4.0 import file don't one

u'll download a opencode website,modify little code,

u used

OpenFileDialog

,you select file,but u don't loadup the file,you'll used file class, filecopy to you setting path.

InitialDirectory = @"c:\";

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
u code
}
}

"insert into Network (States,LGA,Glo,MTN,Airtel,Etisalat,Multilinks,Starcomms,Visafone,Zoom_mobile,Remarks)values this sql not't greencom filed, eg:: sqlds1.InsertCommandType = SqlDataSourceCommandType.Text; sqlds1.InsertCommand = "insert into Network (States,LGA,Glo,MTN,Airtel,Etisalat,Multilinks,Starcomms,Visafone,greencom,Zoom_mobile,Remarks)values(@countryList,@stateList,@greencom,@mtngsm,@airtel,@etisalat,@multilinks,@starcomms,@visafone,@zoomm,@remarks)"; sqlds1.InsertParameters.Add("countryList", countryList.Text); sqlds1.InsertParameters.Add("stateList", stateList.Text); sqlds1.InsertParameters.Add("greencom", greencom.Text); sqlds1.InsertParameters.Add("mtngsm", mtngsm.Text); sqlds1.InsertParameters.Add("airtel", aritel.Text); sqlds1.InsertParameters.Add("etisalat", etisalat.Text); sqlds1.InsertParameters.Add("multilinks", multilinks.Text); sqlds1.InsertParameters.Add("starcomms", starcomms.Text); sqlds1.InsertParameters.Add("visafone", visafone.Text); sqlds1.InsertParameters.Add("zoomm", zoomm.Text); sqlds1.InsertParameters.Add("remarks", remarks.Text); sqlds1.Insert();

Encryption uploaded files name, if Encryption a .docx file ,it's tried too

check MV3 files path on the the upload server.

<form id="form1" runat="server" defaultfocus="TextBox1" >

thanks! i'll look for tell me URL!

MessageBox.Show(e.Message); what's message? if the _url is valid, open(_url)'ll back e.Message

I'll download program of PKI C#(asp.net),who can tell me the url?

great!

You'll wright THML code create FrameSet. But you must familiar with FrameSet construction.

Because the "Request.QueryString("FirstName")" used "()", vs has it's a method. so your used "[]" and it's OK.

Search of g.cn, you'll to browse Oracle example! www.oracle.com

You'll using right to limit the buttom, and user right from userlevel list table.

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Reflection; using System.Runtime.InteropServices; using Excel = Microsoft.Office.Interop.Excel; using System.Data.OleDb; using System.Security.Cryptography; public DataSet ExcelToDS(string Path) { //return one dataset object missing = Missing.Value; Excel.Application excelApp = new Excel.Application(); excelApp.Visible = false; try { excelApp.Workbooks.Open(path, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing); excelApp.Workbooks[1].Worksheets[i + 1]; Excel.Worksheet ws = (Excel.Worksheet)excelApp.Workbooks[1].Worksheets[1]; string sheetName = ws.Name; string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Path + ";" + "Extended Properties=Excel 8.0;"; OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); string strExcel = ""; OleDbDataAdapter myCommand = null; DataSet ds = null; strExcel = "select * from [" + sheetName + "$]"; myCommand = new OleDbDataAdapter(strExcel, strConn); ds = new DataSet(); myCommand.Fill(ds); conn.Close(); excelApp.Workbooks.Close(); excelApp.Quit(); excelApp = null; return ds; } catch { MessageBox.Show("Not close EXCEL", "Err Info", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); KillProcess("EXCEL"); return null; } }

modified on Tuesday, May 5, 2009 3:52 AM

Can you pastered this code? DB it's bind ,and update it.