|
hi
i have result in datatable and i converted to excel using streamwriter. Now i dont want save to computer and then send mail by using that path.
Is there any other method that i can send that excel without saving to system in c#.
If anybody knows, please reply me.
Thanks in advance.
|
|
|
|
|
Try using a MemoryStream[^] to store the Excel file, and pass that stream to the Attachment constructor[^].
var ms = new MemoryStream();
using (var sw = new StreamWriter(ms))
{
RenderExcelAttachment(sw);
}
var attachment = new Attachment(ms, "data.xlsx", "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
message.Attachments.Add(attachment);
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Hey all,
I want to add a Return-Path to my message so that Bounces can be send to a specific email address.
I tried adding
mm.Header.Add("Return-Path",email) to my MailMessage, but no luck. I've done some research but found nothing useful. Some guys said that it is impossible with system.net.mail.
Any work around or ideas will be appreciated.
Thanks
|
|
|
|
|
I believe the Return-Path header is set based on the Sender property[^].
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Hi
This is my first post.I will introduce my self first.My Name is Chandra Sekhar.I have 2+ experience in developing asp.net applications.
I would like to know where i have to start off if i have to earn a Microsoft certificate in .net.Any study materials,Links,E-Books which are relevant for this are helpful
Chandra Sekhar
|
|
|
|
|
|
Thank you for the link.i have gone through the list of certifications and i am willing to pursue <b>MCSD: Web Applications</b>.
Can you share few <b> sample questions </b> and any study material On Programming in HTML5 with JavaScript and CSS3,
Developing ASP.NET MVC 4 Web Applications,Developing Windows Azure and Web Services
|
|
|
|
|
|
how to get min max restore and close links in calender using webparts in vb.net
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>DISPLAY</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:WebPartManager ID="WebPartManager1" runat="server">
</asp:WebPartManager>
<br />
<asp:WebPartZone ID="WebPartZone1" runat="server">
<ZoneTemplate>
<asp:Calendar ID="Calendar1" BackColor="White" runat="server" BorderColor="#999999" CellPadding="4" DayNameFormat="Shortest" Font-Names="Verdana" Font-Size="8pt" ForeColor="Black" Height="180px" Width="200px">
<DayHeaderStyle BackColor="#CCCCCC" Font-Bold="True" Font-Size="7pt" />
<NextPrevStyle VerticalAlign="Bottom" />
<OtherMonthDayStyle ForeColor="#808080" />
<SelectedDayStyle BackColor="#666666" Font-Bold="True" ForeColor="White" />
<SelectorStyle BackColor="#CCCCCC" />
<TitleStyle BackColor="#999999" BorderColor="Black" Font-Bold="True" />
<TodayDayStyle BackColor="#CCCCCC" ForeColor="Black" />
<WeekendDayStyle BackColor="#FFFFCC" />
</asp:Calendar>
</ZoneTemplate>
</asp:WebPartZone>
<asp:WebPartZone ID="WebPartZone2" runat="server">
<ZoneTemplate>
<asp:BulletedList ID="BulletedList1" displaymode="HyperLink" title="MyLinks" runat="server">
<asp:ListItem Value="http://www.microsoft.com">MicroSoft</asp:ListItem>
<asp:ListItem Value="http://www.msn.com">MsN</asp:ListItem>
<asp:ListItem Value="http://www.contoso.com">Contoso Corp.</asp:ListItem>
<asp:ListItem Value="http://www.yahoo.com">yahoo</asp:ListItem>
</asp:BulletedList>
</ZoneTemplate>
</asp:WebPartZone>
<asp:EditorZone ID="EditorZone1" runat="server">
<ZoneTemplate>
<asp:LayoutEditorPart ID="LayoutEditorPart1" runat="server" />
<asp:AppearanceEditorPart ID="AppearanceEditorPart1" runat="server" />
</ZoneTemplate>
</asp:EditorZone>
<asp:Button ID="Button1" runat="server" Text="Browse Mode" OnClick="Button1_Click" />
<asp:Button ID="Button2" runat="server" Text="display Mode" OnClick="Button2_Click"/>
<asp:Button ID="Button3" runat="server" Text="Edit Mode" OnClick="Button3_Click" />
</div>
</form>
</body>
</html>
|
|
|
|
|
How do i want to do to sent a plain email to the user in visual basic seem i m doing the part of password recovery in the website.
i m new to visual basic and anyone could give me an simple way to solve this problem? is the smtp necessary in sending email or have other method. thank for you willing to help~ 
|
|
|
|
|
What version of asp.net are you using?
The code for 2.0/3.5 is different that 4.0
|
|
|
|
|
|
You use netmail, the mailclient and mail exception to track errors
Dim NetMail As New MailMessage
Dim MailClient As New SmtpClient
Dim smtp_credentials As Net.NetworkCredential = Nothing
Dim mailException As New SmtpException
Then you create your target, subject, encoding and so forth.
NetMail.From = _
New MailAddress(smtpC.Options_WebsiteName & " <" & smtpC.Options_ReplyTo & ">")
NetMail.ReplyToList.Add(New MailAddress(smtpC.Options_WebsiteName & " < " & smtpC.Options_ReplyTo & " > "))
NetMail.To.Add(New MailAddress(m_CustomerName & "<" & m_EmailAddress & ">"))
NetMail.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure
NetMail.IsBodyHtml = True
NetMail.BodyEncoding = System.Text.Encoding.UTF8
NetMail.Priority = MailPriority.Normal
NetMail.Subject = m_RM.GetString("Confirmation of Payment for Order Number")
If your message is HTML, use the NetMail.Body. YOur Body can be any mix and match of properly formatted HTML code, packaged as a string or use can use a string Builder.tostring
NetMail.Body = html_Template.ToString
This part is tricky, I've been playing around with this for a couple of months now, and I think I have it now. I've had to adjust sending credentials to exchange servers in a windows domain, and plain smtp servers outside the domain.
select case smtpC.Connector_AuthMethod.ToUpper
Case "WINDOWS"
If (Convert.ToBoolean(smtpC.Connector_DefaultCredentials) = True) Then
MailClient.UseDefaultCredentials = True
Else
MailClient.UseDefaultCredentials = False
smtp_credentials = New Net.NetworkCredential
smtp_credentials.Domain = smtpC.Credentials_DomainName
smtp_credentials.UserName = smtpC.Credentials_LoginID
smtp_credentials.Password = smtpC.Credentials_Password
MailClient.Credentials = smtp_credentials
End If
Case "SMTP"
MailClient.UseDefaultCredentials = False
smtp_credentials = New Net.NetworkCredential
smtp_credentials.Domain = smtpC.Credentials_DomainName
smtp_credentials.UserName = smtpC.Credentials_LoginID
smtp_credentials.Password = smtpC.Credentials_Password
MailClient.Credentials = smtp_credentials
Now I set the port, host and delivery method and send the message
MailClient.DeliveryMethod = SmtpDeliveryMethod.Network
MailClient.Host = smtpC.Connector_ServerAddress
MailClient.Port = smtpC.Connector_SMTP_PortNum
MailClient.Send(NetMail)
And then dispose of the netmail object
If Not (NetMail Is Nothing) Then
NetMail.Dispose()
NetMail = Nothing
End If
|
|
|
|
|
Hi,
I have windows application developed in VB.NET
Visual Studio 2008
.NET Framework 3.5
SQL Server 2005 Express Edition
The application has a setup project, on clicking the setup.exe the setup runs and the application gets installed on the user’s machine
The setup checks for the existence on SQL Server 2005 Express Edition in user’s machine, if it is not present then it installs the SQL Server 2005 Express edition.
The application works fine on Windows XP and Vista, but it is not working fine on Windows 7, after the set is run on windows 7 the “Unhandled exception” occurs.
Exception details are
************** Exception Text **************
System.IO.IOException: Cannot create a file when that file already exists.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.__Error.WinIOError()
at System.IO.FileInfo.MoveTo(String destFileName)
at DataEntryApplication.COMMONFUNTION.WriteToErrorLogToFile(String msg, String stkTrace, String title, String strQuery)
at DataEntryApplication.COMMONFUNTION.WriteToErrorLog(String msg, String stkTrace, String title, String strQuery, String strIPFailed)
at DataEntryApplication.frmLogin.frmLogin_Load(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Please help
|
|
|
|
|
This error is only faced in Windows 7,
The application is working fine in Windows XP and Vista
|
|
|
|
|
Just lok at the text of the error message: "Cannot create a file when that file already exists".
And where does that happen?
Somewhere called from the Load event handler of frmLogin: DataEntryApplication.frmLogin.frmLogin_Load(Object sender, EventArgs e)
There you write some log files, and try to move a file: System.IO.FileInfo.MoveTo(String destFileName)
And when you try to do so, that file (whose name is stored in destFileName) does already exist.
Two options:
check for the file before you move it, and
- use a different name.
- delete the existing file
|
|
|
|
|
I have the need to use column span. So to best explain this create a gridview with 4 rows and 10 columns/cells at 1PX for the width. The reason for the width to be small is I want to represent a 10 minute time. So eventually I will have 144 of these little cells. But for the test just create 10.
So now try and do a columnspan at cell 4 that says cell 4. When you run the program it makes the cells width bigger for some reason.. I hope someone can help me out a little. I can't get it fixed.
Thanks in advanced.
|
|
|
|
|
You can achieve this by writing your code in OnRowDataBound
e.Row.Cells[cellIndex].ColumnSpan = your value;
Even if you can achieve this, i would recommend to consider other approach. Using colspan and count of column to represent time is not a convincing approach.
Consider setting width of span or div for such cases. JQuery will make your job a lot easier.
|
|
|
|
|
Hii I want to make one application which should be access online in macbook and offline on desktop and when offline database should be updated when it get online. so i m confused in which technology i should make my software. Please help me out.
|
|
|
|
|
What do you mean by online in MacBook and offline in desktop?
there are 2 kinda apps: Desktop apps and Web apps...
Both are pretty different..
Can you first decide what kinda app you wana do?
|
|
|
|
|
Dear All,
[webapplication]
I want to develop a functionality which captures only a selection area in a webpage.
and save the selection area as a image to a location or copy it to clipboard.
i.e want to store the selected area while capturing it and storing it to the database.
and then display that image in the webpage in the next step immediatly.
i.e the functionality will be similar to the snippy tool or fireshot tool where we capture only a section of webpage .
Have searched a lot , but could only find windows application.
kindly guide if any solution.
technology:[asp.net,c#]
Thanks in advance.
|
|
|
|
|
There are plug-ins that perform captures like that,
Do you want to develop a new browser plug-in that does that?
It does not sound like it has anything to do with C# unless you want to work with a window application that manipulates a webbrowser control...
It is a paradox that paradoxes would actually exist in reality.
That means of course that they don't exist.
However, they do!
∫(Edo )dx = Tzumer
∑k( this.Kid) k = this. ♥
|
|
|
|
|
We will have a grid displaying a list of pdf in one section and below that displaying the pdf selected in a webpage.
we want to capture/clip only a section of the pdf by selecting a particluar area in the pdf and displaying the selected area on right side as a image and then save the image captured/clipped to DB(sqlserver).
Kindly let me know if you can refer any existing plugin which we can use or develop/intergrate any plugin developed (jquery) or any other solution .
Regards,
Sriharsha
|
|
|
|
|
Capturing selected area into an image and inserting an image to the DB are two completely different operations.
Here is a plug in [^]for capturing selected area for Chrome, but there a lot more and there are plenty for other browsers as well.
I can suggest you create a small application that uploads the image and saves into the DB, there are many examples (click for one) [^]for that in CP or the web.
It is a paradox that paradoxes would actually exist in reality.
That means of course that they don't exist.
However, they do!
∫(Edo )dx = Tzumer
∑k( this.Kid) k = this. ♥
|
|
|
|
|
a)i tried your solution .
but the problem is we cannot integrate it to our application.
As it saves the image captured in the local file and some manual process will be necessary for it then and then it acts as a external plugin.
Is there a way where we can develop a new functionality to capture the section from pdf and add it to our application.
b)actaully i have developed a fucntionality which selects a area using jquery , but it does not work on a pdf inside a iframe , but works fine same for html files inside iframe.
i.e for pdf files.
any clue .
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
