Put this in a file called Helpers.cshtml in App_Code:
@functions {
public static string GetHtmlPage(string url){
WebRequest request = HttpWebRequest.Create(url);
WebResponse response = request.GetResponse();
using (StreamReader sr = new StreamReader(response.GetResponseStream())){
return sr.ReadToEnd();
}
}
}
Then in your page, you can do this:
var db = Database.Open("MyDb)";
var sql = "INSERT INTO table (myField) VALUES (@0);
var page = Helpers.GetHtmlPage("http://www.google.com");
db.Execute(sql, page);
Mikesdotnett...
All-Star
154852 Points
19855 Posts
Moderator
MVP
Re: Question related to webpage capture and Database???
Jun 24, 2011 04:49 AM|LINK
Put this in a file called Helpers.cshtml in App_Code:
@functions { public static string GetHtmlPage(string url){ WebRequest request = HttpWebRequest.Create(url); WebResponse response = request.GetResponse(); using (StreamReader sr = new StreamReader(response.GetResponseStream())){ return sr.ReadToEnd(); } } }Then in your page, you can do this:
var db = Database.Open("MyDb)"; var sql = "INSERT INTO table (myField) VALUES (@0); var page = Helpers.GetHtmlPage("http://www.google.com"); db.Execute(sql, page);Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter