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());}

string connection1 = ConfigurationManager.AppSettings["conn"];<br />
OleDbConnection con1 = new OleDbConnection(connection1);<br />
con1.Open();<br />
<br />
<br />
OleDbDataReader dr;<br />
<br />
string query = "select DISTINCT DEPARTMENT from TIME_DETAILS ";<br />
OleDbDataAdapter da1 = new OleDbDataAdapter(query,con1);<br />
DataSet ds1 = new DataSet();<br />
//da1.Fill(ds1);<br />
OleDbCommand cmd = new OleDbCommand(query,con1);<br />
da1.SelectCommand=cmd;<br />
da1.Fill(ds1,"dept");<br />
DataTable dep=ds1.Tables["dept"];<br />
dr = cmd.ExecuteReader();<br />
<br />
if(dep.Rows.Count>0)<br />
{<br />
foreach (DataRow row in dep.Rows )<br />
{<br />
DropDownList2.Items.Add(new ListItem(row[0].ToString(),row[0].ToString()));<br />
}<br />
<br />
}