Input string was not in a correct format.

[Rasko]

when i try to insert kind of text to my richtextbox from web (copy/paste) i can do it but after i wanted to update i can't do it . there is an errormessage appears (Input string was not in a correct format.).




Dim urun As String = Replace(TBox4.T ext, "'", """")

d.CommandText = String.Format(" update etic_urunler set etic_urun ='" & urun & "' where id=1")



TBox4.Text is a richtextbox and i am trying to update this text in to it as below ..

*************** *************** *************** *************** *************** **********







<SPAN style="FONT-SIZE: 16pt; FONT-FAMILY: Verdana"><STRON G>.:: <SPAN style="BACKGROU ND-COLOR: #ccccff"><SPAN style="COLOR: #ff3366">ÜRÜN</SPAN> <SPAN style="COLOR: #ff3399">AÇIKLA MA</SPAN></SPAN> ::.</STRONG></SPAN>
<STYLE type=text/css>

.ctl00_ContentP laceHolder1_TBo x4_OuterTable {
width: 750px;
background-color: #9EBEF5;
}
#ctl00_ContentP laceHolder1_TBo x4_toolbarArea select {
margin: 0px;
padding: 0px;
font: 11px Tahoma,Verdana, sans-serif;
}
.ctl00_ContentP laceHolder1_TBo x4_HtmlBox {
overflow: auto;
font-family: Courier New, Courier;
padding: 4px;
border-right: 1px solid #808080;
border-left: 1px solid #808080;
border-top: 1px solid #808080;
border-bottom: 1px solid #808080;
}
.ctl00_ContentP laceHolder1_TBo x4_DesignBox {
background-color: #FFFFFF;
border: 0;
border-right: 1px solid #808080;
border-left: 1px solid #808080;
border-top: 1px solid #808080;
border-bottom: 1px solid #808080;
}
.ctl00_ContentP laceHolder1_TBo x4_DesignBox body {
background-color: black;
}
.ctl00_ContentP laceHolder1_TBo x4_Toolbar {
margin-bottom: 1px;
margin-right: 2px;
float: left;

}


.ctl00_ContentP laceHolder1_TBo x4_Button_Off_O ut {
padding: 1px;
background-color: transparent;
}
.ctl00_ContentP laceHolder1_TBo x4_Button_Off_O ver {

padding: 0px;
border-top: 1px solid #000080;
border-left: 1px solid #000080;
border-right: 1px solid #000080;
border-bottom: 1px solid #000080;
background-color: #FFF4CC;

filter: progid:DXImageT ransform.Micros oft.Gradient(Gr adientType=0, StartColorStr=" #FFFFF4CC", EndColorStr="#F FFFD091");
}
.ctl00_ContentP laceHolder1_TBo x4_Button_On_Ou t {

padding: 0px;
border-top: 1px solid #000080;
border-left: 1px solid #000080;
border-right: 1px solid #000080;
border-bottom: 1px solid #000080;
background-color: #FFD58C;

filter: progid:DXImageT ransform.Micros oft.Gradient(Gr adientType=0, StartColorStr=" #FFFFD58C", EndColorStr="#F FFFAD55");
}
.ctl00_ContentP laceHolder1_TBo x4_Button_On_Ov er {

padding: 0px;
border-top: 1px solid #000080;
border-left: 1px solid #000080;
border-right: 1px solid #000080;
border-bottom: 1px solid #000080;
background-color: #FE914E;

filter: progid:DXImageT ransform.Micros oft.Gradient(Gr adientType=0, StartColorStr=" #FFFE914E", EndColorStr="#F FFFD38E");
}


.ctl00_ContentP laceHolder1_TBo x4_StartTabOn {
font: 10pt MS Sans Serif;
padding: 1px;
border-left: 1px solid #81A9E2;
border-right: 1px solid #FFFFFF;
border-top: 1px solid #808080;
border-bottom: 1px solid #81A9E2;
background-color: #81A9E2;
}
.ctl00_ContentP laceHolder1_TBo x4_StartTabOff {
font: 10pt MS Sans Serif;
padding:1px;
border-left: 1px solid #81A9E2;
border-right: 1px solid #808080;
border-top: 1px solid #808080;
border-bottom: 1px solid #81A9E2;
background-color: #81A9E2;
}
.ctl00_ContentP laceHolder1_TBo x4_TabOn {
font: 8pt MS Sans Serif;
padding:1px;
padding-left:5px;
padding-right:5px;
border-left: 1px solid #FFFFFF;
border-right: 1px solid #808080;
border-top: 1px solid #9EBEF5;
border-bottom: 1px solid #808080;
background-color: #9EBEF5;
}
.ctl00_ContentP laceHolder1_TBo x4_TabOffRight {
font: 8pt MS Sans Serif;
padding:1px;
padding-left:5px;
padding-right:5px;
border-left: 1px solid #808080;
border-right: 1px solid #808080;
border-top: 1px solid #808080;
border-bottom: 1px solid #81A9E2;
background-color: #81A9E2;
}
.ctl00_ContentP laceHolder1_TBo x4_TabOffLeft {
font: 8pt MS Sans Serif;
padding:1px;
padding-left:5px;
padding-right:5px;
border-left: 1px solid #808080;
border-right: 1px solid #FFFFFF;
border-top: 1px solid #808080;
border-bottom: 1px solid #9EBEF5;
background-color: #81A9E2;
}
.ctl00_ContentP laceHolder1_TBo x4_EndTab {
font: 10pt MS Sans Serif;
width: 100%;
padding:1px;
border-left: 1px solid #81A9E2;
border-right: 1px solid #81A9E2;
border-top: 1px solid #808080;
border-bottom: 1px solid #81A9E2;
background-color: #81A9E2;
}
.ctl00_ContentP laceHolder1_TBo x4_AncestorArea {
display:none;
margin-left: 4px;
}
.ctl00_ContentP laceHolder1_TBo x4_AncestorArea a {
padding: 1px;
margin-left: 2px;
margin-right: 2px;
border: 1px solid #808080;
color: #000;
font-family: arial;
font-size: 11px;
}
.ctl00_ContentP laceHolder1_TBo x4_AncestorArea a:link, .ctl00_ContentP laceHolder1_TBo x4_AncestorArea a:visited, .ctl00_ContentP laceHolder1_TBo x4_AncestorArea a:active {
background-color: transparent;
text-decoration: none;
}
.ctl00_ContentP laceHolder1_TBo x4_AncestorArea a:hover {
text-decoration: none;
background-color: #316AC5;
border: 1px solid #fff;
color:#fff;
}

</STYLE>




*************** *************** *************** *************** *************** **********

[dorinbogdan]

You should also replace the double-quotes (") that appear in the HTML string, with 2 double-quotes ("").