DataTable GetSchemaDataTable(SqliteCommand cmd, string[] restrictionValues) { if (restrictionValues != null && cmd.Parameters.Count > 0) { for (int i = 0; i < restrictionValues.Length; i++) { cmd.Parameters[i].Value = restrictionValues[i]; } } SqliteDataAdapter adapter = new SqliteDataAdapter(cmd); DataTable dt = new DataTable(); adapter.Fill(dt); return(dt); }
DataTable GetSchemaDataTable( SqliteCommand cmd, string[] restrictionValues ) { if ( restrictionValues != null && cmd.Parameters.Count > 0 ) { for ( int i = 0; i < restrictionValues.Length; i++ ) cmd.Parameters[i].Value = restrictionValues[i]; } SqliteDataAdapter adapter = new SqliteDataAdapter( cmd ); DataTable dt = new DataTable(); adapter.Fill( dt ); return dt; }