Date: 11/28/08     Keywords: database, sql

I keep getting an error the error 1) in my code, I am using a xsd file to call stored procedure and
access the database. This worked fine under Windows 2000 using visual basic express 2005. I am now
on a XP Machine using VS 2005 and i can get it to work. The error occurs at this point 2) and the
code that defines that dataaccess is listed as 3). So what am i doing wrong then all suggestion
accepted.

1) Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

2) content_page = dataaccess.GetContentPages()

3)

Dim content_page As Object
Dim page As Object
Dim page_number As Integer
Dim page_content As String

' call out the pages from the database
Dim dataaccess As DataSet1TableAdapters.pagesTableAdapter = New DataSet1TableAdapters.pagesTableAdapter
content_page = dataaccess.GetContentPages()

' Loop through the record set
For Each page In content_page
' assigned the page and content values to variables
page_number = page
page_content = page

Source: https://aspdotnet.livejournal.com/101914.html

Date: 10/16/08     Keywords: asp, web

Okay, I am writing a small webapp in asp.net C# 2.0 after a few years
since I last done .net (which was vb.net by the way). I have a GridView
which is filtered by a dropdown, the gridview is listed below. I can't
remember for the life of me how to catch the checkboxes posted back from
the form? and I can't find any simple examples online. Help?

Source: http://community.livejournal.com/aspdotnet/101836.html

Date: 10/16/08     Keywords: asp, web

Okay, I am writing a small webapp in asp.net C# 2.0 after a few years
since I last done .net (which was vb.net by the way). I have a GridView
which is filtered by a dropdown, the gridview is listed below. I can't
remember for the life of me how to catch the checkboxes posted back from
the form? and I can't find any simple examples online. Help?

Source: http://aspdotnet.livejournal.com/101836.html

Date: 10/16/08     Keywords: asp, web

Okay, I am writing a small webapp in asp.net C# 2.0 after a few years
since I last done .net (which was vb.net by the way). I have a GridView
which is filtered by a dropdown, the gridview is listed below. I can't
remember for the life of me how to catch the checkboxes posted back from
the form? and I can't find any simple examples online. Help?

Source: https://aspdotnet.livejournal.com/101836.html

Date: 09/11/08     Keywords: php, sql

I have wrote small script to create container-class based on SQL query (or CSV list of vars)

http://akb.awardspace.com/build_class_based_on_sql.php

Wrote primarily for myself, but everybody is welcome to use it.

Source: http://community.livejournal.com/aspdotnet/100912.html

Date: 09/11/08     Keywords: php, sql

I have wrote small script to create container-class based on SQL query (or CSV list of vars)

http://akb.awardspace.com/build_class_based_on_sql.php

Wrote primarily for myself, but everybody is welcome to use it.

Source: http://aspdotnet.livejournal.com/100912.html

Date: 09/11/08     Keywords: php, sql

I have wrote small script to create container-class based on SQL query (or CSV list of vars)

http://akb.awardspace.com/build_class_based_on_sql.php

Wrote primarily for myself, but everybody is welcome to use it.

Source: https://aspdotnet.livejournal.com/100912.html

Date: 08/19/08     Keywords: asp, web

Hello everybody,
Is there a way here to get email message Id right after you send it with the SMPT client?
I am creating a web application on ASP.NET 2.0 and it uses mail server EXIM to send emails.

Message Id I mean that unique identifier, which is being set when you send an email.
Using telnet:

$ telnet yourmailhost.whatever.com 25
<< 220 yourmailhost.whatever.com blah blah
>> HELO yourclientname
<< 250 yourmailhost.whatever.com Hello [ip address]
>> mail from:someaddress@hotmail.com
<< 250 2.1.0 yourmailhost.whatever.com ...Sender OK
>> rcpt to:someaddress@yourmailhost.whatever.com
<< 250 2.1.5 someaddress@yourmailhost.whatever.com
>> data
<< 354 Please start mail input.
>> Subject: Test message
>>
>> This is a test...
>> Testing 1-2-3
>> .
<< 250 Mail queued for delivery. MessageId<K5SHTQ-0004Q0-0E>
>> quit

Source: http://community.livejournal.com/aspdotnet/100129.html

Date: 08/19/08     Keywords: asp, web

Hello everybody,
Is there a way here to get email message Id right after you send it with the SMPT client?
I am creating a web application on ASP.NET 2.0 and it uses mail server EXIM to send emails.

Message Id I mean that unique identifier, which is being set when you send an email.
Using telnet:

