I want to get information of this web page: http://www.bidv.com.vn/BSC/op.htm by asp.net and save it into database for later process but it use frame so i can't do. Anybody know how please help me. I really need it. Thanks

I want to get information of this web page: http://www.bidv.com.vn/BSC/op.htm[^] by asp.net and save it into database for later process but it use frame so i can't do. Anybody know how please help me. I really need it. Thanks -- modified at 4:45 Monday 2nd October, 2006

hi all, i have a problem need your help. How to insert a menu created by sothink dhtml menu in a asp.net page created in Visual Studio 2005. Thanhks in advance

sorry if the question is stupid:doh: When I store the content of an article in SQL Server ,I only insert a half of it and I can type anymore.I don't know how ->post question.Anyone who know about my problem can help me?Thanks.

wonderfull!It run perfectly.Thanks Colin Angus Mackay Best wishes!

I am using VS 2005 and SQL Server 2000. I want to store a huge of text in a field of my database.I have used ntext type but it's not large enough. Can anybody help me. Thanks

Colin Angus Mackay wrote:

Sorry, but I'm still convinced my SQL is correct. Show me an example of a few rows from each table that should match and tell me for each row in table1 what rows in table2 match to it.

here is an example of some rows from each table: table1: |type |name | ---------------------------- | 1 | type1 | ---------------------------- | 2 | type2 | table2: |id |type | content | shortDesc | --------------------------------------------- |1 | 1 | content1 | desc 1 | |2 | 1 | content2 | desc 2 | |3 | 2 | content3 | desc3 | |4 | 2 | content4 | desc4 | |5 | 1 | content5 | desc5 | The expected result : |id | table1.type | name |content | shortDesc | ------------------------------------------------- | 1 | 1 | type1|content1 | desc1 | | 3 | 2 | type3|content3 |desc3 | each type returns only one row. So now can you help me.If you need,i 'll send you my database and the description more clearly. Thanks.

oh!sorry . I have a mistake When I run your SQL statement the result return is: type1 |Id1 | name1... type1 |Id2 |name1... <---(sorry not name2) But the result I expected is: type1| Id1 |name1... type2| id2 |name2... type3| Id3 |name3.... (each type return only one ID of table 2,for all type) Sorry for the mistake and can you help me.Thanks

Sorry but the statement don't return what i expected Example: type1 |Id1 | name1... type1 |Id2 |name2... because there's a one-many relationship between 2 table Thanks anyway

I have two table with one-many relationship table1 has 2 fields:type(int,PK),name table2 has 4 fields:id(PK),type(int,FK reference field type of table1),content,shortDesc How to write a SELECT statement that return rows from table1 join table2(via type field) but each row has a different value of type. Result example: -------------------------------------------------- | table1.type | name | content | ShortDesc | <--- FIELDS NAME -------------------------------------------------- | type1 | name1 | content1| shortDesc1 | <---VALUE( ROW ) -------------------------------------------------- | type2 | name2 content2| shortDesc2| Can anyone help me.Thanks in advance