Bring data back from google inserting into SQL Server

Hello All,

I am a newbie to c# .net, Is it possible to scan google and bring back data and insert into SQL.

For example if I have three text boxes, they go out a do a search, can i bring back the first phone number.

Firstname

LastName

PhoneNumber

If anyone has a good post, please let me know.

String searchRequest = textBox1.Text;

String searchRequest2 = textBox2.Text;

String searchRequest3 = textBox3.Text;

//searchRequest = searchRequest.SubString(searchRequest.IndexOf("for ") + 4, searchRequest.Length - 1);

searchRequest.Substring(searchRequest.IndexOf("for ") + 4, searchRequest.Length - 1 - (searchRequest.IndexOf("for ") + 4));

searchRequest2.Substring(searchRequest2.IndexOf("for ") + 4, searchRequest2.Length - 1 - (searchRequest2.IndexOf("for ") + 4));

searchRequest3.Substring(searchRequest3.IndexOf("for ") + 4, searchRequest3.Length - 1 - (searchRequest3.IndexOf("for ") + 4));

System.Diagnostics.Process.Start(@"C:\Program Files\Internet Explorer\iexplore.exe", "http://www.google.com.au/search?q=" + searchRequest + " " + searchRequest2 + " " + searchRequest3);

this.AcceptButton = button1;

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke10y ago
I didn't understand what do you mean by "can i bring back the first phone number?".
Furthermore, your query string doesn't look good to me. Query strings wouldn't have space in it, replace it with +.
If you are referring to reading the response received from the search, you will need to do the following:
Create one Windows Forms Application.
Put a WebBrowser control on the form.
Pass the complete url to the WebBrowsers .Navigate method.
Write a code in WebBrowser's event (I think something like DownloadCompleted) and access WebBrowsers .Document property this will have the complete HTML response text.
You will need to parse this entire text as per your requirement.
Hope it helps.