Newsletters
HOME
GUIDE
TORRENT
CONTATTI
Articoli ASP.NET
Articoli C#
Articoli HTML 5
Articoli Vari
Guida HTML
Guida CSS
UTILITA'
Entità Carattere (ISO)
Guida estensioni dei file
Convertitore File
Convertire .Pdf in Word
ConnectionStrings
LINK AJAX
glassfish.dev.java.net
jesty.wordpress.com
www.smartclient.com
livedemo.exadel.com
eudock.jules.it
www.dhtmlgoodies.com
www.dynamicdrive.com
www.dustindiaz.com
miniajax.com
ajaxian.com
www.ajaxwith.com
dojotoolkit.org
www.ajaxrain.com
www.ajaxcompilation.com
www.ajaxdaddy.com
snipplr.com
www.webappers.com
www.ajaxprojects.com
www.openjs.com
C#
-
Esportare dati excel in sql - export excel data into sql server
05/11/2011 15:07:34
excel file columns and sql server tables columns should be same and datatype also should be same.
public void Exel2Sql()
{
OdbcConnection connection;
SqlBulkCopy bulkCopy;
string ConnectionString = @”server=sujitkumar\sqlexpress;database=pubs;uid=sa;pwd=1234;”;
string connstr = @”Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=c:\contact.xls”; using (connection = new OdbcConnection(connstr))
{
OdbcCommand command = new OdbcCommand(”Select * FROM [Sheet1$]“, connection);
//you can change [Sheet1$] with your sheet name
connection.Open();
// Create DbDataReader to Data Worksheet
using (OdbcDataReader dr = command.ExecuteReader())
{
// Bulk Copy to SQL Server
using (bulkCopy = new SqlBulkCopy(ConnectionString))
{
bulkCopy.DestinationTableName = “Names”;
//”Names” is the sql table where you want to copy all data.
bulkCopy.WriteToServer(dr);
}
dr.Close();
}
}
bulkCopy.Close();
connection.Close();
}
1
2
3
4
5
Advertise Here
Contattami...
Advertise Here
Contattami...
Advertise Here
Contattami...
Advertise Here
Contattami...
Advertise Here
Contattami...
Advertise Here
Contattami...
Advertise Here
Contattami...
Advertise Here
Contattami...
Advertise Here
Contattami...
Advertise Here
Contattami...
Advertise Here
Contattami...
ASP.NET
Grafici in .NET
CLR
Linq Vantaggi/Svantaggi
Windows Presentation Foundation (WPF)
............
............
............
...........
HTML5
Animazione
Grafico
Compatibilità tra Browser
Player audio hsound
Interactive canvas gradients
...........
...........
............
CSS3
Background
Borders
Colonne multiple
Interfaccia utente
Crea un Layout 3D
Moduli Css3 del W3C
100 Esempi Css3
...............
Copyright (c) 2010 ilcorsaronero. All rights reserved.