private void button8_Click(object sender, EventArgs e)
\n {
\n \/\/\u753b\u50cf\u30d5\u30a1\u30a4\u30eb\u3092\u66f4\u65b0\u3059\u308b
\n string file = Application.StartupPath + “\\\\1.jpg”;
\n byte[] imgBody = File.ReadAllBytes(file);
\n int x = gcMultiRowKamoku.CurrentRow.Index;<\/p>\n
string date = gcMultiRowKamoku.GetValue(x, “textINPDATA”).ToString();<\/p>\n
using (var con = new FbConnection(gro.conString))
\n {
\n try
\n {
\n using (FbCommand cmd = con.CreateCommand())
\n {
\n con.Open();
\n cmd.CommandText = “update chatGPT set imgBody = @imgBody where inpData = ‘” + date + “‘”;<\/p>\n
cmd.Parameters.Add(new FbParameter(“@imgBody”, imgBody));
\n cmd.ExecuteNonQuery();<\/p>\n
}<\/p>\n
}
\n catch (Exception ex)
\n {
\n noby.Message(ex.ToString(), m.Stop);
\n }
\n finally
\n {
\n con.Close();
\n }<\/p>\n
}<\/p>\n
}<\/p>\n
private void button5_Click_1(object sender, EventArgs e)
\n {\/\/\u753b\u50cf\u30d5\u30a1\u30a4\u30eb\u3092\u542b\u3080\u30c7\u30fc\u30bf\u3092\u767b\u9332
\n string file = Application.StartupPath + “\\\\1.jpg”;
\n byte[] imgBody = File.ReadAllBytes(file);<\/p>\n
int no = 0;
\n using (var con = new FbConnection(gro.conString))
\n {
\n try
\n {
\n using (FbCommand cmd = con.CreateCommand())
\n {
\n con.Open();
\n string sql = “”;
\n \/\/ \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u958b\u59cb
\n var tran = con.BeginTransaction();
\n cmd.Transaction = tran;<\/p>\n
\/\/ \u30c7\u30fc\u30bf\u767b\u9332
\n cmd.CommandText = @”INSERT INTO chatGPT (inpData,title,question,answer,remarks,imgBody) VALUES (@inpData,@title,@question,@answer,@remarks,@imgBody) “;<\/p>\n
cmd.Parameters.Add(“@inpData”, FbDbType.TimeStamp).Value = DateTime.Now.ToString(“yyyy\/MM\/dd HH:mm”);
\n cmd.Parameters.Add(“@title”, FbDbType.VarChar).Value = “”;
\n cmd.Parameters.Add(“@question”, FbDbType.VarChar).Value = “”;
\n cmd.Parameters.Add(“@answer”, FbDbType.VarChar).Value = “”;
\n cmd.Parameters.Add(“@remarks”, FbDbType.VarChar).Value = “”;
\n cmd.Parameters.Add(“@imgBody”, FbDbType.Binary).Value = imgBody;
\n cmd.ExecuteNonQuery();
\n \/\/ \u3053\u3053\u3067\u30b3\u30df\u30c3\u30c8
\n tran.Commit();
\n }<\/p>\n
}
\n catch (Exception ex)
\n {
\n noby.Message(ex.ToString(), m.Stop);
\n }
\n finally
\n {
\n con.Close();
\n }<\/p>\n
}<\/p>\n
}<\/p>\n
private void button7_Click(object sender, EventArgs e)
\n {
\n \/\/\u767b\u9332\u3057\u305f\u753b\u50cf\u304b\u3089\u30d5\u30a1\u30a4\u30eb\u3092\u518d\u751f\u3059\u308b
\n try
\n {
\n int x = gcMultiRowKamoku.CurrentRow.Index;
\n string date = gcMultiRowKamoku.GetValue(x, “textINPDATA”).ToString();
\n byte[] b = (byte[])DB.SelectData(date).Rows[0][“imgBody”];<\/p>\n
if (b != null)
\n {
\n string file = gro.deskTopFolderString + “\\\\2.jpg”;
\n Image newImage = Func.ByteArrayToImage(b);
\n \/\/\u30d5\u30a1\u30a4\u30eb\u62e1\u5f35\u5b50\u306e\u78ba\u8a8d
\n if (newImage.RawFormat.Equals(ImageFormat.Jpeg))
\n {
\n noby.Message(“Jpeg”);
\n }<\/p>\n
if (newImage.RawFormat.Equals(ImageFormat.Png))
\n {
\n noby.Message(“Png”);
\n }
\n newImage.Save(file);
\n }<\/p>\n
}
\n catch (DirectoryNotFoundException)
\n {
\n noby.Message(“\u8aad\u307f\u51fa\u3059\u30d5\u30a1\u30a4\u30eb\u304c\u5b58\u5728\u3057\u307e\u305b\u3093”);<\/p>\n
}
\n catch (Exception ex)
\n {
\n noby.Message(ex.ToString(), m.Stop);<\/p>\n
}
\n }<\/p>\n","protected":false},"excerpt":{"rendered":"
private void button8_Click(object sender, EventArgs e) { \/\/\u753b\u50cf\u30d5\u30a1\u30a4\u30eb\u3092\u66f4\u65b0\u3059\u308b string file = Application.StartupPath + […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","_lightning_design_setting":[],"footnotes":""},"categories":[22],"tags":[],"class_list":["post-1251","post","type-post","status-publish","format-standard","hentry","category-firebird"],"_links":{"self":[{"href":"https:\/\/prg.waou.biz\/index.php?rest_route=\/wp\/v2\/posts\/1251","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prg.waou.biz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prg.waou.biz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prg.waou.biz\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/prg.waou.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1251"}],"version-history":[{"count":1,"href":"https:\/\/prg.waou.biz\/index.php?rest_route=\/wp\/v2\/posts\/1251\/revisions"}],"predecessor-version":[{"id":1252,"href":"https:\/\/prg.waou.biz\/index.php?rest_route=\/wp\/v2\/posts\/1251\/revisions\/1252"}],"wp:attachment":[{"href":"https:\/\/prg.waou.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prg.waou.biz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1251"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prg.waou.biz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}