private void button3_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; label10.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 button1_Click(object sender, EventArgs e) { 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 (!checkBox1.Checked) { Button btn = sender as Button; textBox1.Enabled = false; textBox2.Enabled = false; if (btn == button1) { MisafirKullanici mu = new MisafirKullanici(); mu.Show(); this.Hide(); } } if (count == 1 && checkBox1.Checked) { MainMenu du = new MainMenu(); UserLogin.ActiveForm.Visible = false; du.Show(); } else if (count == 0 && checkBox1.Checked && 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 (checkBox1.Checked && 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 (checkBox1.Checked && textBox1.Text == "") { MessageBox.Show("Kullanıcı adınızı giriniz.", "Hata!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else if (checkBox1.Checked && textBox2.Text == "") { MessageBox.Show("Lütfen şifrenizi giriniz.", "Hata!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
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 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 A.CUSTOMER_ADI AS Adı, A.CUSTOMER_SOYADI AS Soyadı 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) { SqlConnection MyConnection = new SqlConnection(); MyConnection.ConnectionString = ConnectionClass.Connection_Path(); MyConnection.Open(); string sqlim = "SELECT * FROM product"; SqlDataAdapter da = new SqlDataAdapter(sqlim, MyConnection); DataTable dt = new DataTable(); da.Fill(dt); dataGridView1.DataSource = dt; MyConnection.Close(); }
private void button2_Click(object sender, EventArgs e) { button1.Enabled = true; SqlConnection MyConnection = new SqlConnection(); MyConnection.ConnectionString = ConnectionClass.Connection_Path(); MyConnection.Open(); string sqlim = "SELECT A.CUSTOMER_ID AS ID,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 somut = "select a.username from KULLANICI AS A "; SqlDataAdapter da = new SqlDataAdapter(somut, MyConnection); DataTable dt = new DataTable(); da.Fill(dt); dataGridView1.DataSource = dt; label1.Text = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value.ToString(); MyConnection.Close(); }