在SQL映像字段中保存并打开图像 [英] Save and open image in SQL image field
本文介绍了在SQL映像字段中保存并打开图像的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
你好
我做了Visual C #WindowsFormsApplication Project,然后我添加了SQL数据库。
我有图像类型的列。
如何使用此字段保存和打开图像(例如.jpg)。
我的图像栏:zdjecie_dzialki
http://img1.aukcjoner.pl/gallery/013940161/1_f.jpg [ ^ ]
感谢您的帮助!
从数据库加载数据的代码:
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 = 数据源= C:\\Users \\ Madin \ \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在哪里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]。行[ 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();
解决方案
请查找与使用c#在sql数据库中存储和检索图像相关的CodeProject文章。
C#保存并加载图片来自数据库 [ ^ ]
它还包括示例代码。
这是另一种解决方案。
请找到复制的样本数据库表,保存图像并检索它。
CREATE TABLE员工
(
Id int,
Name varchar(50)not null,
Photo varbinary(max)not null
)
INSERT INTO Employees(Id ,名称,照片)
SELECT 10,'John',BulkColumn
来自Openrowset(Bulk'C:\photo.bmp',Single_Blob)作为EmployeePicture
我使用了这个解决方案:
http: //tech.cybernet.lu/?p=21 [ ^ ]
现在我遇到问题
byte [] imgByteData = Convert.ToByte(sdr.Item( Picture ));
http://img1.aukcjoner。 pl / gallery / 013943067 / 1_f.jpg [ ^ ]
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();
解决方案
Please find a CodeProject article related to storing and retrieving images in sql database with c#.
C# Save and Load Image from Database[^]
It include sample code also.
Here is another solution.
Please find copied a sample Database table which save images and retrieve it.
CREATE TABLE Employees ( Id int, Name varchar(50) not null, Photo varbinary(max) not null ) INSERT INTO Employees (Id, Name, Photo) SELECT 10, 'John', BulkColumn FROM Openrowset( Bulk 'C:\photo.bmp', Single_Blob) as EmployeePicture
I used this solution:
http://tech.cybernet.lu/?p=21[^]
Now I have problem with
byte[] imgByteData = Convert.ToByte(sdr.Item("Picture"));
这篇关于在SQL映像字段中保存并打开图像的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文