C#

strSQL = "SET IDENTITY_INSERT TableName ON ";
strSQL = strSQL + "INSERT INTO TableName(USERNAME";
strSQL = ...
strSQL = strSQL + "SET IDENTITY_INSERT TableName OFF";
...
SqlCommand cmd = new SqlCommand(strSQL,cnn);
  try
  {
     cmd.ExecuteNonQuery();
     cnn.Close();
  }
....

void ConvertRtf2Html(Stream rtfStream)
        {
            // logger
            RtfInterpreterListenerFileLogger logger =
              new RtfInterpreterListenerFileLogger(@"c:\temp\RtfInterpreter.log");

            // image converter
            // convert all images to JPG
            RtfVisualImageAdapter imageAdapter =
               new RtfVisualImageAdapter(ImageFormat.Jpeg);
            RtfImageConvertSettings imageConvertSettings =
                           new RtfImageConvertSettings(imageAdapter);
            imageConvertSettings.ScaleImage = true; // scale images
            RtfImageConverter imageConverter =
                    new RtfImageConverter(imageConvertSettings);

            // interpreter
            IRtfDocument rtfDocument = RtfInterpreterTool.Interpret(rtfStream, logger, imageConverter);

            // html converter
            RtfHtmlConvertSettings htmlConvertSettings =
                   new RtfHtmlConvertSettings(imageAdapter);
            htmlConvertSettings.StyleSheetLinks.Add("default.css");
            RtfHtmlConverter htmlConverter = new RtfHtmlConverter(rtfDocument,
                                                         htmlConvertSettings);
            Console.WriteLine(htmlConverter.Convert());
        } // ConvertRtf2Html

private void OnPresence(object sender, agsXMPP.protocol.client.Presence pps)
        {
            if (base.InvokeRequired == true)
            {
                base.BeginInvoke(new agsXMPP.protocol.client.PresenceHandler(OnPresence), new object[] { sender, pps });
            }
            else
            {

                if (pps.Type == PresenceType.available)
                {
                    for (var i = 0; i < listView1.Items.Count; i++)
                    {
                        ListViewItem item = listView1.Items.Add(pps.From.User, 0);
                    }
                }
                try
                {

                    if (pps.Type == PresenceType.unavailable)
                    {
                        for (var i = 0; i < listView1.Items.Count; i++)
                        {
                            ListViewItem item = listView1.Items.Add(pps.From.User, 1);
                        }
                    }
                }
                catch
                { }
            }
        }

var sel = (from o in db.r2_machine group o by o.factory into g select g.Key).ToList();
sel = sel.Where(c => c.product_family == TxtProductFamily.Text);
TxtProductFactory.ItemsSource = sel;