Convert Datatable To Byte Array To Send As Email Attachment
May 13, 2014
Every morning we send out an email with a text file attached. This is a manual process so I am automating it.I am using an internal mail web service. Its last two parameters are a byte array which is the file contents and a string which is the file name. I passed (...gbytes, "test.txt") and the only thing wrong with it is text.txt is XML. I want it to be text (csv is fine because there is actually four columns that come from a datatable).So I am assuming what's making it XML is this code:
Code:
System.IO.MemoryStream stream = new System.IO.MemoryStream();
System.Runtime.Serialization.IFormatter formatter = new System.Runtime.Serialization.Formatters.Binary.BinaryFormatter();
formatter.Serialize(stream, ds.Tables[0]);
gbytes = stream.GetBuffer();
I am trying to search the Internet for how to convert a datatable to a byte array, but I can't find how to have it be text instead of XML. Also, another parameter our WS takes is a flag to say if it's XML, and I am setting this to false.
View 3 Replies
Similar Messages:
May 21, 2010
In my aspx page I have a HTML inputfile type which allows user to browse for a spreadsheet.Once the user choses the file to upload I want to read the content of the spreadsheet and store the content into mysql database table. I am using the following code to read the content of the uploaded file and convert it into a datatable in order into insert it into database table.
if (filMyFile.PostedFile != null)
{
// Get a reference to PostedFile object
HttpPostedFile myFile = filMyFile.PostedFile;
// Get size of uploaded file
int nFileLen = myFile.ContentLength;
// make sure the size of the file is > 0
if (nFileLen > 0)
{
// Allocate a buffer for reading of the file
byte[] myData = new byte[nFileLen];
// Read uploaded file from the Stream
myFile.InputStream.Read(myData, 0, nFileLen);...................................
View 1 Replies
Apr 28, 2010
I am using Microsoft Outlook interop to display email with filled out email addresses and attachment.
Now Everything works fine except one problem with Attachment. The problem is that I am getting attachment from other methods as Byte Array and if I am not able to pass this byte array as attachment to outlook object's attachment. I believe tt requires a physical file from disk. how can I conver this Byte Array to attach it with Outlook.Attachment object?
Here is my code. In this code, for now I hardcoded attachment from "C: est.txt" but I need to change it to Byte Array, I tried but its throwing error.how can I change it to Byte Array?
##############################################################
[Code]....
View 4 Replies
Mar 27, 2014
I have coded random string as below and i want to convert it to qr code , then send to email automatically...
Dim chars As String = "Test1"
Dim qr As String = ""
Dim r As New Random()
Dim i As Integer
For i = 1 To 5
qr += chars.Substring(r.Next(chars.Length), 1)
Next
View 1 Replies
May 8, 2010
I am develping an application that integrates with an RFID kit. The problem is, the kit comes with an .cs class that accepts data stored in a byte array however, each information stored in the array respresents an int. I wanted to store String information in each array but, my research suggest that a String itself can be converted to a byte array and not a byte....here the code from the .cs class:
byte BlockNo = 0;
byte[] BlockData = new byte[16];
byte ReturnCode = 0;
[code]....
Each t_b*.text respresents an int. Is there a way I can stored a String in a single byte block?
View 1 Replies
Nov 12, 2010
using vb.net 2005.
I'm trying to a byte array column to a table but getting an exception:
<error>
datatype argument cannot be null
</error>
The code I have is:
[Code]....
Does anyone know the correct syntax for this?
View 1 Replies
Feb 17, 2010
i need the to convert the byte array in to string. The byte array is a two dimentional array. Is it possible to convert?
View 3 Replies
Aug 19, 2010
How can I convert DataSet to byte array
View 2 Replies
May 16, 2010
I have datatable with records and i have existng Excel file in my application temp folder i want to export datatable records in this excel file workbook and i want to convert this excel workbook into byte array and i want to send this byte array in reponse.write to user to give download excel file option
View 6 Replies
Nov 24, 2010
I have a richtextbox and i wrote it this text and add pictures like below.[img] symbolize images.
[Img]
askdiaksidsasidla,isdlasdliasldassldi
alsdksalsdksalskdsalskdsalsdlasdkalsskdsa
[Img]
askdiaksid sasidla,isdlasdliasldassldi
asdasdasd als dksalsdksals kdsal skdsalsdlasdkalsskdsa
if we get those images hexadecimal rtf codes we have "0ef1caf...........0d" billions characters like this.I what to convert this hexadecimal explanation to byte array to save images one by one to where i want.
View 5 Replies
May 21, 2010
I want to send an email that has a machine readable part you cut and paste into an asp.net page and you get the information. I have stored all the information in an object and then used an XMLSerizer to create some xml. It all worked fine until I added some Images as byte[] to the object. If I dump the resulting string to disk then I can recreate the object fine but after it appears in the email client and I try to cut and paste it it never works. Clearly there are non standard characters coming out that email clients don't like.
Is there some encoding I could apply to my XML that would make it display correctly in an email client? Then I could cut, paste, decode and deserilize to get my object back.
View 1 Replies
Nov 23, 2010
My current application send an .rtf in an attachement. I wish to send pdf instead of that.Where in my code I should modify the same?
Below is my code
RichTextBox rtbReport = new RichTextBox(); //Creating instance of Richtextbox
AppResult objResult = null; //Object of Class
frmExaminationReport objReport = new frmExaminationReport(examinationID, ProviderID, PatientID, examType); // Object of Class
AddressBookDataTable dtAddress = null;
rtbReport.Rtf = objReport.RTF; // Entire Result is assigned to Richtext box class
frmMail objMail = new frmMail(); //Object of Mail Class
string directoryPath = Application.StartupPath + "\Temp"; //Creating directory
string tempFileName = "Report_" + DateTime.Today.Year.ToString() + DateTime.Today.Month.ToString() + ".rtf"; //Generating Name
FileStream fsReport = new FileStream(directoryPath + "\" + tempFileName, FileMode.CreateNew); // FileStream
fsReport.Write(ASCIIEncoding.ASCII.GetBytes(rtbReport.Rtf), 0, rtbReport.Rtf.Length); // Writing
fsReport.Flush();
fsReport.Close();
fsReport.Dispose();
objMail.MailSubject = examType + " Report"; //Mail Subject
Let me know if any inputs needed
View 1 Replies
Feb 28, 2011
I would like to send an email with attachement via form, and I can`t figure it out.
My View
[Code]....
My Controller
[Code]....
I get the FileNotFoundException, it is trying to search for the file name on the local machine insted of returning the user input, something like "C:\exemple.txt" .
I also use a jQuery Ajax email form, when I submit the form via ajax the fileAttachement is always null, is there any way around it ?
My Script
[Code]....
View 2 Replies
Mar 27, 2010
Im generating a PDF file. Normally I send this to the user using a .ashx file, where the user can directly download it from his browser (see that code below).
Protected Function getfile() As MemoryStream
Dim stream As MemoryStream = New MemoryStream
If document.PageCount > 0 Then
document.Save(stream, False)
'Context.Response.Clear()
'Context.Response.ContentType = "application/pdf"
'Context.Response.AddHeader("Content-disposition", "attachment;filename=TicketEZ_tickets_" + eventname + ".pdf")
'Context.Response.AddHeader("content-length", stream.Length.ToString)
'Context.Response.BinaryWrite(stream.ToArray)
'Context.Response.Flush()
Return stream
stream.Close()
'Context.Response.End()
End If
But now I want to send this file as an email attachment...how can I do that? I tried this, but that doesnt work...(Value of type 'System.IO.MemoryStream' cannot be converted to 'String')
Dim att As New System.Net.Mail.Attachment(getfile)
Msg.Attachments.Add(att)
View 9 Replies
Jan 26, 2011
I have a strange problem with sending email via asp.net.
I adding to my email an attachment with long name ("Xxxxxxxx ąę łóxxxx yyyyyyyyyńęąąyy bbbbbbbbbb b wwwwwwwww wwwwwww ooooooooo" - polish chars included). Next I receiving that email with that file but I can't read the file. There is like damaged, with different name - ""=_utf-8_B_WHh4eHh4eHggxIXEmSDFgsOzeHh4eCB5" and the file size is a little bigger.
View 5 Replies
Feb 10, 2010
I want to send email with image as attachment.
It should be happen by retriving image from sql server database.
View 3 Replies
Oct 25, 2010
I know how to send an email. But now I want to send an email with an attachment. I also want to allow the user to browse for and then select the attachment. I cannot seem to find any info on this. All the articles I find show how to attach a file where you know the path and file name. I want the user to browse their drive, select a file, and then send an email with this attachment.
View 3 Replies
Oct 27, 2010
Is there a way to send the same email to multiple recipients but also send with an attachment to only 1 of them?eg. I have a form that gets filled out, the user gets a copy of the form with an attachment (file sits on server). The site owner also wants the email (through bcc) but without the attachment.
View 2 Replies
May 11, 2010
I have completed sending attachment/pdf with email.
I have to send password protected attachment/pdf while sending email so that reciepeint should be asked to enter password while opening attachment/pdf and he will open attachment/pdf only after entering password.
View 3 Replies
Feb 24, 2014
I have the following code to convert page to pdf
Protected Sub btnExport_Click(sender As Object, e As EventArgs)
Response.ContentType = "application/pdf"
Response.AddHeader("content-disposition", "attachment;filename=TestPage.pdf")
[Code].....
But i want the file to save in the particular folder....
and send to an mail...
View 1 Replies
Jan 8, 2014
I want to put email button in my detail view form when user press email button it automatically move towards login when he enter the id pass automatically form attached of that detail view all this records n form is store in my database how can i make this possibel?
View 1 Replies
Apr 10, 2013
I have a process to send report to exchange server"outlook" i want to send it as pdf format. how can i do this process??
View 1 Replies
Apr 27, 2012
I have a small form
employeenumber ---textbox
employee name ---- textbox
employee department ---- textbox
employee sal ----- textbox
employee age ---- textbox
Now I have a webpage with search textbox
employeenumber ----- textbox (search criteria)
When user types employee number all the sql related data should fill the form containing employee name, sal, age , dept etc.
next
I have 2 buttons
excel export
automail
In excel export i have a specified format
IF IMGAE NOT DISPLAYED I HAVE CREATED MACRO
Range("A1:A2").Select With Selection .HorizontalAlignment = xlCenter .VerticalAlignment = xlBottom .WrapText = False .Orientation = 0 .AddIndent = False .IndentLevel = 0 .ShrinkToFit = False .ReadingOrder = xlContext .MergeCells = False End With Selection.Merge ActiveCell.FormulaR1C1 = "LOGO" Range("A1:A2").Select With Selection .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter .WrapText = False .Orientation = 0 .AddIndent = False .IndentLevel = 0 .ShrinkToFit = False .ReadingOrder = xlContext .MergeCells = True End With Range("B1:G2").Select With Selection .HorizontalAlignment = xlGeneral .VerticalAlignment = xlCenter .WrapText = False
[Code] ....
What I actually need is : when I click export button textbox data should be send to excel file and particular textbox data should be received at particular cell.
E.g:- textbox1 to send to c3 or c4
textbox 2 to send g9
when i click mail button, that data should be send to excel and automailed as attachment, i have 3 excel files with different formats, export button should view all the excel files with their respective data and mail button should send mail the excel files with data ,
1 user i excel file
2nd user 2nd excel file
3rd user 3 excel file
View 1 Replies
Mar 26, 2016
My requirement is like .... I have a text box for ToEmail address , another control is to upload "n" no of files. And a button to send those selected files ToEmail address which had entered in textbox.
View 1 Replies
Aug 31, 2010
how to convert html page into pdf format & i have to send that same pdf by attachment.
View 1 Replies