xxKralTRxx
Decapat
- Katılım
- 31 Temmuz 2022
- Mesajlar
- 342
- Çözümler
- 6
C#:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.OleDb;
namespace WindowsFormsApp14
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
List<string> kisiler = new List<string>();
OleDbConnection con;
OleDbCommand cmd;
OleDbDataReader dr;
private void button1_Click(object sender, EventArgs e)
{
con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\yalci_000\Desktop\Deneme.xlsx; Extended Properties='Excel 12.0 xml;HDR=YES;'");
cmd = new OleDbCommand("SELECT *FROM[Deneme$]", con);
con.Open();
dr = cmd.ExecuteReader();
while (dr.Read())
{
kisiler.Add(dr["Ad"].ToString());
}
con.Close();
foreach (var kisi in kisiler)
{
listBox1.Items.Add(kisi);
}
}
}
}
