I want to get the data from this page and insert it to my mssql database. How can I read this data with asp.net c#? SehisID is a value from 1 to 81.
EDIT: My code is below.
for (int i = 1; i <= 81; i++)
{
HttpWebRequest rqst = (HttpWebRequest)WebRequest.Create("http://www.milliyet.com.tr/Secim2009/api/belediyelist.ashx?sehirid=" + i);
rqst.Method = "POST";
rqst.ContentType = "text/xml";
rqst.ContentLength = 0;
rqst.Timeout = 3000;
HttpWebResponse rspns = (HttpWebResponse)rqst.GetResponse();
form1.InnerHtml += rspns.ToString() + "<br>";
}
WebClient
is an easy way to get a string from a web page:
WebClient client = new WebClient();
String downloadedString = client.DownloadString("http://www.milliyet.com.tr/Secim2009/api/belediyelist.ashx?sehirid=81");
And next code works well too:
for (int i = 1; i <= 81; i++)
{
var rqst = (HttpWebRequest)WebRequest.Create("http://www.milliyet.com.tr/Secim2009/api/belediyelist.ashx?sehirid=" + i);
rqst.Method = "POST";
rqst.ContentType = "text/xml";
rqst.ContentLength = 0;
rqst.Timeout = 3000;
var rspns = (HttpWebResponse)rqst.GetResponse();
var reader = new StreamReader(rspns.GetResponseStream());
form1.InnerHtml += reader.ReadToEnd() + "<br>";
}
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With