เอา function การดึง datatable แบบบ้าน ๆ มาใช้งานมาให้ติชมครับ 5555

public enum EnumConnectionType{ ODBC, OLEDB, SqlClient }
public static System.Data.DataTable GetTableForm(string _SQL, string strConn, EnumConnectionType ConnectionType )
        {
            System.Data.DataSet ds = new System.Data.DataSet();
            switch (ConnectionType)
            {
                case EnumConnectionType.ODBC:
                    System.Data.Odbc.OdbcConnection conn1 = new System.Data.Odbc.OdbcConnection(strConn);
                    conn1.Open();
                    System.Data.Odbc.OdbcDataAdapter adapter1 = new System.Data.Odbc.OdbcDataAdapter(_SQL, conn1);
                    adapter1.Fill(ds);
                    break;
                case EnumConnectionType.OLEDB:
                    System.Data.OleDb.OleDbConnection conn2 = new  System.Data.OleDb.OleDbConnection(strConn);
                    conn2.Open();
                    System.Data.OleDb.OleDbDataAdapter adapter2 = new  System.Data.OleDb.OleDbDataAdapter(_SQL, conn2);
                    adapter2.Fill(ds);
                    break;
                case EnumConnectionType.SqlClient:
                    System.Data.SqlClient.SqlConnection conn3 = new  System.Data.SqlClient.SqlConnection(strConn);
                    conn3.Open();
                    System.Data.SqlClient.SqlDataAdapter adapter3 = new  System.Data.SqlClient.SqlDataAdapter(_SQL, conn3);
                    adapter3.Fill(ds);

                    break;
            }

            return ds.Tables[0];

        }

DataTable dt = GetTableForm(sql, strConn, EnumConnectionType.SqlClient ); //ประมาณนั้น

public static System.Windows.Forms.ComboBox DatabaseInCombobox(string _SQL, string strConn, EnumConnectionType ConnectionType)
        {
            ComboBox cmb = new ComboBox();
            cmb.DataSource = GetTableForm(_SQL, strConn, ConnectionType);
            return cmb;
        }
public static string[] GetData(string field, string table, string strConn, EnumConnectionType ConnectionType )
        {
            DataTable dt = GetTableForm("Select " + field + " FROM " + table, strConn, ConnectionType);
            string[] str= new string[dt.Rows.Count];
            for (int i = 0;i<dt.Rows.Count;i++)
            {
            str[i] = dt.Rows[i][field].ToString();
            }
            return str;

        }
        public static DataRow GetDataRow(string sql ,string strConn, EnumConnectionType ConnectionType)
        {
            DataTable dt = GetTableForm(sql, strConn, ConnectionType);
            
            return dt.Rows[0];

        }