private void button6_Click(object sender, EventArgs e)
{
SqlConnection MyConnection = new SqlConnection();
MyConnection.ConnectionString = ConnectionClass.Connection_Path();
MyConnection.Open();
string cekme = "SELECT Count(URUN_ID) FROM Product";
SqlDataAdapter da = new SqlDataAdapter(cekme, MyConnection);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
label8.Text = dataGridView1.CurrentRow.Cells[0].Value.ToString();
MyConnection.Close();
SqlConnection My = new SqlConnection();
My.ConnectionString = ConnectionClass.Connection_Path();
My.Open();
string sqlim = "SELECT * FROM PRODUCT";
SqlDataAdapter d = new SqlDataAdapter(sqlim, MyConnection);
DataTable dte = new DataTable();
d.Fill(dte);
dataGridView1.DataSource = dte;
MyConnection.Close();
}
private void textBox2_TextChanged(object sender, EventArgs e)
{
AutoCompleteStringCollection urun = new AutoCompleteStringCollection();
SqlConnection MyConnection = new SqlConnection();
MyConnection.ConnectionString = ConnectionClass.Connection_Path();
MyConnection.Open();
SqlCommand cmd = MyConnection.CreateCommand();
cmd.CommandText = "SELECT A.URUN_ADI FROM PRODUCT AS A";
SqlDataReader dr;
dr = cmd.ExecuteReader();
if (dr.Read())
{
while (dr.Read())
{
urun.Add(dr["URUN_ADI"].ToString());
}
}
else
{
//MessageBox.Show("");
}
textBox2.AutoCompleteMode = AutoCompleteMode.Suggest;
textBox2.AutoCompleteSource = AutoCompleteSource.CustomSource;
textBox2.AutoCompleteCustomSource = urun;
}
public static void Update(string somut)
{
SqlConnection MyConnection = new SqlConnection();
MyConnection.ConnectionString = ConnectionClass.Connection_Path();
MyConnection.Open();
SqlDataAdapter da = new SqlDataAdapter(somut, MyConnection);
DataTable dt = new DataTable();
da.Fill(dt);
MyConnection.Close();
}
public static DataTable BilgiGetir(string komut)
{
SqlConnection MyConnection = new SqlConnection();
MyConnection.ConnectionString = ConnectionClass.Connection_Path();
MyConnection.Open();
SqlDataAdapter da = new SqlDataAdapter(komut, MyConnection);
DataTable dt = new DataTable();
da.Fill(dt);
MyConnection.Close();
return(dt);
}
private void button2_Click(object sender, EventArgs e)
{
SqlConnection MyConnection = new SqlConnection();
MyConnection.ConnectionString = ConnectionClass.Connection_Path();
MyConnection.Open();
string sqlim = "SELECT A.CUSTOMER_ID AS ID, B.RANDEVU_SAATI,A.CUSTOMER_ADI AS ADI,CUSTOMER_SOYADI AS SOYADI,B.RANDEVU_GUNU AS RANDEVUSU FROM CUSTOMER AS A,RANDEVU AS B WHERE A.CUSTOMER_ID=B.CUSTOMER_ID";
SqlDataAdapter da = new SqlDataAdapter(sqlim, MyConnection);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
MyConnection.Close();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection MyConnection = new SqlConnection();
MyConnection.ConnectionString = ConnectionClass.Connection_Path();
MyConnection.Open();
string sqlim = "SELECT * FROM CUSTOMER";
SqlDataAdapter da = new SqlDataAdapter(sqlim, MyConnection);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
MyConnection.Close();
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection MyConnection = new SqlConnection();
MyConnection.ConnectionString = ConnectionClass.Connection_Path();
MyConnection.Open();
string somut = "SELECT A.ID,A.USERNAME FROM KULLANICI AS A ";
SqlDataAdapter da = new SqlDataAdapter(somut, MyConnection);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
MyConnection.Close();
}
private void button2_Click(object sender, EventArgs e)
{
SqlConnection MyConnection = new SqlConnection();
MyConnection.ConnectionString = ConnectionClass.Connection_Path();
MyConnection.Open();
string sqlim = "SELECT B.CUSTOMER_ADI AS 'Müşteri Adı' FROM RANDEVU AS A, CUSTOMER AS B WHERE A.CUSTOMER_ID=B.CUSTOMER_ID";
SqlDataAdapter da = new SqlDataAdapter(sqlim, MyConnection);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
MyConnection.Close();
}
private void button3_Click(object sender, EventArgs e)
{
SqlConnection MyConnection = new SqlConnection();
MyConnection.ConnectionString = ConnectionClass.Connection_Path();
MyConnection.Open();
string sqlim = "SELECT A.CUSTOMER_ID, A.CUSTOMER_ADI AS ADI, A.CUSTOMER_SOYADI AS SOYADI, A.CUSTOMER_NO AS TELEFONU, A.TARIH AS KAYDI FROM CUSTOMER AS A";
SqlDataAdapter da = new SqlDataAdapter(sqlim, MyConnection);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
MyConnection.Close();
}
private void button1_Click(object sender, EventArgs e)
{
//// Random image = new Random();
//Form1.ActiveForm.BackgroundImage = new Bitmap("C:\\Users\\By Rdv\\documents\\visual studio 2015\\Projects\\KuaforAna\\KuaforAna\\images\\b1.jpg");
SqlConnection MyConnection = new SqlConnection();
MyConnection.ConnectionString = ConnectionClass.Connection_Path();
MyConnection.Open();
SqlCommand komut = new SqlCommand("SELECT * FROM KULLANICI WHERE USERNAME= '******' AND PASSWORD= '******'");
SqlDataReader dr;
komut.Connection = MyConnection;
dr = komut.ExecuteReader();
int count = 0;
while (dr.Read())
{
count += 1;
}
if (count == 1)
{
Form12 du = new Form12();
Form2.ActiveForm.Visible = false;
du.Show();
}
else if (count == 0 && textBox1.Text != "" && textBox2.Text != "")
{
MessageBox.Show("Lütfen kullanıcı adınız veya şifreniz hatalı!", "Hata!", MessageBoxButtons.OK, MessageBoxIcon.Error);
textBox1.Clear();
textBox2.Clear();
}
else if (textBox1.Text == "" && textBox2.Text == "")
{
MessageBox.Show("Lütfen kullanıcı adınızı ve şifrenizi giriniz.", "Hata!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
textBox1.Clear();
textBox2.Clear();
}
else if (textBox1.Text == "")
{
MessageBox.Show("Kullanıcı adınızı giriniz.", "Hata!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (textBox2.Text == "")
{
MessageBox.Show("Lütfen şifrenizi giriniz.", "Hata!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
