Re: Update Table - C# Discussion Boards

Re: You can use an insert statement

24-Jun-09 4:00

The problem is its not a csv file .The data is posted on a browser.
How could i read data on a browser?

Many thanks,

Ennis Ray Lynch, Jr.24-Jun-09 4:03

Ennis Ray Lynch, Jr.

24-Jun-09 4:03

It is fairly difficult concept described in the "Beginning ASP.NET 3.5: In C# and VB" book published by Wrox in Chapters:5, 9, 11, and 12.

Re: You can use an insert statement

kibromg24-Jun-09 6:35

24-Jun-09 6:35

Thank you so much.Can you please give me a little more info on how to do that?

Your help is much appreciated.

Many thanks

PIEBALDconsult24-Jun-09 7:09

PIEBALDconsult

24-Jun-09 7:09

Dunno, depends on how the information is presented on the page. One such page I scrape for data has the data I want in a table. The code I use to get the page is:

System.Net.HttpWebRequest req = (System.Net.HttpWebRequest) System.Net.HttpWebRequest.Create ( theurl ) ;
                
req.CachePolicy = new System.Net.Cache.RequestCachePolicy ( System.Net.Cache.RequestCacheLevel.NoCacheNoStore ) ;
 
using ( System.Net.HttpWebResponse rsp = (System.Net.HttpWebResponse) req.GetResponse() )
{
    string res = ( new System.IO.StreamReader ( rsp.GetResponseStream() ) ).ReadToEnd() ;
 
    // Then I use a Regular Expression to extract what I want
    // and insert it to the database.
}

I make no claims that this technique is "good", only that it does what I want for a rather unimportant Windows Service.

kibromg24-Jun-09 11:21

24-Jun-09 11:21

Thank you very much for your response.Its much appreciated.Each of the data are in a qutation and are separated by comma.

Can you please give me a little tip on how to use the regular exression to trancate the value and assign it to the data field?

Many thanks,

Regards

PIEBALDconsult24-Jun-09 13:45

PIEBALDconsult

24-Jun-09 13:45

Not without seeing the page.

As mentioned, the data I scrape is in a table, so the page contains:

<td width="473" class="playlist">4:08 pm - The Beatles - Can't Buy Me Love<br>4:10 pm - The Doors - Break On Through<br>4:13 pm - Meat Loaf - Paradise By the Dashboard Light<br>4:21 pm - Klaatu - Mister Manson<br>4:25 pm - Bob Seger & The Silver Bullet Band - Long Twin Silver Line<br>4:29 pm - Eagles - Those Shoes<br></td>

and I use a Regular Expression to match <td width="473" class="playlist"> the data I want <br></td>;
Then I split further on <br> and hyphen.

You will need to find such a pattern in the page you're reading.

kibromg24-Jun-09 23:19

Re: I Want Get Thread Object

24-Jun-09 23:19

Thanks so much for your help.

Here is the problem :

I am trying to read data from a certain URl .Every time you run the Url with Different param it gives a result like the following. For instance runinng http://data.com/data.aspx?datefrom=20090601&dateto=20090621
will give a result of a comman separated data like the following.

"john","wood","20090203"
"terry",'brown",20090209"
etc..

How will i read that and get it in to Sql Table?All i have to run is the above URL to generate the value.

Please advice.

Thank you in advance

I Want Get Thread Object

Dong Cher, Ryu24-Jun-09 1:42

Dong Cher, Ryu

24-Jun-09 1:42

is possible?

The Thread object getting with Thread ID

System.Threading.Thread th = thread.id <------------- ?

There will be what kind of method and peels?

stancrm24-Jun-09 1:56

stancrm

24-Jun-09 1:56

.NET Diagnostics - II, A Threads Monitoring Application Using C#[^]

Adding dates

kanchoette24-Jun-09 1:05

kanchoette

24-Jun-09 1:05

How can I add 12 years minus 1 day to a date please?

So, for example, if the original date is 09/06/2009 (June 9th, 2009) the calculated date will give me 08/06/2021.

SeMartens24-Jun-09 1:07

SeMartens

24-Jun-09 1:07

Did you take a look at MSDN? The DateTime class contains methods for this:

http://msdn.microsoft.com/en-us/library/system.datetime.addyears(VS.80).aspx[^]

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

kanchoette24-Jun-09 1:10

kanchoette

24-Jun-09 1:10

I have just realised this after I posted my question Roll eyes | :rolleyes:

Many thanks for pointing this out.

Pete O'Hanlon24-Jun-09 1:09

Pete O'Hanlon

24-Jun-09 1:09

Something like this perhaps:

DateTime newDate = DateTime.Now.AddYears(12).AddDays(-1);

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

How to get or set the innerText of an HTMLElement at runtime using c#

DaveyM6924-Jun-09 1:09

DaveyM69

24-Jun-09 1:09

public DateTime TwelveYearsMinusOne(DateTime start)
{
    return start.AddYears(12).AddDays(-1);
}

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)

svt gdwl24-Jun-09 0:57

svt gdwl

24-Jun-09 0:57

Using c# BHO, I want to replace the innertext of an HTML Element on browser (IE6).
IHTMLElement HtmlElemen; // where HTMLElemen.innerHTML = <TD>Hello World!</TD>

obj = (object)HtmlElemen;
obj.GetType().GetProperty("innerText").GetValue();
obj.GetType().GetProperty("innerText").SetValue();

if normally HTMLElemen.innerText gives "Hello World!",
then how can I get the same thing i.e., "Hello World!" from the obj.GetType().GetProperty("innerText").GetValue();

Find the not-existing element in int arrays.

CodingLover24-Jun-09 0:52

CodingLover

24-Jun-09 0:52

Hi all,

I've two int arrays, something like this.

{41, 3, 5, 37, 59, 4}
{3, 59, 4, 5, 37}

As you can see 41 is not in the second array. I want to find that actually in a C# code. Basically I want to find the value which is exists only in one array.

Any comments?

Thanks a lot. Smile | :)

I appreciate your help all the time...
CodingLover Smile | :)

Calla24-Jun-09 1:00

Calla

24-Jun-09 1:00

There might be a simpler way, but try just to iterate through the two arrays with a nested for loop and se if the items in the first array exist in the second.

CodingLover24-Jun-09 3:28

CodingLover

24-Jun-09 3:28

Actually I've look at that, have no clue about that's the best way I can take.

I appreciate your help all the time...
CodingLover Smile | :)

Dust Signs24-Jun-09 1:01

Dust Signs

24-Jun-09 1:01

Enumerable.Except (since .NET 3.5)

Dust Signs

The number you dialed is imaginary. Please turn your phone by 90 degrees and try again

himanshu256124-Jun-09 1:12

himanshu2561

24-Jun-09 1:12

himanshu

CodingLover28-Jun-09 20:44

CodingLover

28-Jun-09 20:44

Thanks a lot.

Actually now my application have a slight change. Now all my elements are in a list. So I've two lists now. So how can I do this.

Thanks Smile | :)

I appreciate your help all the time...
CodingLover Smile | :)

Dust Signs29-Jun-09 4:53

Dust Signs

29-Jun-09 4:53

Which list are you using exactly? A generic List<t>? As it also implements IEnumerable you should be able to use the extension methods on them equally.

Dust Signs

The number you dialed is imaginary. Please turn your phone by 90 degrees and try again