Does ASP.NET support pop3 access. I would like to read a pop3 account. If not does anyone know of any good free pop3 asp.net components. I am using asp.net vb if this makes any difference
Thanks
Granthttp://www.google.be/search?q=cache:uhM2afinXZAJ:www.codeproject.com/useritems/POP3Library.asp+C%23+pop3+codeproject&hl=nl&ie=UTF-8
http://www.google.be/search?q=cache:01fZDLtY80QJ:www.codeproject.com/csharp/pop3client.asp+C%23+pop3+codeproject&hl=nl&ie=UTF-8
google is your friend :)
dim ConnString as string = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=MyDBPath;"
dim conn As System.Data.OleDb.OleDbConnection(ConnString)
dim cmd As New OleDb.OleDbCommand()
dim dr as OleDb.OleDbDataReader
cmd.connection = conn
cmd.CommandType = CommandType.Text
cmd.CommandText = "select id, name from mytable"
try
conn.open
dr = cmd.executereader() 'assuming dr is your datareader
myDropDownList.datasource = dr
myDropDownList.DataTextField = "name"
myDropDownList.DataValueField = "id" 'example of assinging a value field too
myDropDownList.Databind()
finally
conn.close
end try
This is an example using a datareader for quick access and ideal for dropdownlists. You will see examples using datasets too but this just happens to be my preference from a performance point of view.
hallo,
I'm trying to populate a dropdown by using a stored procedure in an access db, but what I get is completely empty dropdown. Am I doing something wrong?
this is the code I'm using:
code-behind:
Private function BindArchive()
dim myConnection as new OleDBConnection ("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:\inetpub\wwwroot\new1\db.mdb")
dim objCmd_archive as OleDbCommand = new OleDbCommand ("Query1", myConnection)
objCmd_archive.CommandType = CommandType.StoredProcedure
myConnection.Open()
Return objCmd_archive.ExecuteReader()
myConnection.Close()
End Function
dropdown control:
<form runat="server">
<asp:DropDownList id="cbo_archive" DataSource="<%# BindArchive() %>" DataTextField="mes_date" DataTextValue="mes_date" runat="server" />
</form>
thanks for suggestions
I highly recommend against using this function for getting the data. The reason is that you are exiting the function before closing the database, which you should never do and which means that the database won't be closed. You need to assign the DataReader to the DDL's DataSource in your CodeBehind. For example:
Page_Load(...)
...
myConnection.Open()
cbo_archive.DataSource = objCmd_archive.ExecuteReader();
cbo_archive.DataBind();
myConnection.Close.
End
Furthermore, it is best practice to place you database activity within aTry/Catch/Finally block, where you close the database connection in the Finally section.
{
{"string1"},
{"string2"},
{"string3"},
.....
{"string100"},
{"string101"},
}
I have 200 of these string lists that I want to populate an access data
base. I am building a website using ASP.net.
Without having to copy and paste each string individually, is there
anything I could do that would be simpler and faster?
Thanks,
RABMissouriDo each of these strings belong in the same field (ie: one row per string) or
the same row (one field per row).
The first is safer for what I'm about to describe, because then you don't
have to worry about the data matching up, but either is fine.
You can write something like:
int i = 0;
foreach(string strValue in array)
{
this.AddValue(strValue);
//dSet[0][i] = strValue;
//i++;
}
//this.UpdateData(dSet);
Hope that helps,
Jason Lind
"RAB" wrote:
> I want to populate my access database with strings which are coded as
> follows:
>
> {
> {"string1"},
> {"string2"},
> {"string3"},
> .....
> {"string100"},
> {"string101"},
> }
> I have 200 of these string lists that I want to populate an access data
> base. I am building a website using ASP.net.
> Without having to copy and paste each string individually, is there
> anything I could do that would be simpler and faster?
> Thanks,
> RABMissouri
>
"RAB" wrote:
>I want to populate my access database with strings which are coded as
>follows:
>
>{
> {"string1"},
> {"string2"},
> {"string3"},
> .....
> {"string100"},
> {"string101"},
>}
>I have 200 of these string lists that I want to populate an access data
>base. I am building a website using ASP.net.
>Without having to copy and paste each string individually, is there
>anything I could do that would be simpler and faster?
>Thanks,
>RABMissouri
you can always create a for cicle to do that
for x=0 to 200
insert "string" & x
next
--
Sent via .NET Newsgroups
http://www.dotnetnewsgroups.com
Is this code using VB?
Would you sample code be part of the SQL statement?
Thanks,
RABMissouri
MamaKike wrote:
> "RAB" wrote:
> >I want to populate my access database with strings which are coded as
> >follows:
> >{
> > {"string1"},
> > {"string2"},
> > {"string3"},
> > .....
> > {"string100"},
> > {"string101"},
> >}
> >I have 200 of these string lists that I want to populate an access data
> >base. I am building a website using ASP.net.
> >Without having to copy and paste each string individually, is there
> >anything I could do that would be simpler and faster?
> >Thanks,
> >RABMissouri
> you can always create a for cicle to do that
> for x=0 to 200
> insert "string" & x
> next
>
> --
> Sent via .NET Newsgroups
> http://www.dotnetnewsgroups.com
I'm going to try to put an example
Imagine that you have a database table named xpto with only a field
named exp. And you want to write in exp your strings
string1...string200
dim dtaConnection as New SqlConnection("integrated security=SSPI;data
source=(local);persist security info=False;initial catalog=xpto")
dim strSql as string
Dim comand As New SqlCommand(strSQL, dtaConnection)
comand.CommandType = CommandType.Text
dtaConnection.Open()
for i as integer=0 to 200
sql="Insert into exp values (" & i &")"
comand.ExecuteNonQuery()
next
dtaConnection.Close()
to use oledb change SQL to oledb
--
Sent via .NET Newsgroups
http://www.dotnetnewsgroups.com
