プログラミングの最近のブログ記事

For Each dr As DataRow In DataTable1.Rows

    HTOld(dr("職種", DataRowVersion.Original).ToString) = dr("人数", DataRowVersion.Original).ToString

    HTNew(dr("職種").ToString) = dr("人数").ToString

Next

System.Data.VersionNotFoundException: 'アクセスする Original データがありません。'

If dr.RowState <> DataRowState.Added Then

    HTOld(dr("職種", DataRowVersion.Original).ToString) = dr("人数", DataRowVersion.Original).ToString

End If

If dr.RowState <> DataRowState.Deleted Then

    HTOld(dr("職種") = dr("人数").ToString

End If

IF hogehoge THEN

    dataGrid1.Columns(1).Frozen = True

ELSE

    dataGrid1.Columns(4).Frozen = True

END IF

IF hogehoge THEN

    dataGrid1.Columns(4).Frozen = False

    dataGrid1.Columns(1).Frozen = True

ELSE

    dataGrid1.Columns(1).Frozen = False

    dataGrid1.Columns(4).Frozen = True

END IF

FOR i AS Integer 0 TO dataGrid1.Columns.Count - 1 

    dataGrid1.Columns(i).Frozen = False

NEXT

（例）

export LC_CTYPE=ja_JP.eucJP; /usr/bin/unzip -OCP932 -d /tmp exsample.zip

export LC_CTYPE=ja_JP.UTF-8

using System;

using System.Collections.Generic;

using System.Data;

using System.Data.SqlClient;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

dbaccess();

        static void dbaccess()

        {

            string dataSource, initCatalog, userId, passWord, connectionString;

            dataSource = "DBSERVER\\MSSQL2019";

            initCatalog = "InazumaDB";

            userId = "sa";

            passWord = "hogepass";

            connectionString = @"Data Source=" + dataSource + ";Initial Catalog=" + initCatalog + ";User ID=" + userId + ";Password=" + passWord;

            string query_s = "SELECT TOMO_ID, TOMO_NAME, TOMO_MEMO FROM InazumaDB.dbo.M_TOMODACHI";

            using (SqlConnection conn = new SqlConnection(connectionString))

            {

                //接続

                conn.Open();

                //SQL文を作成

                SqlCommand command_s = new SqlCommand(query_s, conn);

                using (SqlDataReader reader = command_s.ExecuteReader())

                {

                    //繰り返し読み込み

                    while (reader.Read())

                    {

                        //1～3列目の値を表示

                        Console.WriteLine(String.Format("{0}, {1}, {2}", reader[0], reader[1], reader[2]));

                    }

                }

                conn.Close();

            }

        }

      1, アンモニア治郎, おごってくれるから友達

      2, クロム陽子, かわいいから友達

     14, ばいじん太郎, 事業に失敗したからそろそろ切ろう

RZ10011 Component 'login' starts with a lowercase character. Component names cannot start with a lowercase character.

    var Connection = require('tedious').Connection;  

    var config = {  

        server: 'DBSERVER\\MSSQL2019',

        authentication: {

            type: 'default',

            options: {

                userName: 'sa',

                password: 'hogepass'

            }

        },

        options: {

            encrypt: true,

            database: 'InazumaDB'

        }

    }; 

    var connection = new Connection(config);  

    connection.on('connect', function(err) {  

        if (err) {

            console.log(err);

        } else {

            console.log('CONNECT');

        }

    });

    connection.connect();

C:\Users\shinoda>node connect_test.js

ConnectionError: Failed to connect to DBSERVER\MSSQL2019:1433 - getaddrinfo ENOTFOUND DBSERVER\MSSQL2019

    at Connection.socketError (C:\Users\shinoda\node_modules\tedious\lib\connection.js:1404:28)

    at C:\Users\shinoda\node_modules\tedious\lib\connection.js:1185:14

    at process.processTicksAndRejections (node:internal/process/task_queues:77:11) {

  code: 'ESOCKET',

  isTransient: undefined

}

C:\Users\shinoda>sqlcmd -S DBSERVER\MSSQL2019 -U sa -P hogepass -d InazumaDB

1> SELECT * FROM M_TOMODACHI;

2> GO

TOMO_ID TOMO_NAME             TOMO_MEMO                              

------- --------------------- ---------------------------------------

      1 アンモニア治郎        おごってくれるから友達

      2 クロム陽子            かわいいから友達

     14 ばいじん太郎          事業に失敗したからそろそろ切ろう

(3 行処理されました)

1>

gTimer1.Interval = 1000; // 1秒ごとに処理を行う

gTimer1.Elapsed += Timer_Elapsed; // Elapsedイベントハンドラーを設定

gWmp.settings.volume = 20; // ボリュームを 20に
gWmp.URL = filepath.Text; // MP3ファイルのパスを設定

gWmp.controls.play(); // 再生開始

gTimer1.Start(); // タイマーを開始

private void Timer_Elapsed(object sender, ElapsedEventArgs e)

{

if (gWmp.playState == WMPPlayState.wmppsStopped) { // WMP のステータスが「終了」？

gTimer1.Stop(); // タイマーを終了

＜再生終了時の処理＞

}

}

550-5.7.26 This mail is unauthenticated, which poses a security risk to the

550-5.7.26 sender and Gmail users, and has been blocked. The sender must

550-5.7.26 authenticate with at least one of SPF or DKIM. For this message,

550-5.7.26 DKIM checks did not pass and SPF check for [www.exsample.co.jp] did

550-5.7.26 not pass with ip: [210.XXX.XXX.XXX]. The sender should visit

550-5.7.26  https://support.google.com/mail/answer/81126#authentication for

550 5.7.26 instructions on setting up authentication.

# nslookup -q=TXT exsample.co.jp

exsample.co.jp   text = "v=spf1 ip4:202.XXX.XXX.XXX ip4:163.XXX.XXX.XXX ip4:210.XXX.XXX.XXX include:spf.securemx.jp ~all"

    $mail_data = <<EOM;

From: admin@exsample.co.jp

To: hogehoge@gmail.com

Subject: TEST MAIL

MIME-Version: 1.0

Content-type: text/plain; charset=ISO-2022-JP

Content-Transfer-Encoding: 7bit

X-Mailer: CGI-Script

test death.

EOM

    if (!open (MAIL,"| sendmail -t")) {

        print "Error : Mail Send\n";

    }

    print MAIL $mail_data;

    close(MAIL);

    if (!open (MAIL,"| sendmail -t -f admin@exsample.co.jp")) {

        print "Error : Mail Send\n";

    }

SELECT TO_CHAR(SYSDATE, 'YYYY/MM/DD HH24:MI:SS') AS dt FROM DUAL;

SELECT 名前, 年齢 FROM 個人情報

SELECT SYSDATETIME() AS dt

SELECT NOW() AS dt