คือผมส่งสัย เกี่ยวกับ vb ครับ ในเรื่องของการสร้าง Textbox ขึ้นมา แล้วส่งค่ามาเก็บ ยังฐานข้อมูลอะ

 Sql = " INSERT INTO Pay_salary(id_sa,id,caek,date_pay)VALUES ('" & TextBox2.Text & "','" & TextBox3.Text & "','" & um & "','" & DateTimePicker1.Text & "') "
            Cmd = New SqlCommand(Sql, Cls.Con)
            Rs = Cmd.ExecuteReader

//Class interface (Convention style)

string MyConnectionString = "Data Source=(local);Initial Catalog=Test;Integrated Security=SSPI;";

//CREATE
string mySqlCommandText = "INSERT [A1] ([NAME]) VALUES (@VAR_NAME);");
using( SqlConnection myConnection = new SqlConnection( MyConnectionString) )
{
   try
   {
      SqlCommand myCommand = new SqlCommand(mySqlCommandText  ,myConnection) ;
      myCommand.Parameters.AddWithValue("@VAR_NAME" ,TextBoxAnyValue.Text.Trim()  ) ;
      myConnection.Open() ;
      myCommand.ExecuteNoneQuery();
   }
   catch(Exception ex)
   {
       // trap error here
   }
   finally
   {
      if(myConnection != null) myConnection.Close();
   }

}

//READ ONE VALUE
string mySqlCommandText = "SELECT [NAME] FROM [A1] WHERE [ID]=@VAR_ID;");
string keepStr = string.Empty ;

using( SqlConnection myConnection = new SqlConnection( MyConnectionString) )
{
   try
   {
      SqlCommand myCommand = new SqlCommand(mySqlCommandText  ,myConnection) ;
      myCommand.Parameters.AddWithValue("@VAR_ID" ,IdValue ) ;
      myConnection.Open() ;

      object temp= myCommand.ExecuteScalar() ;
      if (temp != null)
          keepStr = System.Convert.ToString(temp) ;
   }
   catch(Exception ex)
   {
       // trap error here
   }
    finally
   {
      if(myConnection != null) myConnection.Close();
   }
}

return keepStr ; // or any use



//READ All Entry Row
string mySqlCommandText = "SELECT *  FROM [A1] WHERE [ID]=@VAR_ID;");
HashTable keepData = new HashTable();

using( SqlConnection myConnection = new SqlConnection( MyConnectionString) )
{
   try
   {
      SqlCommand myCommand = new SqlCommand(mySqlCommandText  ,myConnection) ;
      myCommand.Parameters.AddWithValue("@VAR_ID" ,IdValue ) ;
      // not require open connection
      SqlDataAdapter myDataAdapter = new  SqlDataAdapter ();
      myDataAdaptor.SelectCommand = myCommand ;
      DataTable myTable = new DataTable() ;
      myDataAdaptor.Fill ( myTable ) ;

      if(myTable.Rows.Count > 0)
         foreach DataRow myRow in myTable.Rows
            foreach DataColumn myColumn in myTable.Columns
               keepData.Add(myColumn.ColumnName ,myRow[myColumn.ColumnName]) ;
   }
   catch(Exception ex)
   {
       // trap error here
   }
    finally
   {
      if(myConnection != null) myConnection.Close();
   }
}

return keepData; // or any use