Lookin' At Dot Net

Using REGEX to Change Case Selectively

2011-07-26T10:00:00.006-04:00

I had a list of generic medications where the names were capitalized. I needed to change the spelling to lower case, which is the accepted way to spell them.

However, converting the medication name ToLower was too simplistic, since certain capitals needed to be preserved:

abobotulinumtoxinA
alteplase, tPA
aspirin, ASA
avian influenza A (H5N1) virus vaccine

Here is the code I used:


private string ConvertStringToLC(string name)
{

foreach (Match m in Regex.Matches(name, @"[A-Z]{1}[a-z]+"))
{
name = name.Substring(0, m.Index ) + char.ToLower(name[m.Index]) + name.Substring(m.Index + 1);
}

return name;
}

Because I was updating a sql database column I also had to take care of strings that had an apostrophe in them, such as burow's solution.


drugNameNew = drugNameNew.Replace("'", "''");

One last thing. If the generic drug name is used at the start of sentence it needs to be capitalized.


drugNameGeneric = char.ToUpper(drugNameGeneric[0]) + drugNameGeneri.Substring(1);

How to Convert an Image in jpg or other Format to an Icon

2011-07-11T14:44:00.002-04:00

To convert an image in jpg or other format to an Icon

Open the image in Ms Paint

Click on File -> Save As and

1. Choose “Save as Type” as 24-bit Bitmap(*.bmp)
and
2. name the file with an extention of .ico: TheFileName.ico

The image does not need to be resized (to 32 x 32 or other icon size)

Two C# Solutions for the FizzBuzz Problem

2011-02-01T17:38:00.003-05:00

In case you are interested...


namespace FizzBuzz
{
    class Program
    {
        static void Main(string[] args)
        {
            const string fizz = "FIZZ";
            const string buzz = "BUZZ";
            const string fizzbuzz = "FIZZBUZZ";

            // I did this solution second
            for (int i = 1; i < 101; i++)
            {
                string output;
                if (i / 15 * 15 == i) output = fizzbuzz;
                else if (i / 3 * 3 == i) output = fizz;
                else if (i / 5 * 5 == i) output = buzz;
                else output = i.ToString();
                Console.WriteLine(output);
            }

            // and this solution third 
            for (int i = 1; i < 101; i++)
            {
                string output = (i / 15 * 15 == i) ? fizzbuzz : (i / 3 * 3 == i)
                    ? fizz : (i / 5 * 5 == i) ? buzz : i.ToString();
                Console.WriteLine(output);
            }
   
            Console.ReadLine();
        }
    }
}
// Trust me, you don't want to see the one I did first.

Thoughts on n-Tiered Programming

2011-01-25T15:06:00.003-05:00

One of the problems that I had when first learning Object Oriented Programming was that the examples shown to illustrate concepts were so basic that they made no sense.

Why add piles of seemingly needless complexity when there were much easier and more straightforward ways to program solutions?

Why code interfaces that didn’t seem to add anything but more programming work and confusion?

Why create multiple Layers when all I was doing was passing unchanged values down the chain?

A lot of it started to make sense when I started doing things that were more complicated.

If the data does not change as it is passed from one layer to the next, having multiple layers doesn’t seem to make sense.

However, imagine a more usual scenario where the way your data is stored in the database does not match what is displayed in the UI.

Then it starts to get interesting.

I find it helps to think of n-tiered programming this way: The BusinessLayer translates between the data in the database and the data in the UI.

I usually have a more or less one to one correspondence between the data in the database and the objects which are created in the DataLayer and passed back and forth to the BusinessLayer.

I usually have a more or less one to one one correspondence between the data in the BusinessLayer and the data in the UI.

The BusinessLayer is where the translation happens. This is whether retrieving data from the database to display in the UI, or collecting data entered in the UI and storing it in the database.

(My other layer is an EntitiesLayer. I contains classes with properties to store the data for passing around.)

Outlook 2007 Cannot start Microsoft Outlook. Cannot open the Outlook window

2011-01-06T08:31:00.003-05:00

