NG 202X

//저장하기

NpgsqlConnection conn = new NpgsqlConnection(connstring);

                conn.Open();

                // quite complex sql statement

                string sql = string.Format(@"

                    INSERT INTO io_table(

                    id, iotime, deviceid, userid, image)

                    VALUES ({0}, '{1}', '{2}', '{3}', :image)",

                    dataGridView1.Rows.Count + 1

                    , DateTime.Now.ToString("yyyyMMdd HH:mm:ss"), 1, 0001)

                ;

                // ファイルの内容をバイト配列に展開

                //byte[] bytes = File.ReadAllBytes("Lenna.jpg");

                MemoryStream ms = new MemoryStream();

                pictureBox1.Image.Save(ms,System.Drawing.Imaging.ImageFormat.Gif);

                byte[] bytes = ms.ToArray();

                //var sql = @"INSERT INTO test (image) VALUES (:image)";

                // データ登録

                //var cmd = new NpgsqlCommand(sql, con);

                //cmd.Parameters.Add(new NpgsqlParameter("image", NpgsqlDbType.Bytea) { Value = bytes });

                //cmd.ExecuteNonQuery();

                NpgsqlCommand comm = new NpgsqlCommand(sql, conn);

                comm.Parameters.Add(new NpgsqlParameter("image", NpgsqlDbType.Bytea) { Value = bytes });

                comm.ExecuteNonQuery();

                MessageBox.Show("Ok.");

// 불러오기

Type type = dr[5].GetType();

            if (type != DBNull.Value.GetType())

            {

                MemoryStream ms = new MemoryStream((byte[])dr[5]);

                Image returnImage = Image.FromStream(ms);

                pictureBox2.Image = returnImage;

            }

            else

            {

                pictureBox2.Image = null;

            }

create procedure sys.sp_lock --- 1996/04/08 00:00  

@spid1 int = NULL,  /* server process id to check for locks */  

@spid2 int = NULL  /* other process id to check for locks */  

as  

set nocount on  

/*  

**  Show the locks for both parameters.  

*/  

set transaction isolation level read committed  

if @spid1 is not NULL  

begin  

 select  convert (smallint, req_spid) As spid,  

  rsc_dbid As dbid,  

  rsc_objid As ObjId,  

  rsc_indid As IndId,  

  substring (v.name, 1, 4) As Type,  

  substring (rsc_text, 1, 32) as Resource,  

  substring (u.name, 1, 8) As Mode,  

  substring (x.name, 1, 5) As Status  

 from  master.dbo.syslockinfo,  

  master.dbo.spt_values v,  

  master.dbo.spt_values x,  

  master.dbo.spt_values u  

 where   master.dbo.syslockinfo.rsc_type = v.number  

   and v.type = 'LR'  

   and master.dbo.syslockinfo.req_status = x.number  

   and x.type = 'LS'  

   and master.dbo.syslockinfo.req_mode + 1 = u.number  

   and u.type = 'L'  

   and req_spid in (@spid1, @spid2)  

end  

/*  

**  No parameters, so show all the locks.  

*/  

else  

begin  

 select  convert (smallint, req_spid) As spid,  

  rsc_dbid As dbid,  

  rsc_objid As ObjId,  

  rsc_indid As IndId,  

  substring (v.name, 1, 4) As Type,  

  substring (rsc_text, 1, 32) as Resource,  

  substring (u.name, 1, 8) As Mode,  

  substring (x.name, 1, 5) As Status  

 from  master.dbo.syslockinfo,  

  master.dbo.spt_values v,  

  master.dbo.spt_values x,  

  master.dbo.spt_values u  

 where   master.dbo.syslockinfo.rsc_type = v.number  

   and v.type = 'LR'  

   and master.dbo.syslockinfo.req_status = x.number  

   and x.type = 'LS'  

   and master.dbo.syslockinfo.req_mode + 1 = u.number  

   and u.type = 'L'  

 order by spid  

end  

return (0) -- sp_lock