C# (CSharp) DamTableAdapter.GetDamByID Exemples

Exemple #1

        protected void btnEdit_Click(object sender, EventArgs e)
        {
            DamTableAdapter DamTableAdapter = new DamTableAdapter();
            Dam             originalDam     = DamTableAdapter.GetDamByID(Convert.ToInt32(Request["DamID"]));

            Dam Dam = new Dam();

            if (IsValidData())
            {
                Dam.ID          = originalDam.ID;
                Dam.DamName     = txtDamName.Text.Trim();
                Dam.DamID       = Guid.NewGuid().ToString();
                Dam.Latitude    = txtLatitude.Text.Trim();
                Dam.Longitude   = txtLongitude.Text.Trim();
                Dam.Description = txtDescription.Text.Trim();
                Dam.Status      = "ACTIVE";


                if (DamTableAdapter.Update(Dam) > 0)
                {
                    ltlMessage.Text = "<div class=\"alert alert-success alert-dismissible\"><button type = \"button\" class=\"close\" data-dismiss=\"alert\" aria-hidden=\"true\">&times;</button> <h4><i class=\"icon fa fa-check\"></i> Alert!</h4> Sucessfully Updated <b>" + txtDamName.Text.Trim() + "</b>.</div>";
                    Response.Redirect("~/Dams/damlist.aspx");
                }
            }
        }

Exemple #2

        protected void Page_Load(object sender, EventArgs e)
        {
            ltlMessage.Text = null;
            if (!IsPostBack)
            {
                DamTableAdapter DamTableAdapter = new DamTableAdapter();
                Dam             originalDam     = DamTableAdapter.GetDamByID(Convert.ToInt32(Request["DamID"]));

                txtDamName.Text     = originalDam.DamName;
                txtLatitude.Text    = originalDam.Latitude;
                txtLongitude.Text   = originalDam.Longitude;
                txtDescription.Text = originalDam.Description;
                ltlViewMap.Text     = "<iframe width=\"100%\" height=\"500\" src=\"https://maps.google.com/maps?width=100%&amp;height=500&amp;hl=en&amp;coord=" + txtLatitude.Text + "," + txtLongitude.Text + "&amp;q=" + txtDamName.Text + "+(" + txtDescription.Text + ")&amp;ie=UTF8&amp;t=&amp;z=14&amp;iwloc=B&amp;output=embed\" frameborder=\"0\" scrolling=\"no\" marginheight=\"0\" marginwidth=\"0\"></iframe>";
            }
        }