You can use an insert statement - C# Discussion Boards

24-Jun-09 2:13

Hi All,

I have the follwoing data on html page :

"NEW","939192","0005","0108500301000000001"
"NEW","939192","0005","0208500301000000003"

How can i read the above comma separated data on a page and Populate my Table in Sql 2005.

Thank you in Advance.

ScottM124-Jun-09 2:21

ScottM1

24-Jun-09 2:21

Have you tried DTS?

kibromg24-Jun-09 2:35

You can use an insert statement

24-Jun-09 2:35

Thank you so much.Is there not a way of wrting a code to do that?

Ennis Ray Lynch, Jr.24-Jun-09 3:08

Ennis Ray Lynch, Jr.

24-Jun-09 3:08

That is usually how I insert into SQL. The CSV data can be split using the string.split method and if you parametrize the queries you will avoid SQL injection but still be susceptible to spammers so you will need to HTML encode any input.

Re: You can use an insert statement

kibromg24-Jun-09 4:00

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