Protected void button#click (Object sender, eventargs E)
{
String SQL = "insert into AA values (@ A, @ B )";
Sqlparameter [] parms = {
New sqlparameter ("@ A", sqldbtype. Money ),
New sqlparameter ("@ B", sqldbtype. Float)
};
Parms [0]. value = This. textbox1.text;
Parms [1]. value = This. textbox2.text;
Sqlhelper. executenonquery (sqlhelper. sqlstr, commandtype. Text, SQL, parms );
Response. Write ("successful ");
}
Protected void button2_click (Object sender, eventargs E)
{
List <class1> clss = new list <class1> ();
Using (sqldatareader DR = sqlhelper. executereader (sqlhelper. sqlstr, commandtype. Text, "select * from AA", null ))
{
While (dr. Read ())
{
Class1 CLS = new class1 (dr. getdecimal (0), dr. getdouble (1 ));
Clss. Add (CLS );
}
}
This. gridview1.datasource = clss;
This. gridview1.databind ();
}
Private decimal _ m;
Public decimal m
{
Get
{
Return _ m;
}
Set
{
_ M = value;
}
}
Private double _ F;
Public double F
{
Get
{
Return _ F;
}
Set
{
_ F = value;
}
}
Public class1 ()
{
}
Public class1 (decimal m_m, double M_f)
{
_ M = m_m;
_ F = M_f;
}