Saturday, February 7, 2009
Friday, February 6, 2009
Reading and Displaying Source of Web Pages
In asp.net 1.1
we have two ways
1.Dim arrbyte() as byte = System.Net.WebClient.DownloadData(URL)
2. Dim strHtml = System.Text.Encoding.Default.GetString(arrbyte)
Second Way is to create Webrequest and get webresponse
public void MySource(Uri weburi)
{
System.Text.StringBuilder sbuild=new StringBuilder();
string temp="";
System.Net.HttpWebRequest webrequest = (HttpWebRequest)System.Net.WebRequest.Create(weburi);
System.Net.HttpWebResponse webresponse=(HttpWebResponse) webrequest.GetResponse();
StreamReader webstream = new StreamReader(webresponse.GetResponseStream(),Encoding.ASCII );
while((temp=webstream.ReadLine())!= null)
{
sbuild.Append(temp + "\r\n");
}
webstream.Close();
Response.Write("OK");
Response.Write (sbuild.ToString() );
In asp.net 2.0
Dim strPageHTML as string= System.Net.WebClient.Dowloadstring(URL)
we have two ways
1.Dim arrbyte() as byte = System.Net.WebClient.DownloadData(URL)
2. Dim strHtml = System.Text.Encoding.Default.GetString(arrbyte)
Second Way is to create Webrequest and get webresponse
public void MySource(Uri weburi)
{
System.Text.StringBuilder sbuild=new StringBuilder();
string temp="";
System.Net.HttpWebRequest webrequest = (HttpWebRequest)System.Net.WebRequest.Create(weburi);
System.Net.HttpWebResponse webresponse=(HttpWebResponse) webrequest.GetResponse();
StreamReader webstream = new StreamReader(webresponse.GetResponseStream(),Encoding.ASCII );
while((temp=webstream.ReadLine())!= null)
{
sbuild.Append(temp + "\r\n");
}
webstream.Close();
Response.Write("OK");
Response.Write (sbuild.ToString() );
In asp.net 2.0
Dim strPageHTML as string= System.Net.WebClient.Dowloadstring(URL)
Thursday, February 5, 2009
Wednesday, February 4, 2009
How to get multiple records in one column?
Suppose You need to get multiple records in a single variable or column
Decalre @var Nvarchar(1000)
SELECT @var = IFNULL(@var,'') + var1 + var2
FROM table
In this way you can get multiple records in a single variable......
Happy Coding :P
Decalre @var Nvarchar(1000)
SELECT @var = IFNULL(@var,'') + var1 + var2
FROM table
In this way you can get multiple records in a single variable......
Happy Coding :P
Subscribe to:
Comments (Atom)