C#

arif_pyxisnet wrote:

developed a desktop application which use some sourcesafe apis

arif_pyxisnet wrote:

I do not want to use sorcesafe on that pc.

IConnection con = new SqlConnection();

I are troll

DataBase db = new DataBase();
db.DataBaseToUse = DataBases.SQLExpress;
DataSet result = db.GetData();

public enum DataBases
{
    SQL = 0,
    SQLExpress = 1,
}
internal interface IDataBase
{
    DataSet GetData();
}
public class DataBase : IDataBase
{
    // Default
    IDataBase databaseInUse = new SQLDataBase();
    public DataBases DataBaseToUse
    {
        set
        {
            switch (value)
            {
                case DataBases.SQLExpress:
                    databaseInUse = new SQLExpressDataBase();
                    break;
                default:
                    databaseInUse = new SQLDataBase();
                    break;
            }
        }
    }
    public DataSet GetData()
    {
        return databaseInUse.GetData();
    }
}
internal class SQLDataBase : IDataBase
{
    public DataSet GetData()
    {
        return new DataSet();
    }
}
internal class SQLExpressDataBase : IDataBase
{
    public DataSet GetData()
    {
        return new DataSet();
    }
}

George_George wrote:

I failed to find a sample about how to convert an array instances of user defined types into a (C# ADO.Net) datatable

George_George wrote:

whether it is a must to convert to datatable in order to bound to controls in ASP.Net?