KatatexxDeveloper
Yoctopat
- Katılım
- 22 Ağustos 2021
- Mesajlar
- 1
Daha fazla
- Cinsiyet
- Erkek
Yardımcı olur musunuz lütfen?
Kod:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace sqlBaglantıDenem_4
{
public partial class Form1 : Form
{
SqlConnection baglanti;
SqlCommand command;
SqlDataAdapter da;
public Form1()
{
InitializeComponent();
}
void vericagir()
{
baglanti = new SqlConnection("server=MustafaYilmaz;Initial Catalog=Deneme;Integrated Security=SSPI");
baglanti.Open();
da = new SqlDataAdapter("Select *from Deneme_", baglanti);
DataTable tablo = new DataTable();
da.Fill(tablo);
VeriEkrani.DataSource = tablo;
baglanti.Close();
}
private void Form1_Load(object sender, EventArgs e)
{
vericagir();
}
private void VeriEkrani_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
private void VeriEkrani_CellEnter(object sender, DataGridViewCellEventArgs e)
{
TXT_isim.Text = VeriEkrani.CurrentRow.Cells[0].Value.ToString();
TXT_soyisim.Text = VeriEkrani.CurrentRow.Cells[1].Value.ToString();
DTP_tarih.Text = VeriEkrani.CurrentRow.Cells[2].Value.ToString();
TXT_tel.Text = VeriEkrani.CurrentRow.Cells[3].Value.ToString();
}
private void Ekle_button_Click(object sender, EventArgs e)
{
string sorgu = "INSERT INTO Deneme_(Ad,Soyad,Dtarih,Tel) VALUES (@Ad,@Soyad,@Dtarih,@tel) ";
command = new SqlCommand(sorgu, baglanti);
command.Parameters.AddWithValue("@Ad", TXT_isim.Text);
command.Parameters.AddWithValue("@Soyad", TXT_soyisim.Text);
command.Parameters.AddWithValue("@Dtarih", DTP_tarih.Text);
command.Parameters.AddWithValue("@tel[", TXT_tel.Text);
baglanti.Open();
command.ExecuteNonQuery();
baglanti.Close();
command.Parameters.Clear();
vericagir();
}
}
}
