Data table doldurma değe alama

• 28 Kasım 2020 |
• Umutyazilim

Data table doldurma değe alama

void Oku()
{
DataTable dt = new DataTable();
con = new SqlConnection(@”Server=.\SQL2014;Database=mustafabukulmez;User ID=sa; Password=a123456;pooling=true; “);
da = new SqlDataAdapter(“Select * From PERSONEL_TANIMLARI where per_RECno = ” + Okunan_ID + “”, con);
ds = new DataSet();
con.Open();
da.Fill(ds, “Personel”);
dt = ds.Tables[“Personel”];
con.Close();

txt_per_adi.Text = dt.Rows[0][“per_Adi”].ToString();
txt_per_soyad.Text = dt.Rows[0][“per_Soyadi”].ToString();
txt_per_TC.Text = dt.Rows[0][“per_TC”].ToString();
txt_per_tel.Text = dt.Rows[0][“per_Telefon”].ToString();

}