Outlook starts to open, but then gets the error in the title of this post.

Fixed by running outlook.exe /resetnavpane in the All Programs textbox:

Disable Windows7 Automatic Resize to Max

2011-01-03T12:11:00.003-05:00

Windows 7 has a feature where, when you drag a midsize window to the edge of the screen, Windows 7 maximizes it.

I found this really annoying because I frequently have several partial windows open and I drag some over to the side so they don't block each other.

To turn this feature off:

Control Panel -> Ease of Access Center

select Make the Mouse Easier to Use

check Prevent windows from being automatically arranged...

ok to save setting

Which Templated Checkboxes in an Infragistics Webdatagrid Column are Checked

2010-10-29T17:26:00.003-04:00

This is the codebehind I use to see which templated checkboxes in an infragistics webdatagrid column are checked.

 
       private void TakeActionOnSelectedCustomers ()
        {
            if (igWdgCustomers.Rows.Count != 0)
            {
                foreach (GridRecord row in igWdgCustomers.Rows)
                {
                    CheckBox theCB = (CheckBox)row.Items[0].FindControl("cbSelect");
                        if ( theCB!= null && theCB.Checked)  
               //  check for null because footer row doesn’t have cb 
                        {
                             //  take action 
                        }
                }
            }
        }

This is the column being checked.


   <ig:TemplateDataField Key="cbSelect" width="30px">
            <Header Text=" "   />
               <ItemTemplate>
                 <asp:CheckBox ID="cbSelect" runat="server" />
                </ItemTemplate>
   </ig:TemplateDataField>

In this case the checkbox is not databound, but it could be.

I have not found a way to use the CRUD feature of the datasource that the WebDataGrid uses to update the db value of a boolean represented by a databound checkbox.

DateTime.ParseExact

2010-08-27T17:30:00.000-04:00

So after never having had CultureInfo.CurrentCulture on my radar, I ended up using it twice this week.

For the first use, see my previous post on ToUpperInvariant().

Today, I ran into a problem where I tried DateTime.Parse on a string which I had generated in a gridview using:


<asp:BoundField DataField="DateStarted"  
     DataFormatString="{0:ddd MMM d hh:mmtt}" />

The compiler couldn't parse it.

I ended up having to decode it using the following:

DateTime dateCreated =DateTime.ParseExact(sdateCreated,
"ddd MMM d hh:mmtt", CultureInfo.InvariantCulture);

ToUpperInvariant()

2010-08-27T14:50:00.011-04:00

Whoa! Jon Skeet answered a question of mine on StackOverflow this week! I am honored.

The question was:

In C# what is the difference between ToUpper() and ToUpperInvariant()?

And the answer was, in a nutshell, "Unless you are programming in Turkish, no difference."

