C#

try
{
     string query = @"SELECT * FROM [contacts]";
     conn.Close();//you must have created this connection string already
     SqlCommand cmd = conn.CreateCommand();//sql command
     cmd.CommandText = query;//declared above
     conn.Open();//open your connection to the database
     SqlDataReader reader = cmd.ExecuteReader();//execute reader to read from database
     DataSet dataset = new DataSet();//you need this
     DataTable table = dataset.Tables.Add();
     table.Columns.Add("contactid", typeof(string));//these
     table.Columns.Add("firstname", typeof(string));//must be column
     table.Columns.Add("lastname", typeof(string));//names in
     table.Columns.Add("email", typeof(string));//your datagrid
     while (reader.Read())
     {
         //add rows to your table which already has column names/heards...see above
         table.Rows.Add(reader["contact_id"].ToString(), reader["name"].ToString(), reader["surname"].ToString(), reader["email"].ToString());
     }
     //check if any data was added in a while(reader.Read())
     if (dataset.Tables[0].Rows.Count > 0 || dataset.Tables.Count > -1)
     {
         contacts.DataSource = table;//just like it says
         contacts.DataBind();
         contacts.Visible = true;
     }
 }
 catch (SqlException fc)
 {
     error.Text = "Error occured :" + fc.Message;//catch that error
 }
 finally
 {
     conn.Close();//please close connection to your database when done
 }
 //hope this helps!!!

char[] splitChars = {'!', ',', ';', '/', ':'};
string[] theBits = text.Split(splitChars);
foreach(string s in theBits)
{
   // do something with s
}

<br />
//  using System.Text.RegularExpressions;<br />
<br />
/// <summary><br />
///  Regular expression built for C# on: Fri, Apr 16, 2010, 07:52:19 AM<br />
///  Using Expresso Version: 3.0.3634, http://www.ultrapico.com<br />
///  <br />
///  A description of the regular expression:<br />
///  <br />
///  Match expression but don't capture it. [!(?<JobId>\w*)(?:.*?),(?:.*?)], zero or one repetitions<br />
///      !(?<JobId>\w*)(?:.*?),(?:.*?)<br />
///          !<br />
///          [JobId]: A named capture group. [\w*]<br />
///              Alphanumeric, any number of repetitions<br />
///          Match expression but don't capture it. [.*?]<br />
///              Any character, any number of repetitions, as few as possible<br />
///          ,<br />
///          Match expression but don't capture it. [.*?]<br />
///              Any character, any number of repetitions, as few as possible<br />
///  Match expression but don't capture it. [;(?<Field1>\w*)?/??(?:.*?)], zero or one repetitions<br />
///      ;(?<Field1>\w*)?/??(?:.*?)<br />
///          ;<br />
///          [Field1]: A named capture group. [\w*], zero or one repetitions<br />
///              Alphanumeric, any number of repetitions<br />
///          /, zero or one repetitions, as few as possible<br />
///          Match expression but don't capture it. [.*?]<br />
///              Any character, any number of repetitions, as few as possible<br />
///  :<br />
///  [Field2]: A named capture group. [\w*], zero or one repetitions, as few as possible<br />
///      Alphanumeric, any number of repetitions<br />
///  /<br />
///  <br />
///<br />
/// </summary><br />
public static Regex regex = new Regex(<br />
      "(?:!(?<JobId>\\w*)(?:.*?),(?:.*?))?(?:;(?<Field1>\\w*)?/??(?"+<br />
      ":.*?))?:(?<Field2>\\w*)??/",<br />
    RegexOptions.Multiline<br />
    | RegexOptions.CultureInvariant<br />
    | RegexOptions.Compiled<br />
    );<br />
<br />
<br />
<br />
//// Replace the matched text in the InputText using the replacement pattern<br />
// string result = regex.Replace(InputText,regexReplace);<br />
<br />
//// Split the InputText wherever the regex matches<br />
// string[] results = regex.Split(InputText);<br />
<br />
//// Capture the first Match, if any, in the InputText<br />
// Match m = regex.Match(InputText);<br />
<br />
//// Capture all Matches in the InputText<br />
// MatchCollection ms = regex.Matches(InputText);<br />
<br />
//// Test to see if there is a match in the InputText<br />
// bool IsMatch = regex.IsMatch(InputText);<br />
<br />
//// Get the names of all the named and numbered capture groups<br />
// string[] GroupNames = regex.GetGroupNames();<br />
<br />
//// Get the numbers of all the named and numbered capture groups<br />
// int[] GroupNumbers = regex.GetGroupNumbers();<br />
<br />
<br />
<br />