$ telnet yourmailhost.whatever.com 25
<< 220 yourmailhost.whatever.com blah blah
>> HELO yourclientname
<< 250 yourmailhost.whatever.com Hello [ip address]
>> mail from:someaddress@hotmail.com
<< 250 2.1.0 yourmailhost.whatever.com ...Sender OK
>> rcpt to:someaddress@yourmailhost.whatever.com
<< 250 2.1.5 someaddress@yourmailhost.whatever.com
>> data
<< 354 Please start mail input.
>> Subject: Test message
>>
>> This is a test...
>> Testing 1-2-3
>> .
<< 250 Mail queued for delivery. MessageId<K5SHTQ-0004Q0-0E>
>> quit

Source: http://aspdotnet.livejournal.com/100129.html

Date: 08/19/08     Keywords: asp, web

Hello everybody,
Is there a way here to get email message Id right after you send it with the SMPT client?
I am creating a web application on ASP.NET 2.0 and it uses mail server EXIM to send emails.

Message Id I mean that unique identifier, which is being set when you send an email.
Using telnet:

$ telnet yourmailhost.whatever.com 25
<< 220 yourmailhost.whatever.com blah blah
>> HELO yourclientname
<< 250 yourmailhost.whatever.com Hello [ip address]
>> mail from:someaddress@hotmail.com
<< 250 2.1.0 yourmailhost.whatever.com ...Sender OK
>> rcpt to:someaddress@yourmailhost.whatever.com
<< 250 2.1.5 someaddress@yourmailhost.whatever.com
>> data
<< 354 Please start mail input.
>> Subject: Test message
>>
>> This is a test...
>> Testing 1-2-3
>> .
<< 250 Mail queued for delivery. MessageId<K5SHTQ-0004Q0-0E>
>> quit

Source: https://aspdotnet.livejournal.com/100129.html

Date: 07/13/08     Keywords: database, asp

I'm trying to set up a database connection with ASP.NET in Dreamweaver MX 2004 (yeah, a little older...), and everything in the site has a check mark that needs to before you add a connection, and I add the database file, and even hit test and it registers fine. Then when I go to add a new record set, I select the database, but it says "***No table found". So apparently it's ok with the file path, it just can't read the database tables.

I've made sure the .net framework was all good to go, and I downloaded the MDAC 2.7 files and got those all set. Is there something I'm missing? I'm trying to work with Access and asp.net because that's what a position I'm trying to move into uses, so, I don't really have other options.

Also, I'm thinking maybe there's an issue with drivers because even when I try to hand code it with examples from http://www.w3schools.com/ASPNET/aspnet_repeater.asp, when I call it up in either IE or Firefox, it just displays the code....
any ideas?

Source: http://community.livejournal.com/aspdotnet/99757.html

Date: 07/13/08     Keywords: database, asp

I'm trying to set up a database connection with ASP.NET in Dreamweaver MX 2004 (yeah, a little older...), and everything in the site has a check mark that needs to before you add a connection, and I add the database file, and even hit test and it registers fine. Then when I go to add a new record set, I select the database, but it says "***No table found". So apparently it's ok with the file path, it just can't read the database tables.

I've made sure the .net framework was all good to go, and I downloaded the MDAC 2.7 files and got those all set. Is there something I'm missing? I'm trying to work with Access and asp.net because that's what a position I'm trying to move into uses, so, I don't really have other options.

Also, I'm thinking maybe there's an issue with drivers because even when I try to hand code it with examples from http://www.w3schools.com/ASPNET/aspnet_repeater.asp, when I call it up in either IE or Firefox, it just displays the code....
any ideas?

Source: http://aspdotnet.livejournal.com/99757.html

Date: 07/13/08     Keywords: database, asp

I'm trying to set up a database connection with ASP.NET in Dreamweaver MX 2004 (yeah, a little older...), and everything in the site has a check mark that needs to before you add a connection, and I add the database file, and even hit test and it registers fine. Then when I go to add a new record set, I select the database, but it says "***No table found". So apparently it's ok with the file path, it just can't read the database tables.

I've made sure the .net framework was all good to go, and I downloaded the MDAC 2.7 files and got those all set. Is there something I'm missing? I'm trying to work with Access and asp.net because that's what a position I'm trying to move into uses, so, I don't really have other options.

Also, I'm thinking maybe there's an issue with drivers because even when I try to hand code it with examples from http://www.w3schools.com/ASPNET/aspnet_repeater.asp, when I call it up in either IE or Firefox, it just displays the code....
any ideas?

Source: https://aspdotnet.livejournal.com/99757.html

Date: 06/13/08     Keywords: browser, web

Hello,
I do have a file on web server, let's say 123.zip
When I am redirecting user to it, browser opens Save dialog and puts that name by default: 123.zip. Is there any way to change that name to, let's say 456.zip?
File 123.zip stays on server as 123.zip, but user sees it as 456.zip.

