Digital Efforts

Internet Consulting and Development

Already a member?  Login
Find by Topic
Blog (.Net)

Here's a simple script that demonstrates Powershell access to MySQL.

[void][system.reflection.Assembly]::LoadFrom("C:\Program Files\MySQL\MySQL Connector Net 5.2.3\Binaries\.NET 2.0\MySQL.Data.dll"
 
$myconnection = New-Object MySql.Data.MySqlClient.MySqlConnection 
$myconnection.ConnectionString = "server=localhost;user id=root;password=password;database=mysql;pooling=false" 
$myconnection.Open() 
 
$mycommand = New-Object MySql.Data.MySqlClient.MySqlCommand 
$mycommand.Connection = $myconnection 
$mycommand.CommandText = "SHOW TABLES" 
 
$myreader = $mycommand.ExecuteReader() 
 
while($myreader.Read()){ $myreader.GetString(0) } 
 
$myreader.Close() 
 
$myconnection.Close() 

0 Comments Share Print
Gravatar
digitalefforts Sunday, March 01, 2009 @ 10:16 pm

After a few tries here is the Visual Basic code that will post to Twitter.

Imports System
Imports System.Net
Imports System.Web
Imports System.IO
 
Public Class Twitter
    Public Shared Function PostTweet(ByVal username As String, ByVal password As String, ByVal tweet As String) As String
        Try
            System.Net.ServicePointManager.Expect100Continue = False
 
            Dim bytes() As Byte = System.Text.Encoding.ASCII.GetBytes("status=" & tweet)
 
            Dim request As HttpWebRequest = CType(WebRequest.Create("http://twitter.com/statuses/update.xml"), HttpWebRequest)
            request.Credentials = New System.Net.NetworkCredential(username, password)
            request.Method = "POST"
            request.ContentType = "application/x-www-form-urlencoded"
            request.ContentLength = bytes.Length
 
            Dim reqStream As Stream = request.GetRequestStream()
            reqStream.Write(bytes, 0, bytes.Length)
            reqStream.Close()
 
            Dim response As HttpWebResponse = request.GetResponse
            Dim reader As New System.IO.StreamReader(response.GetResponseStream)
 
            Dim retValue As String = reader.ReadToEnd()
            reader.Close()
 
            Return ""
        Catch ex As Exception
            Return "error"
        End Try
    End Function
End Class

To call:

If String.IsNullOrEmpty(PostTweet("user", "password", "Here's my tweet...")) Then
   ' Success
Else
   ' Failure
End If
0 Comments Share Print
Gravatar
digitalefforts Saturday, February 14, 2009 @ 7:01 pm
Site © Copyright 2007-2010, BubbleLife Media LLC Privacy Policy Terms of Use
Tuesday, September 07, 2010 4:10 AM
Powered by BubbleCommunities 0.9.0.3550.64
BUBBLELIFE, BUBBLELIFE MEDIA, BUBBLECOMMUNITIES and NEIGHBORHOOD BRANDS are trademarks of BubbleLife Media LLC. Unauthorized use is prohibited.