.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

MySQL trigger send a request/call ASP.NET server

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :ASP.Net
 

I am using MySQL 5.

Is there any possibility that MYSQL trigger has capability to communicate with a .NET service/ASP.NET server?

What I want to do is if there is any update of a table record (eg. employee) sends a "notification" to a server so that latest data will be retrieved by the ASP.NET server.




View Complete Post


More Related Resource Links

how to send message to external message queue in a trigger of sql server ?

  

i write a code to send message to windows message queue,but when i try to add it to clr but failed for need to reference other dll like system.messaging.dll , and when i try to add this dll first, but it need other dll ,too. so i tired to add these dll, and want to know how to
send message to message queue, maybe i'm wrong , maybe there's better way. so ,i hope someone can help me to solve this.
code :
 public class MSGQSpiderTrigger
    {
        public void ExportToMSG()
        {
            SqlTriggerContext sqlTrigger = SqlContext.TriggerContext;
            SqlDataReader reader;
            SqlCommand command;
            MSGDocInfo doc = new MSGDocInfo();
            if (sqlTrigger.TriggerAction == TriggerAction.Insert)
            {
                
                using (SqlConnection connection  = new SqlConnection(@"context connection=true"))
                {
                    connection.Open();
                    command = new SqlCommand(@"SELECT * FROM INSERTED;", connection);
                    reader = command.ExecuteReader();
                    reader.Read();
                   //.... read my data

                    reader.Close();
                }

                  //then send to windows message queue.  
              Message

Help - Cannot call webservice Get error: Server was unable to process request. --> Object reference

  
Here is my code, I don't fully understand the erro because I have instantiated all objects
Any help or advice appreciated.
  
Dim transactionResult As PremiumCredit.TransactionResult = New PremiumCredit.TransactionResult
        Dim newBusiness As PremiumCredit.NewBusiness = New PremiumCredit.NewBusiness
        Dim transferEngine As PremiumCredit.XMLTransferEngine = New PremiumCredit.XMLTransferEngine
        'Build up NewBusiness Object
        newBusiness.AddCoverCode = String.Empty
        newBusiness.BankAccountName = Session("BankAccountName").ToString
        newBusiness.BankAccountNumber = Session("BankAccountNumber").ToString ' 02149187
'Populate the rest of new Business object etc
        System.Net.ServicePointManager.ServerCertificateValidationCallback = New System.Net.Security.RemoteCertificateValidationCallback(AddressOf ValidateCertificate)
        Try
            transactionResult = transferEngine.Crea

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

Send Email from SQL Server Express Using a CLR Stored Procedure

  
Problem
One of the nice things about SQL Server is the ability to send email using T-SQL. The downside is that this functionality does not exist in SQL Server Express. In this tip I will show you how to build a basic CLR stored procedure to send email messages from SQL Server Express, although this same technique could be used for any version of SQL Server.

Solution
If you have not yet built a CLR stored procedure, please refer to this tip for what needs to be done for the initial setup.

I cannot send mail using gmail smtp server

  

 Here is my code

Dim message As System.Net.Mail.MailMessage = New System.Net.Mail.MailMessage()
        message.To.Add("from textbox field")
        message.Subject = "Testing"
        message.From = New System.Net.Mail.MailAddress("sender email ")
        message.Body = "Just Testing"

        Dim smtp As System.Net.Mail.SmtpClient = New System.Net.Mail.SmtpClient()

        Dim client As SmtpClient = New SmtpClient()
        smtp.Credentials = New System.Net.NetworkCredential("username", "password")
        smtp.Port = 25
        smtp.Host = "smtp.gmail.com"
        smtp.EnableSsl = True
        smtp.DeliveryMethod = SmtpDeliveryMethod.Network
        lblmsg.Text = "Your Email has send"

        Try
        &

Call Server Side Code from Javascript in VB.NET

  

Hi

Could anyone give me an example how to call Server Side Function from javascript and then I want to call that javascript function on Button OnClick () Event.


Thanks in Advance

Shabbir



Web Service that will receive xml request and send xml response

  


I am trying to create a web service that can do the following functionality:

Request XML 

<?xml version="1.0" encoding="UTF-8"?>
<Authentication UserName="test" Password="test" MyId="0987">
     <Function>1</Function>
</Authentication>


Response XML - After authenticating request xml from client send them back the following response:

<?xml version="1.0" encoding="UTF-8"?>
<Response>
   <Test MyId="0987">
       <TestType id="11"></TestType>
       <TestType id="22"></TestType>
   </Test>
</Response>


How can I create web service to do this.



send the login credentials from site to another server

  

hi,

  i have a site which uses windows credentials to login and in the site i have link to ssrs server.

when i select the report it asks for authentication which i want to skip and send the same user

crendentials to the ssrsserver to access the report.

can anyone suggest on this..


send email using Godaddy server by gmail

  

 Hello ,

 

My site is hosted  in Godaddy server. And i am using google apps for emailing a/c for that i have changed the  MX-records and then it is working fine.

Then i finished my web site

http://www.placewellsolutions.com/Default.aspx

it is working fine there .

in the site there is a  contactus link which opens

http://www.placewellsolutions.com/ContactUs.aspx

this page basically should send a mail to a particular email id .

for sending mail I am using gmail a/c . (Here is the full code)

 

public void SendEmail(string From,string GmailEmail, string GmailPassword, string To, string Subject, string Body,      
        FileUpload fileupload)
    {       

        System.Net.Mail.MailMessage mail = new System.Net.Mail.MailMessage();
        mail.To.Add(To);
        mail.From = new MailAddress(From, "One Ghost", System.Text.Encoding.UTF8);
        mail.Subject = Subject;
        mail.SubjectEncoding = System.Text.Encoding.UTF8;
  &n

HyperLink use to send request parameter to another page

  

The statement is correct:

<asp:HyperLink ID="HyperLink2" runat="server" Text

make json call to send an email

  

the aspx:

<div class="contactSubmit">
                <asp:ImageButton ID="ibSubmit" runat="server" ValidationGroup="vgContact" /></div>


 

the jquery :

$(document).ready(function () {
            // Add the page method call as an onclick handler for the div.
            $(".contactSubmit").click(function () {
                $.ajax({
                    type: "POST",
                    url: "Home.aspx/GetDate",
                    data: "{}",
                    contentType: "application/json; charset=utf-8",
                    dataType: "json",
                    success: function (msg) {
                        // Replace the div's content with the page method's return.
                        $(".contactSubmit").text(msg.d);
                    }
                });
            });
        });


The problem is that I need to use the text in a text box in my webmethod, and I can't because it's static, this results in a compilation error:

[WebMethod]
    public static string SendContactForm()
    {
        Mail.SendMailMessage(NameTextBox.Text);
    }

<

MySQL to SQL Server Conversion Tools

  
Anyone know of any FREE database conversion tools?

Server ERROR: An error occurred during the parsing of a resource required to service this request.

  
I have created one asp.net 2.0 application and created a setup project. I run this setup in my local machine, the application run fine, but i uploaded into online server I met the following parser error.How to solve this error? Kindly help me. Very urgent.. Kamal....

HOW to call FTP Server and get files using DotNet.

  
I  find some information about to connect and get files using below code. http://www.codeguru.com/csharp/csharp/cs_internet/desktopapplications/article.php/c13163 But i would need to call cd(/) directory using SSIS. can anyone help how to resolve this issue.N.Srikanth Reddy

WCF - First call to Callback instance from Server takes considerable time to make it to the client.

  
Hello. There's a performance problem we are facing that we are unable to fix using DuplexChannels. The first call made by the client to the server reaches the server instantly. The first call made by the server to the first client using a Callback proxy will take several seconds to reach the client. All subsequent calls to the client (as well as other clients) will reach and execute instantly. The client connects to the Server using a proxy to IServiceProvision, supplies an instance to an implementation of IClientCallback and calls IServiceProvision.Start(). The server instantly processes the call and makes an asynchronous call to IClientCallback.DoWork(), which takes several seconds to enter the client's DoWork() implementation. The remainder of the execution then runs smoothly. Also, the server will experience such a slowdown only for the very first call of the first client that connects to it. Is it normal for the Callback interface to take so much time to warmup, only on the first call to the first client? Below is the full source code. Thanks for any information you may provide. Cheers Mike Shared Class Library using System.ServiceModel; namespace Test { [ServiceContract(Namespace = "http://test/IService", CallbackContract = typeof(IClientCallback))] public interface IServiceProvision { [OperationContract] void Start(); [OperationContract] void

Sys.Data.DataContext.saveChanges method doesn't send update to server after DataServiceException ex

  
Hello,I have a page with a simple form that updates a single record in a table in my database.The database is accessed via WCF Data Services. To load and save data from/to the server, I usethe Sys.Data.DataContext object provided by the ASP.NET AJAX library. When the "save" button on theform is clicked, I use the saveChanges method of the Sys.Data.DataContext object to send all changes to the server.Also, at the server side, I use an interceptor that checks the "Price" fields of the record, and throws a DataServiceException exception when the contents of the field is a negative number.Both the JavaScript and the interceptor (in C#) are copied below.Here is the interesting thing:When I enter a negative price in the form, the interceptor throws the exception and my form shows an error message. Good.However, if I then make one of the other fields in the form a bit shorter (for example from "abcd" to "abc"),the saveChanges method doesn't send the data to the server. But it does call the success callback that I passed in to saveChanges, creating the impressionthat the data has been saved. This happens while the Price field is still negative. I used Fiddler to make sure thatno message is sent to the server. Also, the interceptor doesn't get executed.The weird thing is that if I make one of the fields a bit longer instead (for example &q
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend