Ver valores insertados en una tabla de una base de datos en MySQL con PowerShell | Scripting and security

[void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data")
$Connection = New-Object MySql.Data.MySqlClient.MySqlConnection
$ConnectionString = "server=" + "localhost" + ";port=3306;uid=" + "root" + ";pwd=" + ";database="+"estado"
$Connection.ConnectionString = $ConnectionString
$Connection.Open()

$Query='select PersonID,Estado from Persons'
$Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query, $Connection)
$DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command)
$DataSet = New-Object System.Data.DataSet
$RecordCount = $dataAdapter.Fill($dataSet, "data")
$DataSet.Tables[0]
$Connection.Close()

[void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data")

$Connection = New-Object MySql.Data.MySqlClient.MySqlConnection

$ConnectionString = "server=" + "localhost" + ";port=3306;uid=" + "root" + ";pwd=" + ";database="+"estado"

$Connection.ConnectionString = $ConnectionString

$Connection.Open()

$Query='select PersonID,Estado from Persons'

$Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query, $Connection)

$DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command)

$DataSet = New-Object System.Data.DataSet

$RecordCount = $dataAdapter.Fill($dataSet, "data")

$DataSet.Tables[0]

$Connection.Close()

679238881 611681438 634196088 603165142 620957431 633025837 681253723 600041372 635076117 659468774 643238881 676576284 603576867 666536722 681956878 629094845 615976409 641936701 620279689 620829700 662007514 676935128 661203041 619625784 628534161 619914377 646783366 636944264 629490664 663971511 638739248 615968448 621849106 610401369 630366458 651224344 689737711 681457960 681177966 638889877 665408019 634587168 614864067 662029163 636806076 672395803 636414237 665582602 670206777 655443375 688867027 610407454 680187094 650026497 608965649 629341996 653386160 692963509 633133094 610192746 650833228 675758642 646783243 690715869 602146838 668197787 696065316 622319644 605162250 645366062 688670360 672454949 603801925 611314733 617957107 624007124 655956631 626338818 640546878 617380092 626526638 677955658 625495625 643687869 610082462 677887050 633557010 611004798 656822987 675691828 652659660 657695113 647746717 639523077 676709829 616573058 635402333 675194731 616179704 674318740 600660730 606504467 668781793 659931727 618927066 604369690 638587317 639550838 624841115 682596692 658090134 669399118 640604960 660801456 679311060 667830281 676469152 690179046 698387621 690658827 656083330 627863462 660284248 651278763 605840180 679083267 659343914 697633198 674594473 695688156 611630584 691311583 638950921 677147553 611025749 642423402 670849416 656974985 621742185 666449774 616438781 686039265 664230239 651703579 650444205 666404957 639463597 687370057 625134484 669826564

Tutorial C# con PowerShell: iniciar un proceso y destruirlo pasado un tiempo

Activar y desactivar el audio desde PowerShell

Get RSS feed from jesusninoc.com