winform里动态绑定数据后,如何手工追回一条记录?
叶子哟 2004-08-15 04:14:18 我在一个按钮里给dataGrid2动态绑定了一个数据源,现我想在另一个增加数据按钮里手工往dataGrid2中追加一行数据(先不需写数据库中,只是显示用,如果再按确定按钮,则将新加入的行数据写入数据库中),如何写?绑定数据函数如下:
private void binddata2()
{
DataSet ds = new DataSet();
string sqlstr = "SELECT foodid AS 编号, foodname AS 名称, units AS 单位, unitprice AS 单价, islargess AS 赠送,rebate AS 折扣, number AS 份数, summoney AS 应收金额, rebatemoney AS 折扣金额, finallmoney AS 销售金额 FROM detailfood";
SqlCommand oCmdcopy = new SqlCommand(sqlstr,conn);
oCmdcopy.CommandType=CommandType.Text;
SqlDataAdapter oAdapter = new SqlDataAdapter(oCmdcopy);
oAdapter.Fill( ds ,"detailfood");
dataGrid2.DataSource = ds;
dataGrid2.DataMember = "detailfood";
}