Ciao,
con questo script leggo i dati da un foglio excel ma come posso modificarlo affinchè i dati vengano salvati in un db mysql?
<%@ Page Language="C#" Debug="true" %>
<%@ import Namespace="System" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
<script runat="server">
private OleDbConnection conn = null;
private OleDbDataReader rd = null;
public void page_Load(object sender, EventArgs e)
{
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;";
strConn += "Data Source="+Server.MapPath("asasa.xls")+";";
strConn += "Extended Properties=\"Excel 8.0;\"";
conn = new OleDbConnection(strConn);
string sql = "SELECT * FROM [NGCD$]";
OleDbCommand cmd = new OleDbCommand(sql, conn);
try
{
conn.Open();
rd = cmd.ExecuteReader(CommandBehavior.CloseConnection) ;
dg.DataSource = rd;
dg.DataBind();
rd.Close();
}
catch(Exception exe)
{
lbl.Text = exe.Message+exe.StackTrace;
}
}
</script>
<html>
<head>
<title>Lettura dati da Excel</title>
</head>
<body>
<form runat="server">
<h2>Lettura dati da Excel</h2>
<aspataGrid id="dg" runat="server" />
<asp:Label id="lbl" runat="server" />
</form>
</body>
</html>
grazie
Rispondi quotando
