Solved

Button Commands ASP.Net 2005 C#

Posted on 2008-06-25
6
241 Views
Last Modified: 2013-12-16
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
Comment
Question by:introlux
  • 4
6 Comments
 
LVL 5

Expert Comment

by:JuckMan
ID: 21868455
move your btnSave_Click1 to the code behind file and call this from btnPrint_Click1 method. This seems like trivial ..Hope this helps
0
 

Author Comment

by:introlux
ID: 21872687
How do I call the method from btnPrint_Click1??
0
 
LVL 5

Accepted Solution

by:
rendaduiyan earned 500 total points
ID: 21872755
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:introlux
ID: 21872872
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
 

Author Comment

by:introlux
ID: 21873026
?????
0
 

Author Closing Comment

by:introlux
ID: 31470651
Thanks
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Recently while returning home from work my wife (another .NET developer) was murmuring something. On further poking she said that she has been assigned a task where she has to serialize and deserialize objects and she is afraid of serialization. Wha…
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now