C#

Luc Pattyn wrote:

I suggest you just give it a try with a mock query.

galache wrote:

Math.Round(4.515* 0.05, 2,MidpointRounding.AwayFromZero)
the result is 4.51

galache wrote:

I think the problem is the double type use in the first example

static void Main(string[] args)
    {
    Console.WriteLine("Started");
    SqlConnection con = new SqlConnection(strCon);
    con.Open();
    SqlDataAdapter daMyTable = new SqlDataAdapter("SELECT * FROM myTable", con);
    SqlDataAdapter daMyOtherTable = new SqlDataAdapter("SELECT * FROM myOtherTable", con);
    SqlDataAdapter daJoined = new SqlDataAdapter("SELECT * FROM myTable INNER JOIN myOtherTable ON myTable.iD=myOtherTable.iD", con);
    DataSet ds = new DataSet();
    daMyTable.Fill(ds, "My Table");
    daMyOtherTable.Fill(ds, "My Other Table");
    daJoined.Fill(ds, "My Joined Table");
    ShowDataSet(ds);
    con.Close();
    Console.WriteLine("Stopped");
    Console.ReadLine();
    }

private static void ShowDataSet(DataSet ds)
    {
    foreach (DataTable dt in ds.Tables)
        {
        Console.WriteLine(dt.TableName);
        ShowDataTable("   ", dt);
        }
    }

private static void ShowDataTable(string p, DataTable dt)
    {
    int cols = dt.Columns.Count;
    foreach (DataRow dr in dt.Rows)
        {
        Console.Write(p);
        string sep = "";
        for (int i = 0; i < cols; i++)
            {
            Console.Write(sep + dr[i].ToString());
            sep = ", ";
            }
        Console.WriteLine();
        }
    }