Re: Update Table - C# Discussion Boards

kibromg24-Jun-09 2:13

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.

Re: Update Table

ScottM124-Jun-09 2:21

ScottM1

24-Jun-09 2:21

Have you tried DTS?

Re: Update Table

kibromg24-Jun-09 2:35

kibromg

24-Jun-09 2:35

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

You can use an insert statement

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.

Need custom software developed? I do C# development and consulting all over the United States.

A man said to the universe:
"Sir I exist!"
"However," replied the universe,
"The fact has not created in me
A sense of obligation."
--Stephen Crane

Re: You can use an insert statement

kibromg24-Jun-09 4:00

kibromg

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,

Re: You can use an insert statement

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

kibromg

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

Re: Update Table

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.

Re: Update Table

kibromg24-Jun-09 11:21

kibromg

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

Re: Update Table

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.

Re: Update Table

kibromg24-Jun-09 23:19

kibromg

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?

Re: I Want Get Thread Object

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.

Re: Adding dates

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.

Re: Adding dates

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.

Re: Adding dates

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

Re: Adding dates

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)

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

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 | :)

Re: Find the not-existing element in int arrays.

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.

Re: Find the not-existing element in int arrays.

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 | :)

Re: Find the not-existing element in int arrays.

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

Re: Find the not-existing element in int arrays.

himanshu256124-Jun-09 1:12

himanshu2561

24-Jun-09 1:12

himanshu

Re: Find the not-existing element in int arrays.

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 | :)

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.