.NET (Core and Framework)

MahaKh wrote:

how can i connect visual studio 2008 application to sql server 2008 using ODBC?

using (OdbcConnection con = new OdbcConnection(
    "DRIVER={SQL Server};SERVER=.;Trusted_connection=yes;DATABASE=AdventureWorks;"))
using (OdbcCommand cmd = con.CreateCommand())
{
    con.Open();
    cmd.CommandText = @"
             SELECT FirstName  
               FROM Person.Contact 
              WHERE ContactID = 20";

    string 结果 = (string)cmd.ExecuteScalar();

    MessageBox.Show(String.Format(
        "The FirstName of Person.Contact is '{0}'.", 结果));
}

using System.Data.Odbc;

I are Troll

MahaKh wrote:

but my requirement is to use OLEDB instead of ODBC

using (OleDbConnection con = new OleDbConnection(
    "Provider=SQLNCLI;Server=.;Database=AdventureWorks;Trusted_Connection=yes;"))
using (OleDbCommand cmd = con.CreateCommand())
{
    con.Open();
    cmd.CommandText = @"
             SELECT FirstName  
               FROM Person.Contact 
              WHERE ContactID = 20";

    string result = (string)cmd.ExecuteScalar();

    MessageBox.Show(String.Format(
        "The FirstName of Person.Contact is '{0}'.", 
        result
    ));
}

I are Troll

public class Data
{
    private List<int> a;

    public Data()
    {
      a = new List<int>();
    }

    public Data(int[] nums)
    {
       a = new List<int>();
       // add to a
    }

    public static Data Parse(string nums)
    {
       // say nums = "1,2,3
       string[] _nums = nums.Split(",".ToCharArray());
       List<int> iList = new List<int>();
       foreach(string s in nums)
          iList.Add(int32.Parse(s));
       return new Data(iList.ToArray());
    }
}

public BitmapImage TheImage
{
  get
  {
    return LoadImageFromSource();
  }
}

private BitmapImage LoadImageFromSource()
{
  BitmapImage image = new BitmapImage();

  try
  {
    image.BeginInit();
    image.CacheOption = BitmapCacheOption.OnLoad;
    image.CreateOptions = BitmapCreateOptions.IgnoreImageCache;
    image.UriSource = new Uri( FullPath, UriKind.Absolute );
    image.EndInit();
  }
  catch{
    return DependencyProperty.UnsetValue;
  }
  return image;
}