C#

create table test_tab (m1 numeric, m2 numeric, m3 numeric)

insert into test_tab values (1,2,3)
insert into test_tab values (4,6,8)
insert into test_tab values (5,7,9)

select m1,m2,m3 , (m1+m2+m3) as tot from test_tab 
<pre> 

<div class="ForumSig">Padmanabhan
My Articles:
<a href="http://www.codeproject.com/script/Articles/MemberArticles.aspx?amid=5686247">Articles</a>[<a href="http://www.codeproject.com/script/Articles/MemberArticles.aspx?amid=5686247" target="_blank" title="New Window">^</a>]
My latest Article:
<a href="http://www.codeproject.com/KB/office/Word_Automation_Part1.aspx">Word Automation</a>[<a href="http://www.codeproject.com/KB/office/Word_Automation_Part1.aspx" target="_blank" title="New Window">^</a>]</div>

public class Form1 : Form
{
  ...
  public string MyText
  {
    set { this.textBox1.Text = value; }
  }
  ...
}

public class Form2 : Form
{
  private Form1 form1;
 
  public Form2(Form1 form1)
  {
    this.form1 = form1;
  }

  private void buttonBack_Click(object sender, EventArgs e)
  {
    this.form1.MyText = "Data from DataGridView here...";
  }
}

using System;
using System.Windows.Forms;

public class Form1 : Form
{
    public Form1() { }

    public void ShowNewForm2()
    {
        Form2 form2 = new Form2();
        form2.CustomEvent += new EventHandler<CustomEventArgs>(form2_CustomEvent);
        form2.Show();
    }

    void form2_CustomEvent(object sender, CustomEventArgs e)
    {
        // data is in: e.YourData
    }
}

public class Form2 : Form
{
    public event EventHandler<CustomEventArgs> CustomEvent;

    public Form2() { }

    protected virtual void OnCustomEvent(CustomEventArgs e)
    {
        EventHandler<CustomEventArgs> eh = CustomEvent;
        if (eh != null)
            eh(this, e);
    }

    public void PerformCustomEvent()
    {
        OnCustomEvent(new CustomEventArgs(123));
    }
}

public class CustomEventArgs : EventArgs
{
    public CustomEventArgs(int yourData)
    {
        YourData = yourData;
    }

    public int YourData
    {
        get;
        private set;
    }
}

ankitjain1110 wrote:

foreach (DataRow row in dep.Rows )
    {DropDownList2.Items.Add(row[0].ToString());}