SqlConnection con = new SqlConnection("BaglantiAdresin");
SqlCommand com = new SqlCommand("Select * from tablo",con);
con.Open();
SqlDataReader dr = com.ExecuteReader();
while(dr.Read())
{
//strList yerine kendi ArrayList adını yazmalısın.
strList.Add(dr["KolonAdi"].ToString());
}
con.Close();
Yada;
C#:
List<string> strList = new List<string>();
SqlConnection con = new SqlConnection("BaglantiAdresin");
SqlCommand com = new SqlCommand("Select * from tablo",con);
con.Open();
SqlDataReader dr = com.ExecuteReader();
while(dr.Read())
{
strList.Items.Add(dr["KolonAdi"].ToString());
}
con.Close();
Linq ile
VeriTabaniDataContext db = new VeriTabaniDataContext();
var liste= from x in db.Tablo select x.KolonAdi;
List<string> strList = liste.ToList();
SqlConnection con = new SqlConnection("BaglantiAdresin");
SqlCommand com = new SqlCommand("Select * from tablo",con);
con.Open();
SqlDataReader dr = com.ExecuteReader();
while(dr.Read())
{
//strList yerine kendi ArrayList adını yazmalısın.
strList.Add(dr["KolonAdi"].ToString());
}
con.Close();
Yada;
C#:
List<string> strList = new List<string>();
SqlConnection con = new SqlConnection("BaglantiAdresin");
SqlCommand com = new SqlCommand("Select * from tablo",con);
con.Open();
SqlDataReader dr = com.ExecuteReader();
while(dr.Read())
{
strList.Items.Add(dr["KolonAdi"].ToString());
}
con.Close();
Linq ile
VeriTabaniDataContext db = new VeriTabaniDataContext();
var liste= from x in db.Tablo select x.KolonAdi;
List<string> strList = liste.ToList();