Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 294
  • Last Modified:

Button Commands ASP.Net 2005 C#

Hi,

I would to have more than one funnction running when the button btnPrint_Click1 is clicked.

I have attached the code. At the moment i would like btnPrint_Click1 to do the same function that btnSave_Click1 does, which is adding data into the database.

So when clicking on the btnPrint_Click1, i would like it to send an email, and add data into the database.

Any help will be appareciated. I am using Visual Studio .Net 2005 in C#

introlux
===================================================================
ASPX
===================================================================
 
<script runat="server" language="C#">
 
 
 
    OleDbConnection objConn = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=C:\\ProCom.mdb");
    OleDbCommand objCmd; 
        string sqlCmd; 
 
    void btnSave_Click1(Object s, EventArgs e)
    {
        sqlCmd = "INSERT INTO tblProCom (Pid, PName, ICD_IDF, PType, CName, PContact, SContact, NumSurvey, WNumber, Market, Languages, EstSurvLen, TotNoQues, SampSource, SampCri, TargNoComp, TargNoQuo_Mark, InciRate, CPCIR, FStart, FFinish, ProvOfQues, TestLink, FDataDel, Livewire, NumIntDataSet, Other, FDataSet, Tables, CodFrameGen, Coding, DataMerg, Ques, Stim, Samp, Soli, DPSpec) VALUES (@Pid, @PName, @ICD_IDF, @PType, @CName, @PContact, @SContact, @NumSurvey, @WNumber, @Market, @Languages, @EstSurvLen, @TotNoQues, @SampSource, @SampCri, @TargNoComp, @TargNoQuo_Mark, @InciRate, @CPCIR, @FStart, @FFinish, @ProvOfQues, @TestLink, @FDataDel, @Livewire, @NumIntDataSet, @Other, @FDataSet, @Tables, @CodFrameGen, @Coding, @DataMerg, @Ques, @Stim, @Samp, @Soli, @DPSpec)";
        OleDbCommand objCmd = new OleDbCommand(sqlCmd, objConn);
        objCmd.Parameters.Add("@Pid", txtPid.Text);
        objCmd.Parameters.Add("@PName", txtPName.Text);
        objCmd.Parameters.Add("@ICD_IDF", ICD_IDFDrop.SelectedValue);
        objCmd.Parameters.Add("@PType", pTypeDrop.SelectedValue);
        objCmd.Parameters.Add("@CName", txtCName.Text);
        objCmd.Parameters.Add("@PContact", txtPContact.Text);
        objCmd.Parameters.Add("@SContact", txtSContact.Text);
        objCmd.Parameters.Add("@NumSurvey", txtNumSurvey.Text);
        objCmd.Parameters.Add("@WNumber", txtWNumber.Text);
        objCmd.Parameters.Add("@Market", txtMarket.Text);
        objCmd.Parameters.Add("@Languages", txtLanguages.Text);
        objCmd.Parameters.Add("@EstSurvLen", txtEstSurvLen.Text);
        objCmd.Parameters.Add("@TotNoQues", txtTotNoQues.Text);
        objCmd.Parameters.Add("@SampSource", txtSampSource.Text);
        objCmd.Parameters.Add("@SampCri", txtSampCri.Text);
        objCmd.Parameters.Add("@TargNoComp", txtTargNoComp.Text);
        objCmd.Parameters.Add("@TargNoQuo_Mark", txtTargNoQuo_Mark.Text);
        objCmd.Parameters.Add("@InciRate", txtInciRate.Text);
        objCmd.Parameters.Add("@CPCIR", txtCPCIR.Text);
        objCmd.Parameters.Add("@FStart", txtFStart.Text);
        objCmd.Parameters.Add("@FFinish", txtFFinish.Text);
        objCmd.Parameters.Add("@ProvOfQues", txtProvOfQues.Text);
        objCmd.Parameters.Add("@TestLink", txtTestLink.Text);
        objCmd.Parameters.Add("@FDataDel", txtFDataDel.Text);
        objCmd.Parameters.Add("@Livewire", LivewireDrop.SelectedValue);
        objCmd.Parameters.Add("@NumIntDataSet", txtNumIntDataSet.Text);
        objCmd.Parameters.Add("@Other", txtOther.Text);
        objCmd.Parameters.Add("@FDataSet", txtFDataSet.Text);
        objCmd.Parameters.Add("@Tables", TablesDrop.SelectedValue);
        objCmd.Parameters.Add("@CodFrameGen", CodFrameGenDrop.SelectedValue);
        objCmd.Parameters.Add("@Coding", txtCoding.Text);
        objCmd.Parameters.Add("@DataMerg", txtDataMerg.Text);
        objCmd.Parameters.Add("@Ques", QuesDrop.SelectedValue);
        objCmd.Parameters.Add("@Stim", StimDrop.SelectedValue);
        objCmd.Parameters.Add("@Samp", SampDrop.SelectedValue);
        objCmd.Parameters.Add("@Soli", SoliDrop.SelectedValue);
        objCmd.Parameters.Add("@DPSpec", DPSpecDrop.SelectedValue);     
 
        objConn.Open();
        objCmd.ExecuteNonQuery();
        objConn.Close();
 
        Response.Redirect("Default.aspx");
}
</script>
 
