C# Textbox เชื่อม DATABASE คีย์รหัสลงTEXTBOX ต้องการให้ TEXTBOXชื่อ นามสกุล แสดงลงในTEXTBOX ทำไงครับ C#

    Private Sub lodlog()
        Dim objConn As New OleDbConnection
        Dim ds As New DataSet
        Dim dt As New DataTable
        Dim cn, strsql As String
        Dim dtAdapter As OleDbDataAdapter
        cn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Databasecus.accdb"
        objConn.ConnectionString = cn
        objConn.Open()
        strsql = "SELECT * FROM TBCUS WHERE CUSID = '" & TextBox1.Text & "' "
        dtAdapter = New OleDbDataAdapter(strsql, objConn)
        dtAdapter.Fill(dt)

        If dt.Rows.Count > 0 Then

            Me.TextBox2.Text = dt.Rows(0)("CUSNAME")

        End If
    End Sub

 private void lodlog()
        {
            DataTable dt = new DataTable();
            
           string cn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\\Databasecus.accdb";
          
           string strsql = "SELECT * FROM TBCUS WHERE CUSID = '" + textBox1.Text + "' ";
            OleDbDataAdapter dtAdapter = new OleDbDataAdapter(strsql, cn);
            dtAdapter.Fill(dt);


            if (dt.Rows.Count > 0)
            {
                this.textBox2.Text = dt.Rows(0)("CUSNAME");

            }

private void Form1_Load(object sender, EventArgs e)
        {
           // เรียกใช้ getrow
            this.Text = GetRow("connn", "SQL string")[0].ToString();
        }

        public DataRow GetRow(OleDbConnection cnn, string sql)
        {
            DataRow dr = null;
            if (cnn.State == ConnectionState.Open)
            {
                DataSet ds = new DataSet();
                DataTable dt = new DataTable();
                OleDbDataAdapter dtAdapter = new OleDbDataAdapter(sql, cnn);
                dtAdapter.Fill(dt);
                dr = dt.Rows[0];
            }
            return dr;
        }
         public DataRow GetRow(string strconn, string sql)
        {
            DataRow dr = null;

           using( OleDbConnection cnn = new OleDbConnection(strconn))
           {
             cnn.Open();
             dr = GetRow(cnn, sql);
           }
         return dr;
        }