- Katılım
- 5 Nisan 2020
- Mesajlar
- 2.816
- Çözümler
- 11
Daha fazla
- Cinsiyet
- Erkek
- Meslek
- Sivil Polis
C#:
using System;
using System.Data;
using System.Data.OleDb;
using System.Windows.Forms;
namespace elaKiyafetAlimSatim
{
public partial class Form3 : Form
{
public Form3()
{
InitializeComponent();
}
private void guna2Button1_Click(object sender, EventArgs e)
{
string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\\elaKiyafet.accdb; Persist Security Info=False";
string query = "INSERT INTO getUrunler (urunBarkodu, urunFiyati, urunIsmi, sBeden, mBeden, lBeden, xlBeden, 2xlBeden, 3xlBeden) VALUES ('" + guna2TextBox2.Text + "','" + guna2TextBox3.Text + "','" + guna2TextBox1.Text + "','" + guna2TextBox4.Text + "','" + guna2TextBox5.Text + "','" + guna2TextBox6.Text + "','" + guna2TextBox7.Text + "','" + guna2TextBox8.Text + "','" + guna2TextBox9.Text + "')";
MessageBox.Show("Sorgu: " + query, "Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Information);
using (OleDbConnection conn = new OleDbConnection(connectionString))
{
try
{
conn.Open();
OleDbCommand command = new OleDbCommand(query, conn);
command.Parameters.AddWithValue("@urunBarkod", guna2TextBox2.Text);
command.Parameters.AddWithValue("@urunFiyati", guna2TextBox3.Text);
command.Parameters.AddWithValue("@urunIsmi", guna2TextBox1.Text);
command.Parameters.AddWithValue("@sBeden", guna2TextBox4.Text);
command.Parameters.AddWithValue("@mBeden", guna2TextBox5.Text);
command.Parameters.AddWithValue("@lBeden", guna2TextBox6.Text);
command.Parameters.AddWithValue("@xlBeden", guna2TextBox7.Text);
command.Parameters.AddWithValue("@2xlBeden", guna2TextBox8.Text);
command.Parameters.AddWithValue("@3xlBeden", guna2TextBox9.Text);
int rowsAffected = command.ExecuteNonQuery();
if (rowsAffected > 0)
{
MessageBox.Show("Etkilenen satır sayısı: " + rowsAffected.ToString());
MessageBox.Show("Ürün eklendi.", "Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Ekleme başarısız. Hiçbir satır etkilenmedi.", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show("Ürün eklenemedi. " + ex.Message, "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void guna2Button2_Click(object sender, EventArgs e)
{
// Access veritabanı bağlantı dizesi
string connectionString = "Provider=Microsoft.ACE.OleDb.12.0;Data Source=elaKiyafet.accdb";
string query = "DELETE FROM getUrunler WHERE urunBarkodu = @urunBarkod";
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
try
{
connection.Open();
OleDbCommand command = new OleDbCommand(query, connection);
command.Parameters.AddWithValue("@urunBarkod", guna2TextBox10.Text);
int rowsAffected = command.ExecuteNonQuery();
if (rowsAffected > 0)
{
MessageBox.Show("Ürün silindi.", "Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Information);
guna2TextBox10.Text = "";
}
else
{
MessageBox.Show("Ürün silinemedi.", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show("Ürün silinemedi. " + ex.Message, "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void guna2TextBox1_TextChanged(object sender, EventArgs e)
{
// Burada herhangi bir işlem yapılmıyor.
}
private void Form3_Load(object sender, EventArgs e) {
string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\\elaKiyafet.accdb;";
using (OleDbConnection conn = new OleDbConnection(connectionString))
{
try
{
conn.Open();
MessageBox.Show("Bağlantı başarılı!", "Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("Bağlantı Hatası: " + ex.Message, "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
}
Son düzenleyen: Moderatör: