public static List <String> getFileName(int orderid, Ftypes type) { String sql = "SELECT name from orderfiles where type =" + (int)type + " AND orderid=" + orderid; List <String> lst = new List <String>(); SQLiteConnection myConn = new SQLiteConnection(sqConnectionString); SQLiteCommand sqCommand = new SQLiteCommand(sql); sqCommand.Connection = myConn; myConn.Open(); try { SQLiteDataReader r = sqCommand.ExecuteReader(); while (r.Read()) { lst.Add(r["name"].ToString()); } r.Close(); err = false; return(lst); } catch { err = true; } finally { myConn.Close(); } return(lst); }
public static void setFileName(int orderid, String name, Ftypes type) { msql.query("INSERT INTO orderfiles(orderid, name, type) Values(" + orderid + ", \"" + name + "\", " + (int)type + ")"); }