public DataTable SelectCategory(string word)
{
var cn = new NpgsqlConnection(conn);
var query = "";
cn.Open();
var wordConverted = data.ConvertCategory(word);
switch (wordConverted)
{
case "action":
query = "SELECT * FROM tbl_action";
break;
case "adventure":
query = "SELECT * FROM tbl_adventure";
break;
case "driving":
query = "SELECT * FROM tbl_driving";
break;
case "indie":
query = "SELECT * FROM tbl_indie";
break;
case "mmo":
query = "SELECT * FROM tbl_mmo";
break;
case "moba":
query = "SELECT * FROM tbl_moba";
break;
case "sport":
query = "SELECT * FROM tbl_sport";
break;
case "strategy":
query = "SELECT * FROM tbl_strategy";
break;
case "terror":
query = "SELECT * FROM tbl_terror";
break;
default:
break;
}
//adapter para hacer la peticion a la conexion
NpgsqlDataAdapter da = new NpgsqlDataAdapter(query, cn);
//Llenamos dataset con el resultado del adapter
da.Fill(ds);
//Porque puede manejar varias tablas, Seleccionamos la primera
dt = ds.Tables[0];
//Cerramos conexion
cn.Close();
//retornamos objeto datatable
return(dt);
}
