//ConnetionMannger connetionMannger;
public List <string> GetCategory(string Query)
{
ConnetionMannger connetionMannger = new ConnetionMannger();
List <string> Items = new List <string>();
dataTable = connetionMannger.DataTableConnection(Query);
foreach (DataRow dr in dataTable.Rows)
{
string Item = dr[0].ToString();
Items.Add(Item);
}
return(Items);
}