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();
}
