コード例 #1
0
        public void UpdateAddress_Click(object s, DataListCommandEventArgs e)
        {
            CDalAddress oDb = new CDalAddress();
            TextBox     txtAdrsID;
            TextBox     txtFName;
            TextBox     txtLName;
            TextBox     txtPhone;
            TextBox     txtEMail;
            TextBox     txtWebPage;
            TextBox     txtAge;
            TextBox     txtComments;

            txtAdrsID   = (TextBox)e.Item.FindControl("txtAdrsID");
            txtFName    = (TextBox)e.Item.FindControl("txtFName");
            txtLName    = (TextBox)e.Item.FindControl("txtLName");
            txtPhone    = (TextBox)e.Item.FindControl("txtPhone");
            txtEMail    = (TextBox)e.Item.FindControl("txtEMail");
            txtWebPage  = (TextBox)e.Item.FindControl("txtWebPage");
            txtAge      = (TextBox)e.Item.FindControl("txtAge");
            txtComments = (TextBox)e.Item.FindControl("txtComments");

            oDb.strConnection = ConfigurationSettings.AppSettings["appStrConnection"];

            oDb.Update(Int32.Parse(txtAdrsID.Text)
                       , txtFName.Text
                       , txtLName.Text
                       , txtPhone.Text
                       , txtEMail.Text
                       , txtWebPage.Text
                       , Int16.Parse(txtAge.Text)
                       , txtComments.Text);

            dlAddress.EditItemIndex = -1;
            BindData();
        }
コード例 #2
0
        private void BindData()
        {
            CDalAddress oDb = new CDalAddress();

            oDb.strConnection = ConfigurationSettings.AppSettings["appStrConnection"];

            dlAddress.DataSource = oDb.getAll();
            dlAddress.DataBind();
            oDb = null;
        }
コード例 #3
0
        public void DeleteAddress_Click(object s, DataListCommandEventArgs e)
        {
            CDalAddress oDb = new CDalAddress();
            TextBox     txtAdrsID;

            oDb.strConnection = ConfigurationSettings.AppSettings["appStrConnection"];

            txtAdrsID = (TextBox)e.Item.FindControl("txtAdrsID");

            oDb.Delete(Int32.Parse(txtAdrsID.Text));

            // reset edit item index to nothing
            dlAddress.EditItemIndex = -1;
            BindData();
        }
コード例 #4
0
        public void addContact_Click(object s, System.EventArgs e)
        {
            // Add a blank record and set the current index to the new row.
            // display the record in edit style.
            CDalAddress oDb    = new CDalAddress();
            Int32       adrsID = 0;

            oDb.strConnection = ConfigurationSettings.AppSettings["appStrConnection"];

            // Add a new record with some defaults.  store the New ID for the next step
            adrsID = oDb.Add("fname", "lname", "() -", "@", "http://", 0, "");

            // Use the Id above to fill the DataList in the edit mode
            dlAddress.DataSource    = oDb.getByID(adrsID);
            dlAddress.EditItemIndex = 0;
            dlAddress.DataBind();
            oDb = null;
        }