C#

string query2 = "select sum(amount) Total from pur_inv_dtl where inv_id = '" + IdTxt.Text + "'";



SqlCommand cmd2 = new SqlCommand(query2, conn);
try
   {
   conn.Open();
   SqlDataReader sdr = cmd2.ExecuteReader();
   while (sdr.Read())
      {
      Gtotal.Text = sdr["Total"].ToString();
      }
   }
finally
   {
   conn.Close();
   }

nEar_mO wrote:

i wanted to create a software for a server

public partial class MyUserControl : UserControl
{
    public event EventHandler TheButtonWasClick;

    public MyUserControl()
    {
        InitializeComponent();
        //register the "button1_Click" method as a listener..
        button1.Click += new EventHandler(button1_Click);
    }

    private void button1_Click(object sender, EventArgs e)
    {
        //the event will be null if it has no listeners...
        if (TheButtonWasClick != null)
            TheButtonWasClick(this, EventArgs.Empty);
    }
}

public partial class MainForm : Form
{
    private void mainFormButton_Click(object sender, EventArgs e)
    {
        MyUserControl myUserControl = new MyUserControl();
        //register the "myUserControl_TheButtonWasClick" as a listener...
        myUserControl.TheButtonWasClick += new EventHandler(myUserControl_TheButtonWasClick);
    }

    void myUserControl_TheButtonWasClick(object sender, EventArgs e)
    {
        //execute your code when the button is clicked...
    }
}

JessStuart wrote:

I'm just at a learning stage where I want to make sure I understand exactly what's going on.

private void btnAddQuery_Click(object sender, EventArgs e)
{
    SQLXmlInterface newSxi = new SQLXmlInterface();
    newSxi.SaveButtonClicked += new System.EventHandler(SQLXmlInteface_SaveButtonHandler);
    sqlInterfaces.Add(newSxi);

    tlpQueries.Controls.Clear();
    foreach (SQLXmlInterface sxi in sqlInterfaces)
    {
        sxi.Refresh();
        tlpQueries.Controls.Add(sxi);
    }

    RefreshControls();
}

private void SQLXmlInteface_SaveButtonHandler(object sender, EventArgs e)
{
    RefreshControls();
}

public partial class SQLXmlInterface : UserControl
{
    SQLXmlObject sqlObject;
    bool saved = false;
    bool validated = true;
    public event EventHandler SaveButtonClicked;

    private void btnSave_Click(object sender, EventArgs e)
    {
        saved = true;
        sqlObject = new SQLXmlObject(txtTitle.Text, txtQuery.Text);
        RefreshControls();
        if (SaveButtonClicked != null)
            SaveButtonClicked(this, EventArgs.Empty);
    }
}

newSxi.SaveButtonClicked += new System.EventHandler(SQLXmlInteface_SaveButtonHandler);

harold aptroot wrote:

You could copy it to a temp file though