Database

SELECT mineralID, SUM(value)
FROM MyTable
GROUP BY mineralID

My: Blog | Photos

"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

<br />
CREATE VIEW vw_Mineral_total<br />
AS<br />
SELECT mineralID, SUM(value)<br />
FROM MyTable<br />
GROUP BY mineralID<br />

<br />
CREATE VIEW vw_Mineral_AVG<br />
AS<br />
SELECT mineralID, AVG(value)<br />
FROM MyTable<br />
GROUP BY mineralID<br />

btnOk_Click() Event

getintform1.btnOK_Click(null,null);

....
...
Form1 getintform=new Form1();
...
public Form2()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
getintform.btnOK_Click(null,null);//
// TODO: Add any constructor code after 
}
....
private void Form2_Load(object sender, System.EventArgs e)
{
....
int getmyint;
getmyint=getintform.myint;
....
}