public static NpgsqlDataAdapter NpgAdatpter(string sql) { try { if (remoteConnection.State.ToString() == "Closed") { remoteConnection.Open(); } dataSet = new DataSet(); Npgadapter.SelectCommand = new NpgsqlCommand(sql.Replace("+", "||").Replace("[", "\"").Replace("]", "\"").Replace("zbroj", "+"), remoteConnection); NpgsqlCommandBuilder builder = new NpgsqlCommandBuilder(Npgadapter); return(Npgadapter); } catch (Exception ex) { Funkcije.SetInLog(sql + "\r\n" + ex.ToString(), "65", "RemoteDB"); return(Npgadapter); } }
//UPDATE public static string update(string sql) { try { if (remoteConnection.State.ToString() == "Closed") { remoteConnection.Open(); } NpgsqlCommand comm = new NpgsqlCommand(sql, remoteConnection); comm.ExecuteNonQuery(); return(""); } catch (Exception ex) { remoteConnection.Close(); Funkcije.SetInLog(sql + "\r\n" + ex.ToString(), "65", "RemoteDB"); return(ex.ToString()); } }