Similar Threads:
1.I am having difficulty sending message with an excel attachment (3
I get an error message that a server time out because the message is too
large. I have increased the timeout . I also have an icon when I hit send
that states "Microsoft Outlook synchronizing folders ....it seems to run an
inordinate amount of time. Any Suggestions?
2.I am having trouble encrypting e-mail messages
I followed the directions for digitally signing and encrypting e-mails. I
sent the certificate to a friend, had him store it in my contact/certificate,
but I can't send encrypted messages. I get an error saying the user doesn't
have a certificate or theirs a conflict in encryption methods.
Any ideas?
3.retrive preselected value in second drop down list from the first drop down list
Hi
here is my scenario, I create a drop down list in itemtemplate.(that
drop down is created from db), after user
click edit command, my ideal plan is have another drop down list in
edititemtemplate with preselected value from
the previous drop down list, so far I can only achieved with the
regular drop down list in edititemtemplate with no preselected value
from previous one. anyone can help me.
thanks in advance. below is my current sample code.
<%@ Page Language="VB" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script language="VB" runat="server">
Dim objConnection As SqlConnection
Dim myDataReader As SqlDataReader
Sub Page_Load(Sender As Object, E As EventArgs)
' Set up our connection.
objConnection = New SqlConnection("Data Source=sql;Initial
Catalog=pub;User Id=xxx;Password=xxxxx;")
LoadDataFromDB
If Not IsPostBack Then
DataBindGrid
End If
End Sub
Sub LoadDataFromDB()
Dim objCommand As SqlCommand
' Create new command object passing it our SQL query and
telling it which connection to use.
objCommand = New SqlCommand("SELECT * FROM Educationtraining
WHERE Username = 'weifon888';", objConnection)
' Open the connection, execute the command, and close the connection.
objConnection.Open()
myDataReader =
objCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
End Sub
Sub DataBindGrid()
DBEditDataGrid.DataSource = myDataReader
DBEditDataGrid.DataBind
End Sub
'----------------------------------------------------------------------------------------------
Sub DBEditDataGrid_Edit(Sender As Object, E As
DataGridCommandEventArgs)
DBEditDataGrid.EditItemIndex = E.Item.ItemIndex
DataBindGrid
End Sub
Sub DBEditDataGrid_Cancel(Sender As Object, E As
DataGridCommandEventArgs)
DBEditDataGrid.EditItemIndex = -1
DataBindGrid
End Sub
Sub DBEditDataGrid_Update(ByVal Sender As Object, ByVal E As
DataGridCommandEventArgs)
' Since the textboxes are autogenerated we don't know their
names, but we do know their positions.
Dim Tempdroplist As DropDownList
Dim Tempdropvalue As String
Dim strUser As String = E.Item.Cells(0).Text
Dim certother As TextBox = E.Item.Cells(1).Controls(0)
Dim strcertother = Replace(certother.Text, "'", "`")
Tempdroplist = E.Item.FindControl("teachercert")
Tempdropvalue = Tempdroplist.SelectedItem.Value
Response.Write(strUser)
Response.Write(strcertother)
Response.Write(Tempdropvalue)
' Update the appropriate record in our database.
Dim objCommand As SqlCommand
Dim strSQLQuery As String
' Build our update command.
strSQLQuery = "UPDATE Educationtraining SET Certother = '" &
strcertother & "' WHERE Username = 'johndoe'"
' Create new command object passing it our SQL query and
telling it which connection to use.
objCommand = New SqlCommand(strSQLQuery, objConnection)
' Close our open DataReader
myDataReader.Close()
Try
' Execute the command
objConnection.Open()
objCommand.ExecuteNonQuery()
objConnection.Close()
Catch Ex As Exception
Finally
objConnection.Close()
End Try
' Refresh our copy of the data
LoadDataFromDB()
' Reset our current edit item and rebind the grid
DBEditDataGrid.EditItemIndex = -1
DataBindGrid()
End Sub
</script>
<html>
<head>
<title>Modify User Profile</title>
<script language="javascript" type="text/javascript">
window.history.forward(1);
</Script>
</head>
<body>
<form id="Form1" runat="server">
<asp:DataGrid id="DBEditDataGrid" runat="server"
BorderWidth = "1px" CellSpacing = "2" CellPadding = "2"
HeaderStyle-Font-Bold = "True"
OnEditCommand = "DBEditDataGrid_Edit"
OnCancelCommand = "DBEditDataGrid_Cancel"
OnUpdateCommand = "DBEditDataGrid_Update"
AutoGenerateColumns = "False"
>
<Columns>
<asp:BoundColumn HeaderText="Username" DataField="Username"
ReadOnly="True" />
<asp:BoundColumn HeaderText="Cert Other" DataField="Certother"
/>
<asp:TemplateColumn FooterText="test" HeaderText="dropdown">
<EditItemTemplate>
<asp:DropDownList ID="teachercert" runat="server">
<asp:ListItem>Yes</asp:ListItem>
<asp:ListItem>No</asp:ListItem>
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server"
DataSourceID="SqlDataSource1"
DataTextField="Teachercert"
DataValueField="Teachercert" Enabled="False" AutoPostBack="True">
</asp:DropDownList><asp:SqlDataSource
ID="SqlDataSource1" runat="server" ConnectionString="<%$
ConnectionStrings:testConnectionString %>"
SelectCommand="SELECT [Teachercert] FROM
[EducationTraining]"></asp:SqlDataSource>
</ItemTemplate>
</asp:TemplateColumn>
<asp:EditCommandColumn
HeaderText = "Edit"
EditText = "Edit & Continue"
CancelText = "Cancel"
UpdateText = "Update & Continue"
/>
</Columns>
<HeaderStyle Font-Bold="True" />
</asp:DataGrid>
</form>
</body>
</html>
4.Attach An outlook message to an outlook message
How do I attach an outlook email message as an attachment within
another outlook email message.
Right now I am using the following code. But I was wondering if there
is a better way to do this without using a file that needs to be
deleted later.
private MailMessage addAttachment(MailMessage Mail, MailItem item)
{
string path "Messages\\message" + message_id+ ".MSG";
Mail.IsBodyHtml = true;
item.SaveAs(path,
Microsoft.Office.Interop.Outlook.OlSaveAsType.olMSG);
System.Net.Mail.Attachment attach = new
System.Net.Mail.Attachment(path);
attach.Name = "OriginalMessage.MSG";
Mail.Attachments.Add(attach);
message_id++;
}
5.Drag & Drop of Outlook message + attachments to VB.Net form
Does anyone know how to drag&drop a message with attachments from Outlook
(2002 or 2003) in to a VB.Net windows form.
This is really stumping me. I've spent a fair amount of time trying to find
a solution on the internet, with limited success.
I do have code to drag an attachment directly from Outlook to a form, but
not a whole message.
I want to have access to an object reprensenting the message so I can bust
out the message and attachments individually.
I have implemented a solution involving dragging the e-mail message from
Outlook to the desktop, then from the desktop to the windows form, but the
users don't want to do that and I don't think they should have to.
I've seen libraries and code that seem to make this easy using VB6, C++, or
COM, but almost nothing in .Net except simple examples of either files or
tree items, not Outlook e-mails directly onto VB.Net Winforms.
Any help appreciated.
Dave Anderson.
6. Drag Drop Messages Form Outlook
7. Drag & Drop Outlook.MailItem to a Windows.Forms.Form and save it
8. Drag and Drop an attachment from an Outlook message