string baglanti = "";
if (FileUpload1.HasFile)
{
string dosyaadi = Path.GetFileName(FileUpload1.PostedFile.FileName);
string dosyauzanti = Path.GetExtension(FileUpload1.PostedFile.FileName);
string dosyayeri = Server.MapPath("~/mnspanel/stokliste/" + dosyaadi);
FileUpload1.SaveAs(dosyayeri);
if (dosyauzanti == ".xlsx")
{
baglanti = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=mssql02.trwww.com;Initial Catalog=qwindoor_qwindoor;Persist Security Info=True;User ID=qw;Password=**********;" + dosyayeri + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";
}
else if (dosyauzanti == ".xlsx")
{
baglanti = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=mssql02.trwww.com;Initial Catalog=qwindoor_qwindoor;Persist Security Info=True;User ID=qw;Password=********;" + dosyayeri + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
}
OleDbConnection bag = new OleDbConnection(baglanti);
OleDbCommand komut = new OleDbCommand();
komut.CommandType = System.Data.CommandType.Text;
komut.Connection = bag;
OleDbDataAdapter dAdapter = new OleDbDataAdapter(komut);
DataTable excelkayitlari = new DataTable();
bag.Open();
DataTable excelsayfasi = bag.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
string excelsayfasininadi = excelsayfasi.Rows[0]["veridata"].ToString();
komut.CommandText = "SELECT * FROM [" + excelsayfasininadi + "]";
dAdapter.SelectCommand = komut;
dAdapter.Fill(excelkayitlari);
bag.Close();
GridView1.DataSource = excelkayitlari;
GridView1.DataBind();
OleDbConnection baglan = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; DATA Source=mssql02.trwww.com;Initial Catalog=qwindoor_qwindoor;Persist Security Info=True;User ID=qw;Password=*********;");
foreach (GridViewRow row in GridView1.Rows)
{//www.aspnetornekleri.com
OleDbCommand komut1 = new OleDbCommand("insert into veridata (stokid,aciklama,icrenk, disrenk, anarenk, adet,boy) values (@stokid,@aciklama,@icrenk, @disrenk, @anarenk, @adet,@boy)", baglan);
komut1.Parameters.AddWithValue("@stokid", HttpUtility.HtmlDecode(row.Cells[0].Text));
komut1.Parameters.AddWithValue("@aciklama", HttpUtility.HtmlDecode(row.Cells[1].Text));
komut1.Parameters.AddWithValue("@icrenk", HttpUtility.HtmlDecode(row.Cells[2].Text));
komut1.Parameters.AddWithValue("@disrenk", HttpUtility.HtmlDecode(row.Cells[3].Text));
komut1.Parameters.AddWithValue("@anarenk", HttpUtility.HtmlDecode(row.Cells[4].Text));
komut1.Parameters.AddWithValue("@adet", HttpUtility.HtmlDecode(row.Cells[5].Text));
komut1.Parameters.AddWithValue("@boy", HttpUtility.HtmlDecode(row.Cells[6].Text));
if (ConnectionState.Closed == baglan.State)
baglan.Open();
komut1.ExecuteNonQuery();
baglan.Close();
}
File.Delete(dosyayeri);
}
Ekran HATASI : ConnectionString özelliği başlatılmamış.
Bana Yardımcı olabilir misiniz
