1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11
12public partial class DataSourceControl_Test : System.Web.UI.Page
13...{
14    protected void Page_Load(object sender, EventArgs e)
15    ...{
16
17    }
18
19    protected void ObjectDataSource1_Inserting(object sender, ObjectDataSourceMethodEventArgs e)
20    ...{
21        // 编程方式给参数赋值
22        if (e.InputParameters["publishTime"] == null)
23        ...{
24            e.InputParameters["publishTime"] = DateTime.Now;
25        }
26    }
27
28    protected void ObjectDataSource1_Inserted(object sender, ObjectDataSourceStatusEventArgs e)
29    ...{
30        // 错误处理
31        if (e.Exception != null)
32        ...{
33            if (e.Exception.InnerException != null)
34            ...{
35                Exception inner = e.Exception.InnerException;
36
37                if (inner is ArgumentException)
38                ...{
39                    string paramName = ((ArgumentException)inner).ParamName;
40                    lblMsg.Text = string.Concat("参数 ", paramName, " 有问题");
41                }
42            }
43        }
44        else
45        ...{
46            int?[] ary = (int?[])e.ReturnValue;
47            lblMsg.Text = "新插入信息的ID是：" + ary[0].ToString();
48            lblMsg.Text += "<br />数据总数是：" + ary[1].ToString();
49
50            lblMsg.Text += "<br />最小ID是：" + e.OutputParameters["minId"].ToString();
51        }
52    }
53
54    protected void DetailsView1_ItemInserted(object sender, DetailsViewInsertedEventArgs e)
55    ...{
56        if (e.Exception != null)
57        ...{
58            // 错误已处理
59            e.ExceptionHandled = true;
60            // DetailsView保持插入状态
61            e.KeepInInsertMode = true;
62        }
63    }
64
65    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
66    ...{
67        // 价格格式转换为decimal格式
68        if (e.NewValues["Price"] != null)
69            e.NewValues["Price"] = decimal.Parse(e.NewValues["Price"].ToString(), System.Globalization.NumberStyles.Currency);
70    }
71}
72