ADO.NET, C# uygulamalarının SQL Server gibi veritabanlarıyla haberleşmesini sağlayan veri erişim teknolojisidir.
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace ogrkurs
{
publicpartialclassfrmogrkurs : Form
{
SqlConnection cnn = new SqlConnection("Server =.; Database = ogrenci; Integrated Security = true");
publicfrmogrkurs()
{
InitializeComponent();
}
void kursadidoldur()
{
SqlDataAdapter adpkurs = new SqlDataAdapter("Select kurs_id,kursadi from sbt_kurs", cnn);
DataTable dtkurs = new DataTable();
cnn.Open();
adpkurs.Fill(dtkurs);
cnn.Close();
ddlkursadi.DisplayMember = "kursadi";
ddlkursadi.ValueMember = "kurs_id";
ddlkursadi.DataSource = dtkurs;
}
void kursiddoldur()
{
SqlDataAdapter adpkurs = new SqlDataAdapter("Select kurs_id,kursadi from sbt_kurs", cnn);
DataTable dtkurs = new DataTable();
cnn.Open();
adpkurs.Fill(dtkurs);
cnn.Close();
ddlkursid.DataSource = dtkurs;
ddlkursid.DisplayMember = "kursadi";
ddlkursid.ValueMember = "kurs_id";
}
void goster()
{
DataTable dt = new DataTable();
SqlDataAdapter adp = new SqlDataAdapter("Select * from view_ogrkurs", cnn);
cnn.Open();
adp.Fill(dt);
grdogr.DataSource = dt;
cnn.Close();
}
privatevoid frmogrkurs_Load(object sender, EventArgs e)
{
kursadidoldur();
kursiddoldur();
goster();
}
privatevoid btnkaydet_Click(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn;
cmd.CommandText = "set dateformat dmy insert into tbl_ogrenci(ogrencino,tckimlikno,adsoyad,telefon,email,kurs_id) values(@ogrencino,@tckimlikno,@adsoyad,@telefon,@email,@kurs_id)";
cmd.Parameters.Add("@ogrencino", SqlDbType.NVarChar).Value = txtogrencino.Text;
cmd.Parameters.Add("@tckimlikno", SqlDbType.NVarChar).Value = txttckimlikno.Text;
cmd.Parameters.Add("@adsoyad", SqlDbType.NVarChar).Value = txtadsoyad.Text;
cmd.Parameters.Add("@telefon", SqlDbType.NVarChar).Value = txttelefon.Text;
cmd.Parameters.Add("@email", SqlDbType.NVarChar).Value = txtemail.Text;
cmd.Parameters.Add("@kurs_id", SqlDbType.Int).Value = ddlkursid.SelectedValue;
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
goster();
}
privatevoid btnguncelle_Click(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn;
cmd.CommandText = "set dateformat dmy update tbl_ogrenci set ogrencino=@ogrencino,tckimlikno=@tckimlikno,adsoyad=@adsoyad,telefon=@telefon,email=@email,kurs_id=@kurs_id where ogrenci_id=" + grdogr.CurrentRow.Cells["ogrenci_id"].Value + "";
cmd.Parameters.Add("@ogrencino", SqlDbType.NVarChar).Value = txtogrencino.Text;
cmd.Parameters.Add("@tckimlikno", SqlDbType.NVarChar).Value = txttckimlikno.Text;
cmd.Parameters.Add("@adsoyad", SqlDbType.NVarChar).Value = txtadsoyad.Text;
cmd.Parameters.Add("@telefon", SqlDbType.NVarChar).Value = txttelefon.Text;
cmd.Parameters.Add("@email", SqlDbType.NVarChar).Value = txtemail.Text;
cmd.Parameters.Add("@kurs_id", SqlDbType.Int).Value = ddlkursid.SelectedValue;
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
goster();
}
privatevoid btnsil_Click(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn;
cmd.CommandText = "set dateformat dmy delete from tbl_ogrenci where ogrenci_id=" + grdogr.CurrentRow.Cells["ogrenci_id"].Value + "";
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
goster();
}
privatevoid grdogr_CellClick(object sender, DataGridViewCellEventArgs e)
{
string sql1 = "set dateformat dmy select * from tbl_ogrenci where ogrenci_id=" + grdogr.CurrentRow.Cells["ogrenci_id"].Value + "";
DataTable dt = new DataTable();
SqlDataAdapter adp = new SqlDataAdapter(sql1, cnn);
cnn.Open();
adp.Fill(dt);
cnn.Close();
foreach (DataRow dr in dt.Rows)
{
txtogrencino.Text = dr["ogrencino"].ToString();
txttckimlikno.Text = dr["tckimlikno"].ToString();
txtadsoyad.Text = dr["adsoyad"].ToString();
txttelefon.Text = dr["telefon"].ToString();
txtemail.Text = dr["email"].ToString();
ddlkursid.SelectedValue = dr["kurs_id"];
}
}
privatevoid btnyeni_Click(object sender, EventArgs e)
{
txtogrencino.Text = "";
txttckimlikno.Text = "";
txtadsoyad.Text = "";
txttelefon.Text = "";
txtemail.Text = "";
ddlkursadi.Text = "";
ddlkursid.Text = "";
txtara.Text = "";
txtogrencino.Focus();
}
privatevoid txtara_TextChanged(object sender, EventArgs e)
{
string sql = "";
char str = '%';
if (txtara.Text != "")
{
sql = sql + " and adsoyad like '" + txtara.Text + str + "' or ogrencino like '" + txtara.Text + str + "' ";
}
sql = "Select * from view_ogrkurs where 1=1 " + sql;
DataTable dt = new DataTable();
SqlDataAdapter adp = new SqlDataAdapter(sql, cnn);
cnn.Open();
adp.Fill(dt);
cnn.Close();
grdogr.DataSource = dt;
}
privatevoid ddlkursadi_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
string sql = "";
if (ddlkursadi.Text != "")
{
sql = sql + " and kursadi='" + ddlkursadi.Text + "'";
}
sql = "Select * from view_ogrkurs where 1=1 " + sql;
DataTable dt = new DataTable();
SqlDataAdapter adp = new SqlDataAdapter(sql, cnn);
cnn.Open();
adp.Fill(dt);
cnn.Close();
grdogr.DataSource = dt;
}
catch (Exception xp1)
{
}
}
}
}
ADO.NET temel yapısı:
SqlConnection → SqlCommand → SqlDataReader / SqlDataAdapter → DataTable / DataSet