Windows Forms

• The code is using language-elements from VB6. You should use the MessageBox class.
  
• WinForms don't have a homepage, they got a MainForm. You open other forms from there, and when you close them, you'll see the mainform again.
  
• FormClosing should only check whether the current form can close, it should not be calling the mainform (nor the homepage)
  
• I'd suggest to pick up a good book on C# - it would help in understanding VB.NET and would keep you away from VB6-legacy code.
  

Bastard Programmer from Hell

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 ]
[;]