[modi123_1]

Has anyone plugged in custom snippets? If so of what?

I got so tired of retyping out the components of 'execute non query' or 'adapter' calls I broke down and added my usual format to a snippet. I'll probably forget how to piece the code together in a few weeks, but by then my monkey reflexes kick in and I can zone out while pushing the button for my calls.

[Core]

I have the following snippets on "quick dial":

• WebRequest / response handling
  
• OAuth signature generation
  
• Stream to byte[] conversion
  
• Converters (for Silverlight applications) - e.g. IntToString, BoolToVisibility
  
• Tons of managed WinAPI implementations

[Nakor]

I need to start creating more snippets. I mostly work with asp.net and only snippets I've created so far are ones to create properties that use ViewState or Session to store and retrieve the values. There are lots of instances where I think to myself that I should convert what I'm doing into a snippet but then I never take the time to actually do so. It would probably be better to take the little bit of time now to create the snippet to save lots of time in the future by reducing the repetitive typing.

[eclipsed4utoo]

I added 6 snippets for my latest project. Mainly dealing with database access. I created a snippet for getting one record back with no parameters, one record with params, multiple records no params, multiple records with params, non-query with no params, and non-query with params.

So my multiple records with params would look like this..

Spoiler

try
{
    #region Query

    StringBuilder query = new StringBuilder();
    query.Append("");

    #endregion

    using (DataAccess dataAccess = new DataAccess())
    {
        dataAccess.Command.CommandText = query.ToString();

        dataAccess.Command.Parameters.AddWithValue("", "");

        dataAccess.OpenConnection();

        using (SqlCeDataReader dr = dataAccess.ExecuteReader())
        {
            while (dr.Read())
            {

            }
        }
    }
}
catch
{
    throw;
}

Then I just fill in the necessary information. Man this made it so much easier than typing this same code 200 times.