Good morning, how could I insert the following code into the database? I hope you can help me.
Sub BtnCrearClick(sender As Object, e As EventArgs)
Dim IDColumna As New DataColumn(txtID.Text)
IDColumna.DataType=GetType(Integer)
IDColumna.AutoIncrement=True
Dim Nombre As New DataColumn(txtNombre.Text)
Nombre.DataType=GetType(String)
Dim App As New DataColumn(txtApp.Text)
App.DataType=GetType(String)
Dim Apm As New DataColumn(txtApm.Text)
Apm.DataType=GetType(String)
Dim TablaNombres As New DataTable(txtTabla.Text)
TablaNombres.Columns.Add(IDColumna)
TablaNombres.Columns.Add(Nombre)
TablaNombres.Columns.Add(App)
TablaNombres.Columns.Add(Apm)
TablaNombres.Constraints.Add("Key1", IDColumna, True)
Dim nombres As String()={"Aaron","Abel","Abelardo","Abraham","Adalberto","Adolfo","Adrian","Agustin","Alan","Alejandro",
"Benjamin","Bernardo","Baldomero","Baltasar","Barack"}
Dim apellidos As String()={"Pineda", "Bernal", "Espinoza", "Spindola", "Brisuela", "Gutierrez", "Escarcega", "Muñiz", "Lopez", "Martinez", "Piña",
"Vega", "Ortiz", "Barcenas", "Lopez", "Martinez"}
Dim paises As String()={"Estados Unidos","Mexico","Costa Rica","Jamaica","Panama","Haiti","Colombia","Venezuela","Ecuador","Peru",
"Bolivia","Chile","Brasil","Uruguay","Paraguay","Argentina"}
Dim aleatorio As New Random
Dim row As DataRow
Dim i As Integer
For i=1 To Convert.ToInt32(txtFilas.Text)
row=TablaNombres.NewRow()
row(txtID.Text)=i
If cbo2.SelectedItem = "Nombres" Then
row(txtNombre.Text)=nombres(aleatorio.Next(0,nombres.Length))
ElseIf cbo2.SelectedItem = "A.Paterno"
row(txtNombre.Text)=apellidos(aleatorio.Next(0,apellidos.Length))
ElseIf cbo2.SelectedItem = "Países"
row(txtNombre.Text)=paises(aleatorio.Next(0,paises.Length))
End If
row(txtApp.Text)=nombres(aleatorio.Next(0,nombres.Length))
row(txtApm.Text)=apellidos(aleatorio.Next(0,nombres.Length))
TablaNombres.Rows.Add(row)
Next
tabla1.DataSource=TablaNombres
End Sub