Windows Forms

nitish_07 wrote:

i have posted in mysql but there was no reply

nitish_07 wrote:

cmd = new OdbcCommand(abc, cn);

using (cmd = cn.CreateCommand())
{
  cmd.CommandText = "EXEC abc()";
  cmd.ExecuteNonQuery(); // this means that there'll be no results
}

Bastard Programmer from Hell

MSDN[^] wrote:

SQL

[ { EXEC | EXECUTE } ]
    { 
      [ @return_status = ]
      { module_name [ ;number ] | @module_name_var } 
        [ [ @parameter = ] { value 
                           | @variable [ OUTPUT ] 
                           | [ DEFAULT ] 
                           }
        ]
      [ ,...n ]
      [ WITH <execute_option> [ ,...n ] ]
    }
[;]

Execute a character string
{ EXEC | EXECUTE } 
    ( { @string_variable | [ N ]'tsql_string' } [ + ...n ] )
    [ AS { LOGIN | USER } = ' name ' ]
[;]

Execute a pass-through command against a linked server
{ EXEC | EXECUTE }
    ( { @string_variable | [ N ] 'command_string [ ? ]' } [ + ...n ]
        [ { , { value | @variable [ OUTPUT ] } } [ ...n ] ]
    ) 
    [ AS { LOGIN | USER } = ' name ' ]
    [ AT linked_server_name ]
[;]

• The user should be able to filter the data he/she is viewing.
250 tests might generate a lot of data, and the user is probably interested in something specific - like all of last weeks' tests.

• A gridview to visualize the data that the user selected
If it's a large set, virtualize your DataGridView.

• Show some charts
A nice pie cut into the amount of tests of that week, a graph telling how often a test failed.

• Reports
One that lists all the tests, one that lists all failed etc.

Bastard Programmer from Hell