private void btnKaydet_Click(object sender, EventArgs e) { FileStream fs = new FileStream(DosyaYolu, FileMode.Open, FileAccess.Read); BinaryReader br = new BinaryReader(fs); byte[] resim = br.ReadBytes((int)fs.Length); br.Close(); fs.Close(); using (SqlConnection LocalBaglanti = ConnectString.ConnectLocal()) { SqlCommand SqlCmd = new SqlCommand { CommandText = "INSERT into tbl_UlkeParaBirim VALUES(@bayrak, @ulke, @country, @parabirim, @currency, @sira, @simge)" }; SqlCmd.Parameters.Clear(); SqlCmd.Parameters.Add("@bayrak", SqlDbType.Image, resim.Length).Value = resim; SqlCmd.Parameters.AddWithValue("@ulke", txtUlkeTr.Text); SqlCmd.Parameters.AddWithValue("@country", txtUlkeEn.Text); SqlCmd.Parameters.AddWithValue("@parabirim", txtPara.Text); SqlCmd.Parameters.AddWithValue("@currency", txtParaBirim.Text); SqlCmd.Parameters.AddWithValue("@sira", txtGosterSira.Text); SqlCmd.Parameters.AddWithValue("@simge", txtParaSimge.Text); SqlCmd.Connection = LocalBaglanti; SqlCmd.ExecuteNonQuery(); }; }
private void btnGetir_Click(object sender, EventArgs e) { using (SqlConnection LocalBaglanti = ConnectString.ConnectLocal()) { SqlCommand SqlCmdDetay = new SqlCommand("Select * From tbl_UlkeParaBirim Where parabirim = '" + txtPara.Text + "'", LocalBaglanti); SqlDataAdapter SqlAdapter = new SqlDataAdapter(SqlCmdDetay); DataTable DtableDetay = new DataTable(); SqlAdapter.Fill(DtableDetay); if (DtableDetay.Rows.Count > 0) { txtUlkeTr.Text = DtableDetay.Rows[0].Field <string>("ulke"); txtUlkeEn.Text = DtableDetay.Rows[0].Field <string>("country"); txtParaBirim.Text = DtableDetay.Rows[0].Field <string>("currency"); txtParaSimge.Text = DtableDetay.Rows[0].Field <string>("simge").Trim(); txtGosterSira.Text = Convert.ToString(DtableDetay.Rows[0].Field <int>("sira")); Resim = (byte[])DtableDetay.Rows[0]["bayrak"]; using (MemoryStream ms = new MemoryStream(Resim)) { pictureBox1.Image = Image.FromStream(ms); } } SqlAdapter.Dispose(); LocalBaglanti.Close(); } }
void Comboboxlistele() { SqlConnection LocalBaglanti = ConnectString.ConnectLocal(); SqlCommand SqlCmdParaBirim = new SqlCommand("Select parabirim From tbl_UlkeParaBirim Order by sira", LocalBaglanti); SqlDataReader SqlReadBirim = SqlCmdParaBirim.ExecuteReader(); while (SqlReadBirim.Read()) { cbxPbirim.Items.Add(SqlReadBirim[0].ToString()); } SqlReadBirim.Close(); SqlCmdParaBirim.Dispose(); LocalBaglanti.Close(); }