C#

Garth J Lancaster wrote:

until you do that, and we cant do it for you

<br />
SqlCommand.Parameters.Add( [param1] )<br />
SqlCommand.Parameters.Add( [param2] )<br />
SqlCommand.Execute...<br />

<br />
SqlCommand.Parameters.Add( [param1] )<br />
SqlCommand.Parameters.Add( [param2] )<br />
SqlCommand.Parameters.Add( [param3] )<br />
SqlCommand.Execute...<br />

public int Foo(param1, param2)
{
  return Bar(param1, param2, null);
}

public int Bar(param1, param2, param3)
{
   return db.Execut(...);
}

public SqlCommand CreateProc(string procName, ReadOnlyCollection<DbParameter> parameters)
{
SqlCommand cmd = new SqlCommand(procName, SqlConnection);
cmd.CommandType = CommandType.StoredProcedure;

if(parameters != null)
{
    foreach(DbParameter param in parameters)
    {
        cmd.Parameters.Add(param);
    }
}

return cmd;
}

//client.cs

        public delegate void kill(string msg);

        public event kill Kill; 

        if (!clientSocket.Connected)
        {
             Kill("Server connection broken");
             return;
        }

//main.cs
        Client clnt = null;

        private void ms_Startclient_Click(object sender, EventArgs e)
        {
            if (ms_Startclient.Checked)
            {
                clnt = new Client();
                clnt.Kill += new Client.kill(clnt_Kill);
            }
            else
            {
                clnt = null;
            }
        }

        void clnt_Kill(string msg)
        {
            clnt = null;
            MessageBox.Show(msg);
            ms_Startclient.Checked = false;
        }

void clnt_Kill(string msg)        <br />
{           <br />
clnt.Kill -= new Client.kill(clnt_Kill);<br />
clnt = null;            <br />
MessageBox.Show(msg);            <br />
ms_Startclient.Checked = false;        <br />
}