private void Button1_Click(object sender, RoutedEventArgs e)
{
string connectionString = "User Id=TS;Password=1222;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=LOCALHOST)(PORT=1521))(CONNECT_DATA=(SID=JHBDCCS)));";
String queryString = "SELECT PICTURE FROM GOK WHERE ID = '10000001'";
OracleConnection oraConn = new OracleConnection(connectionString);
try
{
oraConn.Open();
OracleCommand oraCmd = new OracleCommand(queryString, oraConn);
OracleDataReader DataRd = oraCmd.ExecuteReader();
DataRd.Read();
MemoryStream ms = new MemoryStream((byte[])DataRd["PICTURE"]);
ms.Seek(0, SeekOrigin.Begin);
BitmapImage newBitmapImage = new BitmapImage();
newBitmapImage.BeginInit();
newBitmapImage.StreamSource = ms;
newBitmapImage.EndInit();
image1.Source = newBitmapImage;
}
catch (Exception ee)
{
MessageBox.Show(ee.Message.ToString());
}
}
WPF点击按钮直接显示数据库指定图片
最新推荐文章于 2024-05-22 16:57:50 发布