新聞財經娛樂♬資訊 News Economy

        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)        {            GridViewRow row = GridView1.Rows[e.RowIndex] as GridViewRow;            int obj_id = Convert.ToInt16(lb_userid.Text);            TextBox tb_ite_id = row.FindControl("tb_ite_id") as TextBox;            TextBox tb_ite_id2 = row.FindControl("tb_ite_id2") as TextBox;            TextBox tb_ite_desc = row.FindControl("tb_ite_desc") as TextBox;            Label lblchangedate = row.FindControl("lblchangedate") as Label;            using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Mssqlconn2"].ConnectionString))            {                string sql = "Update tab5 set ite_id = @ite_id,ite_desc=@ite_desc, change_date= @change_date" + " where obj_id=@obj_id and ite_id=@ite_id2";                using (SqlCommand cmd = new SqlCommand(sql, conn))                {                    cmd.Parameters.AddWithValue(                    "@ite_id", Convert.ToInt16(tb_ite_id.Text));                    cmd.Parameters.AddWithValue(                    "@ite_desc", tb_ite_desc.Text.Trim());                    cmd.Parameters.AddWithValue(                    "@change_date", Convert.ToDateTime(lblchangedate.Text));                    cmd.Parameters.AddWithValue(                    "@obj_id", obj_id);                    cmd.Parameters.AddWithValue(                    "@ite_id2", Convert.ToInt16(tb_ite_id2.Text));                    conn.Open();                    cmd.ExecuteNonQuery();                    conn.Close();                }            }            GridView1.EditIndex = -1;            this.PopulateData();        }                                          

1:2:3:4:5:6:7:8:9:10:11:12:13:14:15:16:17:18:19:20:21:22:23:24:25:26:27:28:29:30:31:32: