Gray Wolf Blog

When populating a tablelayoutpanel dynamically, the horizontal scrollbar kept appearing, even though there was no need for it.

It looks like there is no property to disable only the horizontal scrollbar, but I did find this workaround.

Pad the layoutpanel to the width of the horizontal scroll bar and the scroll bar will disappear.


int vertScrollWidth = SystemInformation.VerticalScrollBarWidth;

tableLayoutPanel1.Padding = new Padding(0, 0, vertScrollWidth, 0);


A quick and fun read.

The Graduate

Well written and re-searched.

The First Family: Terror, Extortion, Revenge, Murder, and the Birth of the American Mafia

Starts off strong, but tires in the later rounds. Mosley delivers for the most part.

The Long Fall

Well written and interesting. Good chapter on the origins of canning and lobster.

The Lobster Coast: Rebels, Rusticators, and the Struggle for a Forgotten Frontier

Fast paced and entertaining. The end is a bit of a mess. Characters seem plastic.

Good People

Started out with promise, but didn’t deliver.

The Blade Itself: A Novel

Strange and enjoyable book.

The Comedians (Penguin Classics)

I was getting an error saying the .Net provider could not be found when attempting to connect to a MySql db in hosted environment. If the MySql.Data.MySqlClient is not loaded in the GAC on the hosted server, you will need to add a reference in your web.config, if you want to use the SqlDataSource control.

1.  
2. web.config - make sure the version matches your MySqlClient version
3.  
4. <system.data>
5. <DbProviderFactories>
6. <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=5.2.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
7. </DbProviderFactories>
8. </system.data>
9.  
10. SqlDataSource reference
11.  
12. <asp:SqlDataSource ProviderName="MySql.Data.MySqlClient" ID="dsData" runat="server" ></asp:SqlDataSource>
13.  
14. Download this code: MySqlRemote.txt

Bourne Identity meets Upstairs / Downstairs. A bit stilted in places, but not bad overall.

The Ministry of Fear: An Entertainment (Penguin Classics)

Drags for bit, but soldiers on.

Long Time No See

Too bad the MySql GUI can’t handle this, but it is what it is:

If your text file lines end with carriage return / line feed, you will need \r in addition to \n to have clean data import:


LOAD DATA LOCAL INFILE 'c:\\www\\package.txt'
INTO TABLE businesscategory
LINES TERMINATED BY '\r\n'
(businesscategory);


Well written with flawed, empathetic characters.

Fort Apache, The Bronx

I think SSIS is great, but date formatting still remains a bit tricky. Would be nice to have a straight format function, but this is what I needed to use in the expression portion of the Derived Column Transformation Editor in order to get the date format YearMonthDay :

One of the better non-Carrella based 87th books.

Tricks

The computer and gambling chapters were interesting along with the sections involving Milken and Boesky. Some of the math discussions were a little much for late night reading.

Fortune’s Formula: The Untold Story of the Scientific Betting System That Beat the Casinos and Wall Street

Needless to say, this isn’t a very comforting message to get when you try to clear the Recycle Bin. What made it even weirder was there was nothing in the Recycle Bin.

To fix:

Start / Run / %systemdrive%\Recycler – this will give you the weird folder names for Recycle Bin – Something like : S-1-5-21-507921405-527237240-1801674531-1029

I had two folders under c:\recycler – went to CMD – cd \Recycler – then deleted all files / folders in Recycler and then deleted the c:\Recycler directory and rebooted.

That fixed the issue.

Still a good read the second time through

Black Betty : Featuring an Original Easy Rawlins Short Story “Gator Green”

Not much to recommend in this one.

Perish Twice (Sunny Randall)