MS SQL Script Runner

Currently I'm making a script runner using C# WPF in visual studio 2010. It can run many MS-SQL scripts with the click of one button. This is a progress so far screen shot...

Features are :
Drag And Drop script files
Run a directory of script files
Sql Script out put messages during execution
Script passed or failed that are colored green and red (yellow for running)
Stop on error option
Open script on error option
Run report with time taken for each script
Total duration time
Test DB connection
Asynchronus
.Net 4 & tested with SQL 2008
Single exe file

More to come.....



Edit:

This is now complete. If anyone is interested just ask for the exe file. One of the biggest advantages with our script runner is that faster than the DB client library. We are using SMO library for execution, we managed to compile it for .net4. We have a large statement timeout but can abort at any time during the execution.

JoikuSpot - Changing the landing page.

I wanted to change the landing page for joikuspot.  I thought people who log onto my phone should have to see something that I want them to see first; almost as a prank. I searched around and came accross the following.
"This shows you where you can change the (URL) for the (landing page) in all versions of JoikuSpot Premium...


The (landing page) variable is found in the language file (IE; English = JoikuSpot_0x20010B5A.r01) that you are using for managing your version of the JoikuSpot Premiuminterface. So if you are using English, you would modify (C:/resource/apps/JoikuSpot_0x20010B5A.r01), if you are using French, you would modify (C:/resource/apps/JoikuSpot_0x20010B5A.r02). This is just to show you where it located so you can modify it to point to whatever url you want to use for your own personallanding page.



It doesn't matter what language file type you are using, you will find the the (URL) to change right before (192.168.0.1)"

To change this value I used a program called SISContents, this allows you navigate through the hidden phone system files. I realised then that the URL address in the file mentioned above had to be the exact same length to keep the file check sum correct. Then for signing I used a program called Markit SIS signer.


This how ever doesn't work! I can't see any other files that can be changed fo the landing page either.
I even tried with joikuspot light which has the redirect page turned on, but no luck, the same old usual landing page.

If anyone has any knowledge aobut this please let me know. It's very specific and i doubt anyone knows?

/// 

/// Returns the content of a given web adress as string.
/// 
/// URL of the webpage
/// Website content
public string DownloadWebPage(string Url)
{
    // Open a connection
    HttpWebRequest WebRequestObject = (HttpWebRequest)HttpWebRequest.Create(Url);
 
    // You can also specify additional header values like 
    // the user agent or the referer:
    WebRequestObject.UserAgent = ".NET Framework/2.0";
    WebRequestObject.Referer = "http://www.example.com/";
 
    // Request response:
    WebResponse Response = WebRequestObject.GetResponse();
 
    // Open data stream:
    Stream WebStream = Response.GetResponseStream();
 
    // Create reader object:
    StreamReader Reader = new StreamReader(WebStream);
 
    // Read the entire stream content:
    string PageContent = Reader.ReadToEnd();
 
    // Cleanup
    Reader.Close();
    WebStream.Close();
    Response.Close();
 
    return PageContent;
}

string PageContent = DownloadWebPage("http://www.jonasjohn.de/"); 

stupid iPhone 4s

Proud owner of a 4S as of yesterday but trying to add my Gmail account using Exchange is not working at all - I keep getting prompted to enter my password. I know this password is correct as I am logged into my PC.

When I set up my Gmail account using Gmail settings this works fine - thus proving I'm not insane and forgetting my password.

To add weight that this is a bug - my iPad (which is set up as intended) now prompts me for my password for the Gmail account - it has not done this before and has been running iOS5 since the 16th.

The settings match the ones on the iPhone 4 in the house which leaves me to think this is either related to my Gmail account (I don't see how as my Blackberry still lets me get access to my Gmail) or its either a 4s problem or iOS5 problem.

It didn't take long last night to find others having the same problem but I am yet to see any resolution of this and I actually lost sleep trying to think what else it could be.

Very frustrated as this works fine on the 4 in the house and was working on the iPad before initialising on the 4s.

singapore.zapto.org

My metal play list from high school days..a bit of nostalgia

http://www.youtube.com/watch?v=F_6IjeprfEs&list=PL19047A52D2283AC6&feature=plpp_play_all


... just some old time favorites

Justin.Tv

Justin.Tv is the future of the internet. It's interactive and has viewing pleasure for all people.

No more Aspartane or Phenylalanine

I think I've consumed to much of this and it's not the desired effect that one might hope. I believe from what I've read around the place and from what I've experienced that this is causing a spike in insulin which is making me more hungry and the body is entering into starvation mode.

Silk Central Test Case Tool with BIRT report

If anyone is using this software and needs a Birt Report to print all test cases for particular project or group of test cases I have a template that can be used. Feel free to email me if you require the code.


The best part is that Birt Reports is free. But.. not so intuitive


The template lets you enter the following parameters:-
pname - project name
cname - container name
fname - folder name

Here is test procedures with a table of contents plus the order number(step number) and page number.  In the middle of the code you will find the MS-SQL querey, the report template can be downloaded from here
http://www.megaupload.com/?d=61Q5BZUC

over ride company wallpaper

Ever get sick of your companies wall paper that has been set by the IT administrators. Then do this:

save the code below in a file named as wallPaper.reg
and run it





Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\System]
"NoDispAppearancePage"=dword:00000001
"Wallpaper"="C:\\Users\\Public\\Public Pictures\\Sample Pictures\\Desert.jpg"
"WallpaperStyle"="2"

C# email spoof

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Net.Mail;

namespace emailSpoof
{
    public class Class1
    {
        static public void Main()
        {
            String server = "<server>";

            MailAddress to = new MailAddress("john@hotmail.com");
            MailAddress from = new MailAddress("sarah@hotmail.com");
            MailMessage message = new MailMessage(from, to);

            message.Subject = "Hello!";
            message.Body = @"Hi, \n Hope you are well" ;

            SmtpClient client = new SmtpClient(server);

            try
            {
                client.Send(message);
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message, ex);
            }
        }
    }
}

C# Web browser with proxy support.

Its a stand alone .exe portable app all in one file.

It will detect your work proxy and tunnel through it. But not fully tested 

Or if you are in a country where websites are blocked internet can be tunneled using international proxies. 

Or post to public forums from an anonymous IP

Its a bit buggy, this is my first version, if it's useful i can keep working on it. Its a stand alone .exe portable app. And only one file.




can be found here


http://www.ipmart-forum.com/attachment.php?attachmentid=617521&d=1294681503

hello world

First post about nothing in particular