=============================================================
CS File
=============================================================
 
    protected void btnPrint_Click1(Object s, EventArgs e)
    {
        MailAddress FromAddress = new MailAddress("project@theidfactor.com");
        MailAddress ToAddress = new MailAddress("project@theidfactor.com");
        MailMessage message = new MailMessage(FromAddress, ToAddress);
        message.Subject = "New Project Has been commissioned";
        message.Body = txtPName.Text + "Has now been commissioned";
        SmtpClient client = new SmtpClient("mail.tmnplc.com", 25);
        client.Send(message);
 
        Response.Redirect("Default.aspx");
    }
 
    protected void btnClear_Click1(object sender, EventArgs e)
    {
 
    }
    protected void btnSave_Click1(object sender, EventArgs e)
    {
    }

Open in new window

CreateProCom.txt
CreateProCom.aspx.txt
0
introlux
Asked:
introlux
  • 4
1 Solution
 
JuckManCommented:
move your btnSave_Click1 to the code behind file and call this from btnPrint_Click1 method. This seems like trivial ..Hope this helps
0
 
introluxAuthor Commented:
How do I call the method from btnPrint_Click1??
0
 
rendaduiyanCommented:
private void sendMail()
{
         MailAddress FromAddress = new MailAddress("project@theidfactor.com");
        MailAddress ToAddress = new MailAddress("project@theidfactor.com");
        MailMessage message = new MailMessage(FromAddress, ToAddress);
        message.Subject = "New Project Has been commissioned";
        message.Body = txtPName.Text + "Has now been commissioned";
        SmtpClient client = new SmtpClient("mail.tmnplc.com", 25);
        client.Send(message);
 
        Response.Redirect("Default.aspx");

}
private void saveData()
{
   .....
}



private void otherTask()
{
....
}

protected void btnPrint_Click1(Object s, EventArgs e)
{
     sendMail();
     saveData();
     otherTask();
}
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
introluxAuthor Commented:
That is working fine, but after doing this alteration, I am receiving the following error:

Compiler Error Message: CS0128: A local variable named 'objCmd' is already defined in this scope

Source Error:

 

Line 29:
Line 30:         sqlCmd = "INSERT INTO tblProCom (Pid, PName, ICD_IDF, PType, CName, PContact, SContact, NumSurvey, WNumber, Market, Languages, EstSurvLen, TotNoQues, SampSource, SampCri, TargNoComp, TargNoQuo_Mark, InciRate, CPCIR, FStart, FFinish, ProvOfQues, TestLink, FDataDel, Livewire, NumIntDataSet, Other, FDataSet, Tables, CodFrameGen, Coding, DataMerg, Ques, Stim, Samp, Soli, DPSpec) VALUES (@Pid, @PName, @ICD_IDF, @PType, @CName, @PContact, @SContact, @NumSurvey, @WNumber, @Market, @Languages, @EstSurvLen, @TotNoQues, @SampSource, @SampCri, @TargNoComp, @TargNoQuo_Mark, @InciRate, @CPCIR, @FStart, @FFinish, @ProvOfQues, @TestLink, @FDataDel, @Livewire, @NumIntDataSet, @Other, @FDataSet, @Tables, @CodFrameGen, @Coding, @DataMerg, @Ques, @Stim, @Samp, @Soli, @DPSpec)";
Line 31:         OleDbCommand objCmd = new OleDbCommand(sqlCmd, objConn);
Line 32:         objCmd.Parameters.Add("@Pid", txtPid.Text);
Line 33:         objCmd.Parameters.Add("@PName", txtPName.Text);
 
0
 
introluxAuthor Commented:
?????
0
 
introluxAuthor Commented:
Thanks
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now