Solved

Button Commands ASP.Net 2005 C#

Posted on 2008-06-25
6
246 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
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

930 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

9 Experts available now in Live!

Get 1:1 Help Now