One of the known ways is:

Byte[] data = System.IO.File.ReadAllBytes(sFullName); // 123.zip
Response.AddHeader("Content-Disposition", "attachment; filename=456.zip");
Response.OutputStream.Write(data, 0, data.Length);
Response.End();

But in this case I have to read the whole file first and then stream it out. Works fine with small files, but 123.zip could be huge. Then browser freezes and ends by timeout.

Thank you.

Source: http://community.livejournal.com/aspdotnet/98705.html

Date: 06/13/08     Keywords: browser, web

Hello,
I do have a file on web server, let's say 123.zip
When I am redirecting user to it, browser opens Save dialog and puts that name by default: 123.zip. Is there any way to change that name to, let's say 456.zip?
File 123.zip stays on server as 123.zip, but user sees it as 456.zip.

One of the known ways is:

Byte[] data = System.IO.File.ReadAllBytes(sFullName); // 123.zip
Response.AddHeader("Content-Disposition", "attachment; filename=456.zip");
Response.OutputStream.Write(data, 0, data.Length);
Response.End();

But in this case I have to read the whole file first and then stream it out. Works fine with small files, but 123.zip could be huge. Then browser freezes and ends by timeout.

Thank you.

Source: http://aspdotnet.livejournal.com/98705.html

Date: 06/13/08     Keywords: browser, web

Hello,
I do have a file on web server, let's say 123.zip
When I am redirecting user to it, browser opens Save dialog and puts that name by default: 123.zip. Is there any way to change that name to, let's say 456.zip?
File 123.zip stays on server as 123.zip, but user sees it as 456.zip.

One of the known ways is:

Byte[] data = System.IO.File.ReadAllBytes(sFullName); // 123.zip
Response.AddHeader("Content-Disposition", "attachment; filename=456.zip");
Response.OutputStream.Write(data, 0, data.Length);
Response.End();

But in this case I have to read the whole file first and then stream it out. Works fine with small files, but 123.zip could be huge. Then browser freezes and ends by timeout.

Thank you.

Source: https://aspdotnet.livejournal.com/98705.html

Date: 03/31/08     Keywords: asp, security, web

I have content that I only want authorized users to see and then content that I want joe public to be able to view.

I found this article that suggests having two web.config files. So the authorized user content would be in a separate folder with its own web.config file:
http://www.asp.net/learn/security/tutorial-07-vb.aspx

Is that how you would do it ? (There's no date on the article so I didnt know if this was the latest thinking)

Thanks :)

Source: http://community.livejournal.com/aspdotnet/97434.html

Date: 03/31/08     Keywords: asp, security, web

I have content that I only want authorized users to see and then content that I want joe public to be able to view.

I found this article that suggests having two web.config files. So the authorized user content would be in a separate folder with its own web.config file:
http://www.asp.net/learn/security/tutorial-07-vb.aspx

Is that how you would do it ? (There's no date on the article so I didnt know if this was the latest thinking)

Thanks :)

Source: http://aspdotnet.livejournal.com/97434.html

Date: 03/31/08     Keywords: asp, security, web

I have content that I only want authorized users to see and then content that I want joe public to be able to view.

I found this article that suggests having two web.config files. So the authorized user content would be in a separate folder with its own web.config file:
http://www.asp.net/learn/security/tutorial-07-vb.aspx

Is that how you would do it ? (There's no date on the article so I didnt know if this was the latest thinking)

Thanks :)

Source: https://aspdotnet.livejournal.com/97434.html

Date: 03/17/08     Keywords: database, web

I am trying to create a "fire and forget" webservice that I can kick off from a webpage.


This is the code I have in the webservice:

using System;
using System.Web;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data;


[WebService(Namespace = "http://www.tempuri.org")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]


public class TestWebService : System.Web.Services.WebService
{

public TestWebService()
{

//Uncomment the following line if using designed components
//InitializeComponent();
}



[SoapDocumentMethod(OneWay = true)]
[WebMethod]
public void MultipleDatabaseHits()
{

// ..... do a bunch of database stuff

}


}



When I launch it from a page using this code, the page doesnt complete loading untill the database work is done.



protected void Button1_Click(object sender, EventArgs e)
{

TestWebService mySvc = new TestWebService();
mySvc.MultipleDatabaseHits();

}



What am I doing wrong ?



I'm not using RPC for soap so I know that the [SoapDocumentMethod(OneWay = true)] command is the correct one to use. I've seen examples where [SoapDocumentMethod(OneWay = true)] came before or after [WebMethod] - I tried it in both places and it didnt make a difference.

Source: http://community.livejournal.com/aspdotnet/97095.html