insert and update data to excel from sql server

Question

Hi,

   I want to insert and update a particular column in excel from sql server using stored procedure.i have one excel file.that i want to update a particular column.that datas are pull from sqlserver.



and i have one application that is insert data to sqlserver from excel.


please modify that application for my requirement.I attached that web application below.

Answer 1

Why don't you use Gmail Server . its working well ..

Yahoo Server Does not Provide..SMTP Service for Free

follow this great article ..you will have idea about sending mail with attachment .

http://www.c-sharpcorner.com/UploadFile/meetuchoudhary/sendmail08142009123125PM/sendmail.aspx

code is for asp.net but its working under Windows Form application too...

if my answer helped you then check "Do you like this answer" check box

Answer 2

hello home base


thank you

it work

regard
han

Answer 3

You can also try this code sample

        MailMessage Mail = new MailMessage();

        MailAddress ma = new MailAddress(txtFrom.Text,txtName.Text);
        Mail.From = ma;
        Mail.To.Add(txtTo.Text);

        if(txtCC.Text.Trim().Length != 0)
            Mail.CC.Add(txtCC.Text);
        
        if(txtBCC.Text.Trim().Length != 0)
            Mail.Bcc.Add(txtBCC.Text);
       
        Mail.Subject = txtSubject.Text;

    
        if (txtAttachment.Text.Trim().Length != 0)
        {
            string sAttach = txtAttachment.Text.Replace("\\","\\\\");
            Mail.Attachments.Add(new Attachment(sAttach));
        }
    

        //Note: When you make "IsBodyHtml" to true make 
    //ValidateRequest="false" in page derective
    //As to make HTML content passed.
        Mail.IsBodyHtml = true;        
        Mail.Body = txtComment.Text;


        //Setting Reply address.
        if (txtReplyTo.Text.Trim().Length != 0)
        {
            Mail.Headers.Add("Reply-To", txtReplyTo.Text);
        }
        else
        {
            Mail.Headers.Add("Reply-To", txtFrom.Text);
        }

        
        try
        {
            SmtpClient smtpMailObj = new SmtpClient();
        //eg:localhost, 192.168.0.x, replace with your server name
            smtpMailObj.Host = "myMailServer"; 
            smtpMailObj.Send(Mail);
            Response.Write("Your Message has been sent successfully");
        }
        catch (Exception ex)
        {
            Response.Write("Message Delivery Fails");
        }

reference link

more info

hope you will get your answer,Thanks ....