arkadaşlar bn veri tabanından cektirdigim rengi arka plan rengi olarak nasıl koyarım bi yardımcı olabilirmisiniz.
namespace WindowsFormsApplication11
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
OleDbConnection bag = new OleDbConnection("Provider=Microsoft.Ace.Oledb.12.0;Data Source=data.accdb");
private **** button1_Click(object sender, EventArgs e)
{
DialogResult ok = colorDialog1.ShowDialog();
if (ok==DialogResult.OK)
{
textBox1.Text = colorDialog1.Color.ToString();
this.BackColor = colorDialog1.Color;
bag.Open();
OleDbCommand kaydet = new OleDbCommand();
kaydet.Connection = bag;
kaydet.CommandText = "INSERT INTO renk(kodu) Values('"+textBox1.Text+"') ";
kaydet.ExecuteNonQuery();
bag.Close();
}
}
private **** Form1_Load(object sender, EventArgs e)
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("Select kodu FROM renk",bag);
DataTable tablo = new DataTable();
adtr.Fill(tablo);
MessageBox.Show(tablo.Rows[0]["kodu"].ToString());
textBox1.Text=tablo.Rows[0]["kodu"].ToString();
bag.Close();
}
}
}
namespace WindowsFormsApplication11
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
OleDbConnection bag = new OleDbConnection("Provider=Microsoft.Ace.Oledb.12.0;Data Source=data.accdb");
private **** button1_Click(object sender, EventArgs e)
{
DialogResult ok = colorDialog1.ShowDialog();
if (ok==DialogResult.OK)
{
textBox1.Text = colorDialog1.Color.ToString();
this.BackColor = colorDialog1.Color;
bag.Open();
OleDbCommand kaydet = new OleDbCommand();
kaydet.Connection = bag;
kaydet.CommandText = "INSERT INTO renk(kodu) Values('"+textBox1.Text+"') ";
kaydet.ExecuteNonQuery();
bag.Close();
}
}
private **** Form1_Load(object sender, EventArgs e)
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("Select kodu FROM renk",bag);
DataTable tablo = new DataTable();
adtr.Fill(tablo);
MessageBox.Show(tablo.Rows[0]["kodu"].ToString());
textBox1.Text=tablo.Rows[0]["kodu"].ToString();
bag.Close();
}
}
}
