Public snipts » robin's snipts

wrap codeloading...

• ∞ copy to clipboard

  function copyToClipBoard(id)
  {
      document.getElementById('holdtext').innerText = document.getElementById(id).innerText;
      Copied = document.getElementById('holdtext').createTextRange();
      Copied.execCommand("Copy");
  }

  js

  1

  copy to clipboard

  function copyToClipBoard(id)
  {
      document.getElementById('holdtext').innerText = document.getElementById(id).innerText;
      Copied = document.getElementById('holdtext').createTextRange();
      Copied.execCommand("Copy");
  }
  

  copy | embed

  0 comments - tagged in 
  • clipboard, 
  • javascript
  posted by robin on Feb 19, 2009 at 5:31 a.m. EST

• ∞ reset auto_increment

  ALTER TABLE tableName AUTO_INCREMENT=1;

  sql

  1

  reset auto_increment

  ALTER TABLE tableName AUTO_INCREMENT=1;
  

  copy | embed

  0 comments - tagged in 
  • mysql, 
  • sql
  posted by robin on Feb 19, 2009 at 5:27 a.m. EST

• ∞ dataset mysql

  public static DataSet GetDataSetQuery(string sql, ArrayList paramList, string name)
         {
  
             using (MySqlConnection conn = new MySqlConnection(getHostString(name)))
             {
                 try
                 {
                     conn.Open();
                     MySqlDataAdapter da = new MySqlDataAdapter(sql, conn);
                     da.SelectCommand.Parameters.Clear();
                     
                     if (paramList != null)
                     {
                         for (int i = 0; i < paramList.Count; i++)
                         {
                     
                             da.SelectCommand.Parameters.Add(paramList[i] as MySqlParameter);
                         }
                     }
  
                     DataSet ds = new DataSet();
                     da.Fill(ds);
                     return ds;
  
                 }
                 finally
                 {
  
                     conn.Close();
                 }
  
             }
         }
  

  csharp

  1

  dataset mysql

  public static DataSet GetDataSetQuery(string sql, ArrayList paramList, string name)
         {
  
             using (MySqlConnection conn = new MySqlConnection(getHostString(name)))
             {
                 try
                 {
                     conn.Open();
                     MySqlDataAdapter da = new MySqlDataAdapter(sql, conn);
                     da.SelectCommand.Parameters.Clear();
                     
                     if (paramList != null)
                     {
                         for (int i = 0; i < paramList.Count; i++)
                         {
                     
                             da.SelectCommand.Parameters.Add(paramList[i] as MySqlParameter);
                         }
                     }
  
                     DataSet ds = new DataSet();
                     da.Fill(ds);
                     return ds;
  
                 }
                 finally
                 {
  
                     conn.Close();
                 }
  
             }
         }
  

  copy | embed

  0 comments - tagged in 
  • c#, 
  • data, 
  • mysql
  posted by robin on Feb 19, 2009 at 2:27 a.m. EST

• ∞ post tweet

  public static void PostTweet(string username, string password, string tweet)
         {
             try
             {
                 string user = Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes(username + ":" + password));
                 byte[] bytes = System.Text.Encoding.ASCII.GetBytes("status=" + tweet);
                 HttpWebRequest request = (HttpWebRequest)WebRequest.Create("http://twitter.com/statuses/update.xml");
                 request.ServicePoint.Expect100Continue = false;
                 request.Method = "POST";
                 request.Headers.Add("Authorization", "Basic " + user);
                 request.ContentType = "application/x-www-form-urlencoded";
                 request.ContentLength = bytes.Length;
                 request.UserAgent = "MyApp";
                 Stream reqStream = request.GetRequestStream();
                 reqStream.Write(bytes, 0, bytes.Length);
                 reqStream.Close();
             }
             catch (Exception ex) {/* DO NOTHING */}
         }

  csharp

  1

  post tweet

  public static void PostTweet(string username, string password, string tweet)
         {
             try
             {
                 string user = Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes(username + ":" + password));
                 byte[] bytes = System.Text.Encoding.ASCII.GetBytes("status=" + tweet);
                 HttpWebRequest request = (HttpWebRequest)WebRequest.Create("http://twitter.com/statuses/update.xml");
                 request.ServicePoint.Expect100Continue = false;
                 request.Method = "POST";
                 request.Headers.Add("Authorization", "Basic " + user);
                 request.ContentType = "application/x-www-form-urlencoded";
                 request.ContentLength = bytes.Length;
                 request.UserAgent = "MyApp";
                 Stream reqStream = request.GetRequestStream();
                 reqStream.Write(bytes, 0, bytes.Length);
                 reqStream.Close();
             }
             catch (Exception ex) {/* DO NOTHING */}
         }
  

  copy | embed

  0 comments - tagged in 
  • c#, 
  • twitter, 
  • web
  posted by robin on Feb 19, 2009 at 2:25 a.m. EST

A good read

robin's tags

• c# (2)
• clipboard (1)
• data (1)
• javascript (1)
• mysql (2)
• sql (1)
• twitter (1)
• web (1)