import html string into sql database

Hi guys,

Here is the html string that I want to transfer it to another variable so, I can post it to my sql server database

<span style=\""font: 12px arial; color : #000000; text-decoration : none;\""><br>MODEL- USB01000C01CL VENDOR- ACTIONTEC ELECTRONICS<br> <br>FEATURES- VoSKY Chatterbox for Skype<br> Plug-and-Play Speakerphone for Skype!<br> VoSKY Chatterbox from Actiontec is the go-anywhere speakerphone <br> solution for Skype! No software or special drivers required. Simply <br> plug your VoSKY Chatterbox into any computer and you are ready to <br> start talking! <br> Make Skype Calls on a Speakerphone Plug Chatterbox into your <br> computer, and make or receive a Skype call as you normally would. <br> Then talk to your Skype contacts, hands-free and without wearing <br> headsets! <br> You do not need to download any additional drivers or software. Just<br> take Chatterbox, plug it into any computer, and you are ready to <br> go! <br> Chatterbox offers superb sound quality with the latest technology in<br> full duplex audio, DSP-enhanced sound quality, and echo <br> cancellation. <br>* Verified by and certified for Skype <br>* Replaces your headset/microphone <br>* Small, lightweight device goes anywhere you go <br>* Full duplex speakerphone with adjustable volume and mute control <br>* DSP-enhanced sound quality <br> <br> -- SPECIFICATIONs -----------<br>CONNECTORs - (1) USB 2.0/1.1 port<br> (1) 2.5mm Headset Jack<br>INDICATORS - LEDs for Ready, Microphone Mute<br>FUNCTION KEYS- Volume Up, Volume Down, Microphone Mute <br>SPEAKER - 1w peak, 40 mm, 4 ohm, 120 Hz to 6 KHz, 120 dB <br>MICROPHONE - Voice pick-up range up to 4 meters <br>APPROVALS - FCC, CE<br>REQUIREMENTS - PC running Windows 2000/XP with one available USB port. <br>DIMENSIONS - 7.7cm x 5.8cm x 2.1cm WT. 50 grams<br> <br><br>MANUFACTURER WARRANTY: 1 YEAR</span>

however If I just do;

dim myvariable as string = htmlvalueatabove

after importing the myvariable value to the sqlserver my asp.net detailview control only able to show only first 17 letters . Up until "fo"

I am sorry if I am not able to provide you clear question. I am so frastrated at the moment, after 6 coffie and 2 minutes bathroom break I can't write anymore. I will shutup and wait for one you and respond.

thanks

Cemal

SQL Server treats an single quote ' as a delimiter character so to properly store it in the database you have to use double quotes ''

|||

Thank you very much for trying to answer my question, Even though you might be correct on your answer for another user problem, in my case this was another story. I simply forget and defined the sql variable as 255 character lenght. All I had do was; go back to my sql stored procudure and change the limited character varibale to text.

afterwards everything worked out fine.

again thank you.

Import Data Status

Dear all,
I need to copy data from one DB to another DB using the Import Data
function. When I started the transfer, it ran for a certain period then
stopped at around 50% of progress for few hours. The status shown in the
dialog is 608, another case is showing 703. What is the meaning of the
statuses? How can I get reference information about the statuses?
Thanks for any help!
Tedmond
Tedmond
I have no idea about these statuses . Consider using T-SQL to copy the data
between the databases
INSERT INTO db1.dbo.Table1 (col1,col2....) SELECT col1,col2.... FROM
db2.dbo.Table2
"Tedmond" <Tedmond@.discussions.microsoft.com> wrote in message
news:234701C5-E121-4499-B291-3432C8917DA6@.microsoft.com...
> Dear all,
> I need to copy data from one DB to another DB using the Import Data
> function. When I started the transfer, it ran for a certain period then
> stopped at around 50% of progress for few hours. The status shown in the
> dialog is 608, another case is showing 703. What is the meaning of the
> statuses? How can I get reference information about the statuses?
> Thanks for any help!
> Tedmond
>

Import Data Status

Dear all,
I need to copy data from one DB to another DB using the Import Data
function. When I started the transfer, it ran for a certain period then
stopped at around 50% of progress for few hours. The status shown in the
dialog is 608, another case is showing 703. What is the meaning of the
statuses? How can I get reference information about the statuses?
Thanks for any help!
TedmondTedmond
I have no idea about these statuses . Consider using T-SQL to copy the data
between the databases
INSERT INTO db1.dbo.Table1 (col1,col2....) SELECT col1,col2.... FROM
db2.dbo.Table2
"Tedmond" <Tedmond@.discussions.microsoft.com> wrote in message
news:234701C5-E121-4499-B291-3432C8917DA6@.microsoft.com...
> Dear all,
> I need to copy data from one DB to another DB using the Import Data
> function. When I started the transfer, it ran for a certain period then
> stopped at around 50% of progress for few hours. The status shown in the
> dialog is 608, another case is showing 703. What is the meaning of the
> statuses? How can I get reference information about the statuses?
> Thanks for any help!
> Tedmond
>

Import Data Status