What brought me to ask that question started with a need to always reformat user input for first and last name with Initial Letter Case: first letter capitalized, rest lower case. (I know, I know, this is not all last names follow this convention, but hey, I didn't define the user requirements.) (In word I use Shift-F3 all the time.)

So I went looking in intellisense for a string method called InitialLetterCase(). After all, there are string methods ToUpper() and ToLower().

There was no InitialLetterCase() method, but I found ToUpperInvariant(). What did that do? I did a google search but the first few hits didn't seem to answer the question.

So thank you, Jon Skeet and StackOverflow, for the answer.

FYI, the solution to my request is a simple

tbFirstName.Text =
CultureInfo.CurrentCulture.TextInfo.ToTitleCase(tbFirstName.Text); :

RegisterStartupScript vs Response.Write

2010-07-07T14:06:00.006-04:00

Even though putting windows popup alerts into your UI can be bad design, annoying to your users, etc, sometimes it's just what you need to get the job done. I feel it's ok to use an occasional windows alert, as long as you don't abuse them.

If you are also using Ajax, you have a choice of 2 ways to program that alert from the code behind: Response.Write or ScriptManager.RegisterStartupScript.

The difference is that Response.Write will popup an alert box before the page loads, ie on a white background, and ScriptManager.RegisterStartupScript will pop it up after the page has loaded, so the page is visible behind the popup.

I prefer using ScriptManager.RegisterStartupScript, but maybe I just haven't come across an application where Response.Write would be better.

In any case, the following is the code to use for each case:

Response.Write("<script language='javascript'>
alert('This pops up on a blank page
(ie before the page loads) using response.write');</SCRIPT> ");

ScriptManager.RegisterStartupScript(this, typeof(Page), UniqueID,
"alert('This pops up after the page loads,
using ScriptManager.RegisterStartupScript');", true);

I have also popped up an alert on pageload by using the following in the html < body> tag of the page:

<body onLoad="alert('Update. \r\n \r\n Thank you for your interest,
\r\n however, \r\n we are not taking any new orders at this time.')" >
The \r\n causes a line break.

Because I always forget proc names ...

2010-06-29T14:10:00.001-04:00

protected void Page_PreInit(object sender, EventArgs e)
{
string msg = "Fires 1";
}

protected void Page_Init(object sender, EventArgs e)
{
string msg = "Fires 2";
}

protected void Page_Load(object sender, EventArgs e)
{
string msg = "Fires 3";
}

protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
string msg = "Fires last";
}

WebDataGrid Numeric Pager Truncates List of Page Numbers

2010-06-17T21:33:00.006-04:00

The WebDataGrid Numeric Pager was truncating the list of page numbers after reaching the end of the one line (table width) allocated for the pager display, as shown in the example below. There were scroll bars for the height and width of the data records, but no way to scroll past the end of the line of numbers and see page 21 in this example:

My solution was to create the following Css

<style type="text/css">
.tallPager {
height: 100px;
word-wrap: break-word;
text-align:left;
}
</style>

and apply it to the Paging property


  <Behaviors>
        <ig:Paging PageSize="25" PagerMode="Numeric" EnableInheritance="True"
             PagerCssClass="tallPager" />

etc...

The following shows the pager section for a different table, with the PagerCssClass ="tallPager"

Note: Word wraps can occur in the middle of a page number like 108:

Fortunately, I have a higher class of users and they were able to deal with that.

tsql INSERT INTO for bulk copy of records from SqlServer table to table

2010-05-17T19:17:00.003-04:00

I have been using tsql

Select * into Tbl2 from Tbl1 where FName = 'David'

for a long time, as a shortcut to create new table Tbl2, a copy of Tbl1 including schema and data.

I'm glad I finally found out about :

Insert into Tbl2 ( LastName , FirstName , AdmitDate) select Last, First, RevDate from Tbl1 where FName = 'David'

to use when Tbl2 is already in existence.

Calling all Technical Women in Technology for...

2010-05-14T14:20:00.009-04:00

What we have all been waiting for ...

A NJ Technical Women in Technology
Event

Register Now ->

Recommended Audiences: IT Professionals, Administrators, Developers, Architects

Are you a Technical Women in Technology?

Are you tired of always being surrounded by technical males that don't ____ (fill in the blank)?

Are you tired of trying to explain your technical issues to other women that just don't get it?

Are you looking to connect with other women with common interests?

Then, you may be interested in helping to form a Technical Women in Technology Group...

Refreshments: Appetizers & Water/Soda

Sponsors: Microsoft / SetFocus

Purpose:

To allow NJ Technical Women in Technology to meet and to discuss a future direction for a group

Event Updates: updates

Agenda:

Overview

Attendee Introductions

Panel Discussion (2-3 women sharing their experiences as a Technical Women in Technology

Future Direction Discussion - In-Person and/or Virtual meetings, frequency, meeting content, etc.

For Additional Information about how you can help kick start this community, please email melissa[@]sqldiva.com.

Include a derived control in my aspx page

2010-04-27T12:11:00.005-04:00


<%@ Register Assembly="iProjectName" Namespace="iNamespceInCsFile" TagPrefix="ifc" %>

use tag prefix and control name in aspx


<ig:TemplateDataField Key="key1" Width="30px">
     <ItemTemplate>
     <ifc:CtrlClass ID="id1" runat="server" Text='<%# Eval "BoundCol1") %>' />
     </ItemTemplate>
</ig:TemplateDataField>

"CtrlClass" is the derived control class name, which is in a cs file name doesn't matter, but namespace is "iNamespceInCsFile" in project ="iProjectName".

public class Comment2 : TextBox
{ etc ...

Comparison of ig bound Templated Checkbox to boolean BoundDataField

2010-03-23T11:03:00.006-04:00


Shows up as text "true" or "false":
        <ig:BoundDataField DataFieldName="IsCostSaving" Key="IsCostSaving" width="30px">
            <Header Text="Cost Saving" />
          </ig:BoundDataField>    

Shows up as a checkbox with checked value picked up from bound field:
         <ig:TemplateDataField Key="cb1" width="30px">
            <Header Text="Cost Saving" />
               <ItemTemplate>
                 <asp:CheckBox ID="cb1" runat="server"  Checked='<%# Eval("IsCostSaving") %>' Enabled="false"  />
                </ItemTemplate>
          </ig:TemplateDataField>

Looping thru Infragistics WebDataGrid on the Server

2010-03-22T11:06:00.003-04:00

Took me a while to find this. With some help from ig, thank you Chandradeep!


         protected void Button1_Click(object sender, EventArgs e)
          {
              //  loop thru selected cells and get their values 
                 foreach (GridRecordItem itm in WebDataGrid1.Behaviors.Selection.SelectedCells)
                  {
                      object ttt = itm.Text ;
                  }
            
              // example of  looping thru selected rows and getting values of columns
              foreach (GridRecord row in WebDataGrid1.Behaviors.Selection.SelectedRows)
              {
                  object ttt = row;
                  GridRecordItem itm = row.Items[0];
                  string sffssdf = itm.Text;
                  itm = row.Items[1];
                  sffssdf = itm.Text;
                  itm = row.Items[2];
                  sffssdf = itm.Text;
              }

              // example of  looping thru all rows and getting values of columns
              foreach (GridRecord row in WebDataGrid1.Rows)
              // foreach (GridRecordItem row in WebDataGrid1.Behaviors.Selection.SelectedCells)
              {
                  object ttt = row;
                  GridRecordItem itm = row.Items[0];
                              
                  string sffssdf =   itm.Text;
                  itm = row.Items[1];
                  sffssdf = itm.Text;
                  itm = row.Items[2];
                  sffssdf = itm.Text;
              }

              // example of  looping thru all rows and getting values of a checkbox in a column template field!!!!!
              foreach (GridRecord row in WebDataGrid1.Rows)
              // foreach (GridRecordItem row in WebDataGrid1.Behaviors.Selection.SelectedCells)
              {
                  CheckBox theCB = (CheckBox)row.Items[0].FindControl("cb1");
                  bool ischecked = theCB.Checked;
                  object ttt = row;
                  GridRecordItem itm = row.Items[0];


                  string sffssdf = itm.Text;
                  itm = row.Items[1];
                  sffssdf = itm.Text;
                  itm = row.Items[2];
                  sffssdf = itm.Text;
              }


          }

Case sensitive column contents in SqlServer

2010-03-16T08:53:00.005-04:00

Use the following t-sql code to make the contents of a column case sensitive regardless of the default db setting:

alter table TheTableName alter column TheColumnName TypeOfColEgVarchar(20)OrChar(6) collate Latin1_General_CS_AS

for example:
alter table People alter column LastName varchar(20) collate Latin1_General_CS_AS

Am using this in SqlServer 2005.

Leading zeros in tsql

2010-01-28T15:00:00.003-05:00

select right ('StringOfZerosAsManyAsMaxNeededMoreIsOK'
+ cast ( AnIntegerLiteralOrIntVariable as varchar)
, IntLiteralWhichIsTotalLengthOfNeededString)

declare @counter int
set @counter = 126
select right ('000000' + cast ( @counter as varchar) , 6 )

result:
000126

declare @counter int
set @counter = 12345678
select right ('000000000' + cast ( @counter as varchar) , 6 )

result:
345678

declare @counter int
set @counter = 123
select right ('00' + cast ( @counter as varchar) , 6 )

result:
00123

declare @counter int
set @counter = 123
select right ('0000' + cast ( 123 as varchar) , 9 )

result:
000126

Crystal Reports like in db selection formula

2010-01-14T10:13:00.001-05:00

{vTimeTrackDataAll4.ContactName} like '*'+{?pEmpName}+'*' and
{vTimeTrackDataAll4.StartTime} >= {?pStartDate} and
{vTimeTrackDataAll4.StartTime} <= {?pEndDate}

javascript on mouseover lv and doubleclick event

2010-01-13T11:59:00.000-05:00

protected void ListView1_ItemDataBound(object sender, ListViewItemEventArgs e)
{
// not uploaded data
// this is done everytime the page is refreshed.

if (e.Item.ItemType == ListViewItemType.DataItem)
{

if (res & e.Row.DataItemIndex == theRowIndex)
{
GridView1.Rows[theRowIndex].Attributes.Add("onmouseover", "this.style.backgroundColor='PeachPuff'");
GridView1.Rows[theRowIndex].Attributes.Add("onmouseout", "this.style.backgroundColor='Beige'");
}

// Get the LinkButton control in the 9th cell
LinkButton _doubleClickButton = (LinkButton)e.Row.Cells[9].Controls[0];
// Get the javascript which is assigned to this LinkButton
string _jsDouble =
ClientScript.GetPostBackClientHyperlink(_doubleClickButton, "");
// Add this JavaScript to the ondblclick Attribute of the row
e.Row.Attributes["ondblclick"] = _jsDouble;

right click already defined
LinkButton _rightClickButton = (LinkButton)e.Row.Cells[10].Controls[0];
Get the javascript which is assigned to this LinkButton
string _jsDouble2 =
ClientScript.GetPostBackClientHyperlink(_rightClickButton, "");
Add this JavaScript to the ondblclick Attribute of the row
e.Row.Attributes["mousemove"] = _jsDouble2;
}
}

Adding a UserControl to a Placeholder Dynamically

2010-01-11T09:41:00.004-05:00

So I was trying to dynamically generate my asp.net page by newing a UserControl and adding it to a Placeholder on Page_Load:

ucSelectMed ucMySelectMed = new ucSelectMed();
phSelectMed.Controls.Add(ucMySelectMed);

Ran the project, nothing was on the page.

Was really confused because the following works:

TextBox tb = new TextBox();
phSelectMed.Controls.Add(tb);

Anyway, what was needed is:

ucSelectMed ucMySelectMed = (ucSelectMed)LoadControl("ucSelectMed.ascx");
phSelectMed.Controls.Add(ucMySelectMed);

To Gac or Not To Gac

2010-01-04T12:15:00.003-05:00

Gac location is c:\windows\assembly

Best post I have seen on this:

http://justmyopinion.cilyok.net/?p=406

Infragistics WebCombo Get the Value of Cell by Column Name

2009-12-24T11:06:00.003-05:00

Get the Value in a Cell by the Column Name

To get the value in a Infragistics WebCombo cell by the column name (in this case, column DrugName):

string chosenName = e.Row.Cells.FromKey("DrugName").ToString;

where e is the EventArgs from

protected void igWebCombo1_SelectedRowChanged(object sender,
Infragistics.WebUI.WebCombo.SelectedRowChangedEventArgs e)

I had previously gotten the value using an index value:
string chosen = e.Row.Cells[2].Value.ToString().Trim();

but in continuing development, the number of columns may vary, and therefore the index may change.

Query to get the table names in a SqlServer db

2009-11-30T13:28:00.002-05:00

The following Query will generate a list of the tables in a sqlserver db

select [name] from sysobjects where [xtype] = 'U' order by [name]

Use [xtype] ='PK' for list of primary keys,

[xtype] = 'P' for list of stored procedures,

etc.

Copy Some Rows From Table1 to Table2 SqlServer

2009-10-21T12:49:00.004-04:00

I am doing a one-time combining 2 separate legacy database tables that contain some of the same info but also additional different info into one new SqlServer table. I am also copying some but not all of that additional data.

So I am inserting some of the columns from each table into some of the columns in the new table.

If all the columns in table2 are going to be inserted into table1 and the column names are the same I can:

insert into table1 (Detail, Unitname, Sortorder) select * from table2

if there is a change in column name change:

insert into table1 (Detail, Unitname , Sortorder) select facilabbr as Detail, Unitname , Sortnum as Sortorder from table2

Javascript Function using RegEx Regular Expression

2009-10-13T13:06:00.002-04:00

I need to check client side if a DropDownList.SelectedItem.Value is any of the following: 1,3,9,17,or 15.

Rather than use a clumsy if statement, I do this by seeing if the value will match a Regular Expression:

      function taskChange() {
      var task = $get("ddlTest");
      var RegExp = "(^1$^3$^9$^17$^15$)" ;
      if (RegExp.match(task.value))
           { 
               // A value of 1,3,9,17,or 15 was selected

               // do whatever

           }
           else
           {
                //Some other value was selected

                // do whatever
           }
       }

Playing with an Infragistics WebDialogWindow Bug

2009-09-24T20:41:00.008-04:00

Found a bug in the Infragistics WebDialogWindow.

I discovered it when using the zooming function via holding down the Ctrl key and scrolling the mouse wheel to make the display more visible to the group I was demo-ing to. Moving the WebDialogWindow around leaves text behind. Oops.

Not exactly the demo I was shooting for.

But can be used to generate some cool effects:

This is what the WebDialogWindow looks like before moving it:

These are screenshots of the WebDialogWindow on zoom:

Floating away:

Where did my window go?

An out of body experience:

And my personal favorite -

WebDialogWindow Abstraction :

Increasing number of connections in IIS 5.1

2009-09-17T17:35:00.000-04:00

XP Pro IIS 5.1 is limited by default to 10 concurrent connections.

This can be increased to a maximum of 40 by:

C:\Inetpub\AdminScripts\adsutil set w3svc/MaxConnections 40

Using Manoli

2009-09-17T12:45:00.002-04:00

I use http://manoli.net/csharpformat/ , or other manoli flavors, to format code for presentation in this blog.

Delayed action on Mouseover

2009-09-17T11:26:00.007-04:00

Haven't tried this yet, just parked it here till I need to use it.


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Page title</title>

<script type="text/javascript">
var c=0;
var t;
var myTimer;
function timedCount()
{
document.getElementById('txt').value=c
c=c+1
t=setTimeout("timedCount()",50)
}

function stopCount()
{
clearTimeout(t)
}

</script>
</head>

<body>
<form>
<input type="button" value="Start count!" onmouseover="var myTimer=setTimeout('timedCount()', 1000);" onmouseout="clearTimeout(myTimer);">
<input type="text" id="txt">
<input type="button" value="Stop count!" onClick="stopCount()">
</form>
</body>
</html>

Gps coordinates from Google maps

2009-06-07T17:41:00.002-04:00

To provide directions on my Rahway River Park blog, a have link to google maps.

I open Google Maps to the vicinity of where I would like coordinates.

I use my right click mouse button and select "center map here" from the drop down button.

I click the "go to the address in the location bar" button usually to the right of the address.

A popup appears showing the coordinates of the center of the map like this: (43.60336, -110.7362)

Take a look:
Directions

Gps coordinates from Google maps

2009-06-07T01:08:00.005-04:00

To provide directions on my Rahway River Park blog, a have link to google maps.

1. I open Google Maps to the vicinity of where I would like coordinates.
2. I use my right click mouse button and select "center map here" from the drop down button.
4. I click the "go to the address in the location bar" button usually to the right of the address.
5. A popup appears showing the coordinates of the center of the map like this: (43.60336, -110.7362)

blog, I got the l

Directions(Rahway River Park NJ)

Easy file upload from client to server using FileUpload

2009-05-12T07:07:00.017-04:00

I needed a way to do a file upload from client to server without using FTP and found this easy solution using the FileUpload control.

Duh.

The control appears as a texbox with a Browse... button. The following puts the control on the page and sets the file to be uploaded to directory C:\\rptsys on the server.

<asp:FileUpload ID="FileUpload1" runat="server" filename ="C:\\rptsys\" />

Added a button to initiate the upload and a label to display the result:

<asp:Button ID="Button1" runat="server" Text="UploadFile" onclick="Button1_Click" /> </div> <asp:Label ID="Label1" runat="server" Text="Label"Width="247px"></asp:Label>

I put together a simple UI:

The Browse button opens up a full choose file dialog window.

The backend code:


  protected void Button1_Click(object sender, EventArgs e)
       {
           if (FileUpload1.HasFile)
               {
                    Label1.Text = "File Uploaded: " + FileUpload1.FileName;
                    FileUpload1.SaveAs(@"C:\temp\uploads\" +
FileUpload1.FileName);
               }
               else
               {
                   Label1.Text = "No File Uploaded.";
               }
       }

After the file is transmitted, I display a "success" message.

I would have liked to prepopuate the Browse textbox to the directory I know the file is in, but apparently, this cannot be done for security reasons.

Microsoft Bug Du Jour

2009-05-05T17:12:00.007-04:00

Last Wednesday I was called over by a coworker and informed that my Asp.Net 3.5 app would not run on a 64 Bit PC running Vista.

Where the drop down menu should have been displaying a list of reports, there was a very empty, very white, rectangular box.

Took a look at the View Source to see what was going on. The menu was there and seemed ok.

Then I find out that the machine is running Explorer 8. Click on Compatibility View in the menu and site displays correctly.

Corrupted Toolbar in SQL Server Management Studio (SSMS)

2009-04-22T21:20:00.004-04:00

I somehow corrupted the toolbar in SQL Server Management Studio (SSMS) the other day:

This is what it looked like
when I selected Edit, and selected File:

At first it was annoying. When I thought about it a little longer, I realized, Wow! Think how productive I could be using this toolbar!

But figured I better fix it. I found this site:
http://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=328568

Which had the following info:

I think I found a fix. The fix is:
1) Open Regedit
2) Go to the key HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\Menus
3) Export the key to the Desktop for easy access
4) There are some entries that end in ,1000,1 Try deleting one at a time until the dupe menus disapear
5) Restore the menus.reg export you made after each failed attempt to get the dupes to disappear
6) At some point, they will disapear
Obviously the better fix would be for MS to fix the buggy software or at least explain which key should be deleted.
Posted by Rogue1 on 8/4/2008 at 2:23 PM
Interestingly, I found that this works:
1) Open Regedit
2) Go to the key HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\Menus
3) Export the key to the Desktop for easy access
4) Delete any one entry that ends in ,1000,1
5) Open MS SSMSE and check to make sure the dupes are gone
6) Merge the saved reg file back into the registry
7) Open MS SSMSE and check to make sure the dupes are gone

Interestingly, the dupes appear to have disapeared without really getting rid of any of the entries.
Posted by Rogue1 on 8/4/2008 at 2:33 PM
And here is the key to fix for VS 9 Web Dev Express:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\9.0\Menus
Same process as above.
Posted by Rogue1 on 8/6/2008 at 7:21 PM

So I got into Regedit ( by searching for Regedit in the search field of start -> all programs )

The directions gave the path as:
SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\Menus

But this was the actual directory name:
SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Shell\Menus

I didn’t have the nerve to delete entries from the registry. After all this was my first time here.

So

- Compared registry listing with listing on my xp. Were the same. Nothing extra on vista.

- Still followed directions to export the listing to desktop ( rc on Menus in directory, choose export ) just in case

- renamed (not deleted) all entries that ending in ,1000,1

- tried to start up ssms ( wouldn’t start)

- changed name of registries back to original

It worked !!!