Sending mail with attachment file with direct path

Question

Hi,

I am having an error while passing a direct  path to mail attachment.

 

Please check and update me soon. Dead line till today.

// Code   as below

public void sendmail_to_user()
{
string to = txtemail.Text; //To address
string from = "[e-mail]"; //From address
string[] Multiple = to.Split(',');
MailMessage message = new MailMessage();
message.From = new MailAddress(from);
foreach (string multiple_email in Multiple)
{
message.To.Add(new MailAddress(multiple_email));
}
//http://localhost:1728/InsertRecordMSAccess(CSharp)/file/pitamber.pdfhttp://localhost:1728/InsertRecordMSAccess(CSharp)/file/CrystalReportViewer1.pdf
//message.Attachments.Add(new Attachment("/file/" + txtContact.Text + ".pdf"));
// Below i am passing path of my document
message.Attachments.Add(new Attachment("file/CrystalReportViewer1.pdf"));
//if (FileUpload2.HasFile)//Attaching document
//{
// string FileName = Path.GetFileName(FileUpload2.PostedFile.FileName);
// message.Attachments.Add(new Attachment(FileUpload2.PostedFile.InputStream, FileName));
//}
string mailbody = "Message Body";
message.Subject = "Subject";
message.Body = mailbody;
message.BodyEncoding = Encoding.UTF8;
message.IsBodyHtml = true;
SmtpClient client = new SmtpClient("smtp.gmail.com", 587); //Gmail smtp
System.Net.NetworkCredential basicCredential1 = new
System.Net.NetworkCredential("[e-mail]", "Password");
client.EnableSsl = true;
client.UseDefaultCredentials = false;
client.Credentials = basicCredential1;
try
{
client.Send(message);
}
catch (Exception ex)
{
throw ex;
}
}

Answer 1

.NET:   
   string userString = textBox1.Text;
   string replacedString = userString.Replace("'", "''");
 
SQL:
   replacedString = Replace(userString,"'","''")
 
Hope this helps.

Answer 2

Hi Giorgio,
    Whenever you have single quotes, replace them with 2 single quotes. That should work.

Answer 3

Nainil:
 
Yes, thank you.

Answer 4

Nainil:
 
Can you give me a sample code of the 2 types?
 

Answer 5

Giorgio,
   You can either use .NET string.Replace() method to replace any single quotes with 2 single qoutes or you can use T-SQL's Replace function. Since the value being inserted is passed in as a SqlParameter.Value property, you can run the Replace function through it and ensure that any string being passed to the stored procedure is clean. Hope this helps.

Answer 6

Nainil:
 
Yes, if it was a string. But it will be some text that the user entered. Is there a way to do it automatically when I put it into the sql command to save it?