Dear all,
I need to copy data from one DB to another DB using the Import Data
function. When I started the transfer, it ran for a certain period then
stopped at around 50% of progress for few hours. The status shown in the
dialog is 608, another case is showing 703. What is the meaning of the
statuses? How can I get reference information about the statuses?
Thanks for any help!
TedmondTedmond
I have no idea about these statuses . Consider using T-SQL to copy the data
between the databases
INSERT INTO db1.dbo.Table1 (col1,col2....) SELECT col1,col2.... FROM
db2.dbo.Table2
"Tedmond" <Tedmond@.discussions.microsoft.com> wrote in message
news:234701C5-E121-4499-B291-3432C8917DA6@.microsoft.com...
> Dear all,
> I need to copy data from one DB to another DB using the Import Data
> function. When I started the transfer, it ran for a certain period then
> stopped at around 50% of progress for few hours. The status shown in the
> dialog is 608, another case is showing 703. What is the meaning of the
> statuses? How can I get reference information about the statuses?
> Thanks for any help!
> Tedmond
>

Import Data from SPSS (Statistical Package for the Social Sciences

hi to everyone. I'm developing a web application using C#.NET and MS SQL
Server 2000 database backend. But the user wants to transfer a huge data
from his SPSS application because it will take large amount of time to input
each of the item. My question is: Is there a way to import data from SPSS
application to the database using MS SQL Server 2000.
Specifications:
Import Data From a data file (SPSS Standard Version 11.0.0)
Hope you'll reply as soon as possible. You idea will greatly help me.
Thank you and God Bless.Hi
If this information is in a reasonably formatted file you can use BULK
INSERT command, DTS or the BCP utility to import the information. This can
be scheduled as a job and you can archive the file once loaded.
There is plenty of information on BULK INSERT, DTS and BCP in Books Online,
also check out http://www.sqldts.com/ for more DTS articles such as
http://www.sqldts.com/default.aspx?231
and http://www.sqldts.com/default.aspx?246
You will need some method of loading the data file onto your server or
somewhere accessable from the server. It may be necessary to hold the data
in a staging table(s) if it requires additional work before loading into
your destination table(s).
John
"rolly-hubport" <rollyhubport@.discussions.microsoft.com> wrote in message
news:231A4F51-B185-44D8-AE52-730275EC3C21@.microsoft.com...
> hi to everyone. I'm developing a web application using C#.NET and MS SQL
> Server 2000 database backend. But the user wants to transfer a huge data
> from his SPSS application because it will take large amount of time to
> input
> each of the item. My question is: Is there a way to import data from SPSS
> application to the database using MS SQL Server 2000.
> Specifications:
> Import Data From a data file (SPSS Standard Version 11.0.0)
>
> Hope you'll reply as soon as possible. You idea will greatly help me.
> Thank you and God Bless.
>
>|||Hi,
If u will use BCP or Bulk insert u have to manually define the table
name.
use dts package tranfer data from one server to another and u have
option to select the tables.
hope this helps u
from
doller

Import CSV File with FTP as Source

I want to use a FTP Task to obtain a file on a remote server, then
transfer into a table.
I'm sure it can be done, but there aren't many tutorials explaining
how it works only thin acknowledgments.Hi
"JGiotta" wrote:
> I want to use a FTP Task to obtain a file on a remote server, then
> transfer into a table.
> I'm sure it can be done, but there aren't many tutorials explaining
> how it works only thin acknowledgments.
>
You can use DTS for SQL 2000 or SSIS for ASQL 2005 expecially if there are
multiple files. For DTS check out http://www.sqldts.com/302.aspx and
http://www.sqldts.com/246.aspx
You will need to do this in two stages, get the FTP files and then import
them.
John

import a dts package

Hi i was wodering how can i transfer a developed dts package from sqlserver
to an installed MSDE2000.
Hi Yaniv,
Easiest is probably to save it to a file, and run the file using dtsrun
(which does come with the MSDE).
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"yaniv" <yaniv@.discussions.microsoft.com> wrote in message
news:43B7014E-41A4-4534-8249-D2B32E6225C1@.microsoft.com...
> Hi i was wodering how can i transfer a developed dts package from
> sqlserver
> to an installed MSDE2000.
>
|||nevermind found a way.
a simple VBScript that imports the file.dts :
Const DTSSQLStgFlag_UseTrustedConnection = 256
dim ServerName,dtsFilePath,userPassword
Dim dtsp, dtsPkg
ServerName = "server"
dtsFilePath = "d:\path\File.dts"
userPassword = ""
Set dtsPkg = CreateObject("DTS.Package")
dtsp = dtsPkg.LoadFromStorageFile(dtsFilePath,userPasswor d)
dtsPkg.SaveToSQLServer ServerName, "","" ,DTSSQLStgFlag_UseTrustedConnection
|||Hi Greg,
I have installed latest MSDE 2000 Rel A.
I do not see and file named dtsrun.
What am I missing?
Thanks
"Greg Low [MVP]" wrote:

> Hi Yaniv,
> Easiest is probably to save it to a file, and run the file using dtsrun
> (which does come with the MSDE).
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "yaniv" <yaniv@.discussions.microsoft.com> wrote in message
> news:43B7014E-41A4-4534-8249-D2B32E6225C1@.microsoft.com...
>
>
|||Nevermind. My mistake. Thanks
"Subhojit Banerjee" wrote:
[vbcol=seagreen]
> Hi Greg,
> I have installed latest MSDE 2000 Rel A.
> I do not see and file named dtsrun.
> What am I missing?
> Thanks
>
> "Greg Low [MVP]" wrote: