Pages

Sunday, December 20, 2009

Adding order to Datatable in Ado.net


private void AddOrder(ref DataTable dtb)
{
DataColumn dc = new DataColumn();
dtb.Columns.Add("Order");
for (int i = 1; i <= dtb.Rows.Count; i++)
{
dtb.Rows[i - 1]["Order"] = i;
}
}

Wednesday, December 16, 2009

Random String


using System;
using System.Collections.Generic;
using System.Text;
using System.Security.Cryptography;
namespace RandomString
{
public static class RandomString
{
static char[] myCharArray = new char[]
{ 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'
,'a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'
,'0','1','2','3','4','5','6','7','8','9'
//,'ก', 'ข', 'ค', 'ง', 'จ', 'ฉ', 'ช', 'ซ', 'ฌ', 'ญ', 'ฎ', 'ฏ', 'ฐ', 'ฑ', 'ฒ', 'ณ', 'ด', 'ต', 'ถ', 'ท', 'ธ', 'น', 'บ', 'ป', 'ผ', 'ฝ', 'พ', 'ฟ', 'ภ', 'ม', 'ย', 'ร', 'ล', 'ว', 'ศ', 'ษ', 'ส', 'ห', 'ฬ', 'อ', 'ฮ'
};
public static string GetRandStringMD5(string hashString)
{
byte[] h = ASCIIEncoding.Default.GetBytes(hashString);
MD5CryptoServiceProvider md5 = new MD5CryptoServiceProvider();
return System.Text.Encoding.ASCII.GetString(md5.ComputeHash(h));
}
public static string GetRandString(int length)
{
string r = "";
int maxl = myCharArray.Length;
Random rnd = new Random();
for (int i = 0; i < length; i++)
{
int rchar = rnd.Next(0,maxl);
r += myCharArray[rchar];
}
return r;
}
public static string GetRandString(int min, int max)
{
string r = "";
int maxl = myCharArray.Length;
Random rnd = new Random();
int maxr = rnd.Next(min, max);
for (int i = 0; i < maxr; i++)
{
r += myCharArray[rnd.Next(0, maxl)];
}
return r;
}
}
}

Simple Create Child Node in XML

 
XmlDocument doc = new XmlDocument();
doc.Load("PHP_DataAdapter.xml");
XmlElement _aidRoot = doc.CreateElement("Adapter");
_aidRoot.InnerXml = @"1234"
+ @""
+ @"";
doc.DocumentElement.AppendChild(_aidRoot);
doc.Save("PHP_DataAdapter.xml");

Tuesday, December 8, 2009

Quick Get DataTable Class


public static class QuickGetDataTable
{
DataTable GetDatatable(string connectionString, string selectCommand) {
SqlDataAdapter sda = new SqlDataAdapter(selectCommand, connectionString);
DataTable dt = null;
sda.Fill(dt);
return dt;
}
}