Save and open image in SQL image field

See more:

SQL-CE

C#

SQL-Server

, +

Hello

I made Visual C# WindowsFormsApplication Project and next I added SQL database.

I have column with "image" type.

How can I save and open image (for example .jpg) using this field.

My image column: "zdjecie_dzialki"

http://img1.aukcjoner.pl/gallery/013940161/1_f.jpg[^]

Thanks for help!

My code to load data from database:

System.Data.SqlServerCe.SqlCeConnection con;
System.Data.SqlServerCe.SqlCeDataAdapter da;

DataSet ds_nr_dzialki;
DataSet ds_wlasciciel_dzialki;
DataSet ds_pow_dzialki;

string zapytanie_nr_dzialki;
string zapytanie_wlasciciel_dzialki;
string zapytanie_pow_dzialki;

con = new System.Data.SqlServerCe.SqlCeConnection();
con.ConnectionString = "Data      Source=C:\\Users\\Marcin\\Desktop\\BazaDanychMapKatastralnych\\WindowsFormsApplication1\\BazaDan ychMapKatastralnych.sdf";
con.Open();
con.Close();



    zapytanie_nr_dzialki = textBox1.Text;
    ds_nr_dzialki = new DataSet();
    string sql = "SELECT * FROM tabela_dzialki WHERE nr_dzialki =" +                zapytanie_nr_dzialki;
    da = new System.Data.SqlServerCe.SqlCeDataAdapter(sql, con);
    da.Fill(ds_nr_dzialki, "Dzialki");

    DataRow dRow = ds_nr_dzialki.Tables["Dzialki"].Rows[0];
    textBox_nr_dzialki.Text = dRow.ItemArray.GetValue(0).ToString();
    textBox_wlasciciel_dzialki.Text = dRow.ItemArray.GetValue(1).ToString();
    textBox_pow_dzialki.Text = dRow.ItemArray.GetValue(2).ToString();
    textBox_adres_dzialki.Text = dRow.ItemArray.GetValue(3).ToString();
    textBox_skala_dzialki.Text = dRow.ItemArray.GetValue(4).ToString();
    textBox_oznwydz_dzialki.Text = dRow.ItemArray.GetValue(5).ToString();
    textBox_nrksiegi_dzialki.Text = dRow.ItemArray.GetValue(6).ToString();
    textBox_typksiegi_dzialki.Text = dRow.ItemArray.GetValue(7).ToString();
    textBox_nrprowksiege_dzialki.Text = dRow.ItemArray.GetValue(8).ToString();
    textBox_datazap_dzialki.Text = dRow.ItemArray.GetValue(9).ToString();