public string callsql(string sql) { try { NpgsqlConnection cn; cn = ConnectionServer.CreateConnection(); NpgsqlCommand command = new NpgsqlCommand(sql, cn); esql = Convert.ToString(command.ExecuteScalar()); cn.Close(); return(esql); } catch (Exception ex) { MessageBox.Show("SQL executeschalar moethod failed." + System.Environment.NewLine + ex.Message , "Database Responce", MessageBoxButtons.OK, MessageBoxIcon.Warning); ConnectionServer.CreateConnection().Close(); return(esql); } }
public DataTable callsql(string sql) { DataTable dt = new DataTable(); try { NpgsqlConnection cn; cn = ConnectionServer.CreateConnection(); NpgsqlDataAdapter da; da = new NpgsqlDataAdapter(sql, cn); da.Fill(dt); cn.Close(); return(dt); } catch (Exception ex) { MessageBox.Show("SQL executeschalar moethod failed." + System.Environment.NewLine + ex.Message , "Database Responce", MessageBoxButtons.OK, MessageBoxIcon.Warning); ConnectionServer.CreateConnection().Close(); return(dt); } }