C#

Ariadne wrote:

I had to move a MSAccess Database to a new locati

Abhijit Jana wrote:

just change the DBpath in connection string

twistz wrote:

// First, get the StaffID for the selected row
int StaffID = Convert.ToInt32(StaffID.DataKeys[row.RowIndex].Value);

namespace ConsoleApplication2<br />
{<br />
    class Program<br />
    {<br />
        static void Main(string[] args)<br />
        {<br />
            string str = string.Empty;<br />
            str="bbb ccc ddd 10.5 20.1 30.4";<br />
            string[] sstring = str.Split(' ');<br />
            foreach (string s in sstring)<br />
            {<br />
                Console.WriteLine(s);<br />
            }<br />
        }<br />
    }<br />
}

stancrm wrote:

"aaa bbb" "ccc dddd" 10.1 20.2

string[] mainstring;
string[] s = string.Empty;
string[] t = string.Empty;
s = yourstring.spilt('"');

for(int i=1;i<s.length;i++)>
{
if(i%2 != 0)
{
mianstring[i-1] = s[i]
}
int i = mainstring.length;
t = mainstring[i].split(' ');
i = i-1'
foreach(string s in t)
{
mainstring[i+1] = s;

}
}

public List<string> SplitLine(string line)
{
  List<string> items = new List<string>();

  MatchCollection matchCollection = Regex.Matches(line, "\"[^\"]*\"|[^\"]*");
  foreach (Match match in matchCollection)
  {
    string group = match.Value.Trim();
    if (group != string.Empty)
    {
      if (group[0] == '"')
      {
        items.Add(group.Trim(new char[] {'"'}));
      }
      else
      {
      //items.AddRange(group.Split(new char[] {'"'}, StringSplitOptions.RemoveEmptyEntries)); sorry, should be 
        items.AddRange(group.Split(new char[] {' '}, StringSplitOptions.RemoveEmptyEntries));
      }
    }
  }
  return items;
}

static string[] ParseStringUsingRegex(string input)
{
  Regex regex = new Regex("\"([^\"]+?)\" ?|([^ ]+) ?| ");
  MatchCollection matches = regex.Matches(input);

  string[] result = new string[matches.Count];
  for(int i = 0; i < matches.Count; i++)
  {
    Match match = matches[i];
    result[i] = match.ToString().Replace("\"", "").Trim();
  }
  return result;
}