sql server - Rich text box text with formatting does not save in SQL for VB.NET -

-

i working on vb form project in have rtb (rich text box), want save formatted text save sql math type character.it saves out formatting , miss math character? here code

        dim sname integer = integer.parse(txt1.text)         dim sfname integer = 2         dim scnic string = rtb.selectedtext          query &= "insert tencmpc1 (qnumber,topic,umcq)"           query &= "values (@qnumber, @topic,@umcq )"           using conn new sqlconnection(strconn)             using comm new sqlcommand()                 comm                     .connection = conn                     .commandtype = commandtype.text                     .commandtext = query                     .parameters.addwithvalue("@qnumber", sname)                     .parameters.addwithvalue("@topic", sfname)                     .parameters.addwithvalue("@umcq", scnic)              conn.open()                      comm.executenonquery()                      txt10.text = "question saved "                 end                end using

here below code formated rtb

if fontdlg.showdialog() <> windows.forms.dialogresult.cancel         rtb.selectionfont = fontdlg.font

image below show result while in rtb @ inserting time , in sql out when out sql out formating? enter image description here

i using nvarchar datatype of umcq table of sql.

also math character not supported. enter image description here

the issue seems saving rtb.selectedtext database rather rtb.selectedrtf. selectedtext property ever returns plain text. selectedrtf property 1 returns value containing of rich-text formatting.


Comments

Post a Comment

Popular posts from this blog

python - argument must be rect style object - Pygame -

-
disclaimer: know other people on site have had error it's been in different contexts , fixes don't seem work here. hey stackoverflow, i've been making sideways space invaders game, ship follows mouse's y position stays on left, , clicking shoots bullet. enemies spawn randomly right , fly left, , objects removed once each side of screen. works fine, when tried implement collision detection see when shot hits enemy, error: typeerror: argument must rect style object. it points line "return hitbox.colliderect(target.rect)". try , work out causing made 'print' lines below see 'target.rect' (and whether proper rect object), , seemed same style shot's own rect, i'm lost why colliderect doesn't accept it. i've annotated pretty everything, sorry if it's insult intelligence should make things easier. class causes problems: class gameobject: def __init__(self, image, height, speed): self.speed = speed self.image...
Read more

c++ - Qt setGeometry: Unable to set geometry -

-
why? setgeometry: unable set geometry 22x22+320+145 on qwidgetwindow/'widgetclasswindow'. resulting geometry: 116x22+320+145 (frame: 8, 30, 8, 8, custom margin: 0, 0, 0, 0, minimum size: 22x22, maximum size: 16777215x16777215). the project is: project.pro qt += core gui greaterthan(qt_major_version, 4): qt += widgets target = untitled5 template = app sources += main.cpp\ widget.cpp headers += widget.h widget.h #ifndef widget_h #define widget_h #include <qwidget> class widget : public qwidget { q_object public: explicit widget(qwidget *parent = 0); ~widget(); private: }; #endif // widget_h widget.cpp #include "widget.h" #include <qvboxlayout> widget::widget(qwidget *parent) : qwidget(parent) { qvboxlayout *vlayout = new qvboxlayout(this); } widget::~widget() { } main.cpp #include "widget.h" #include <qapplication> int main(int argc, char *argv[]) { qapplication a...
Read more

How to do feature selection and reduction on a LIBSVM file in Spark using Python? -

-
i have couple of libsvm files have implement clustering in spark using python. file has space delimiter , first column represents type [ 1 or -1] , rest features in format [1:2.566]. there lot of columns , perform feature selection on [preferably implement chisquaretest model] , use pca or svd perform feature reduction process. but, not find decent tutorial python in spark implement these processes. i found link online had sample script implement chisqtest in python. used same logic implement model , not done. under hypothesis testing division in link, code parallelizes rdd[labeledpoint] before passing chisqtest model. tried same logic in different manner , got different errors. data = mlutils.loadlibsvmfile(sc, "path/filename.txt") label = data.map(lambda x: x.label) features = data.map(lambda x: x.features) obs = sc.parallelize(labeledpoint(label,features)) this gave me error stating typeerror: float() argument must string or number then, normalized data using...
Read more