コード例 #1
0
        protected void Button1_Click(object sender, EventArgs e)
        {
            StoreProcClass spc = new StoreProcClass();

            spc.storeDeleteParams("@id", Convert.ToInt32(TextBox1.Text));

            spc.DeleteData(getConCfg);

            Response.Redirect("~/DeleteStored.aspx");
        }
コード例 #2
0
        protected void Button1_Click(object sender, EventArgs e)
        {
            string getConCfg = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

            StoreProcClass spc = new StoreProcClass();

            spc.storeInsertParams("@name", TextBox1.Text);
            spc.storeInsertParams("@email", TextBox2.Text);
            spc.storeInsertParams("@username", TextBox3.Text);
            spc.storeInsertParams("@pass", TextBox4.Text);
            spc.storeInsertParams("@pic", "~/images/" + TextBox2.Text);

            spc.InsertData(getConCfg);

            Response.Redirect("~/StoredProcedure.aspx");
        }
コード例 #3
0
ファイル: EditStored.aspx.cs プロジェクト: xnaesx/pt-tgpsi293
        protected void Button1_Click(object sender, EventArgs e)
        {
            StoreProcClass spc = new StoreProcClass();

            spc.storeEditParamsID("@getID", Convert.ToInt32(TextBox1.Text));

            spc.storeEditParams("@getName", TextBox2.Text);
            spc.storeEditParams("@getEmail", TextBox3.Text);
            spc.storeEditParams("@getUser", TextBox4.Text);
            spc.storeEditParams("@getPass", TextBox5.Text);
            spc.storeEditParams("@getPic", TextBox6.Text);

            spc.EditData(getConCfg);

            Response.Redirect("~/EditStored.aspx");
        }