public ozellikTip ozellikTipGetirId(int ozellikTipId) { ozellikTip otp = new ozellikTip(); try { SqlCommand com = new SqlCommand("select * from OzellikTip where OzellikTipId = @ozlTipId", con); com.Parameters.AddWithValue("@ozlTipId", ozellikTipId); com.CommandType = CommandType.Text; con.Open(); SqlDataReader dr = com.ExecuteReader(); while (dr.Read()) { otp.OzellikTipAd = dr["OzellikTipAd"].ToString(); otp.OzellikTipId = Convert.ToInt32(dr["OzellikTipId"]); } dr.Close(); } catch (Exception ex) { } finally { con.Close(); } return(otp); }
public List <ozellikTip> ozellikTipGetirTum() { List <ozellikTip> ozellikTipler = new List <ozellikTip>(); try { SqlCommand com = new SqlCommand("select * from OzellikTip", con); com.CommandType = CommandType.Text; con.Open(); SqlDataReader dr = com.ExecuteReader(); while (dr.Read()) { ozellikTip otp = new ozellikTip(); otp.OzellikTipAd = dr["OzellikTipAd"].ToString(); otp.OzellikTipId = Convert.ToInt32(dr["OzellikTipId"]); ozellikTipler.Add(otp); } dr.Close(); } catch (Exception ex) { } finally { con.Close(); } return(ozellikTipler); }