How to save data to mysql database using vb.net -

-

hey me find error @ code :) i'm new vb.net friends

try         /*'con.open()*/         query = "insert mcs.custormer values(custormer_id,first_name,last_name,nic_no,c_address1,c_address2,c_address3,c_telephoneno,membership_date,business_name,g_name,g_nicno,g_address1,g_address2,g_address3,g_telephoneno)" & _             "values (@custormer_id,@first_name,@last_name,@nic_no,@c_address1,@c_address2,@c_address3,@c_telephoneno,@membership_date,@business_name,@g_name,@g_nicno,@g_address1,@g_address2,@g_address3,@g_telephoneno)"         using cmd = new mysqlcommand(query, con)              cmd.parameters.addwithvalue("@custormer_id", convert.toint32(txtcustormerid.text))             cmd.parameters.addwithvalue("@first_name", convert.tostring(txtfirstname.text))             cmd.parameters.addwithvalue("@last_name", convert.tostring(txtlastname.text))             cmd.parameters.addwithvalue("@nic_no", convert.tostring(txtnicno.text))             cmd.parameters.addwithvalue("@c_address1", convert.tostring(txtcaddress1.text))             cmd.parameters.addwithvalue("@c_address2", convert.tostring(txtcaddress2.text))             cmd.parameters.addwithvalue("@c_address3", convert.tostring(txtcaddress3.text))             cmd.parameters.addwithvalue("@c_telephoneno", convert.tostring(txtctelephoneno.text))             cmd.parameters.addwithvalue("@membership_date", convert.todatetime(dtpmembrshipdate.text))             cmd.parameters.addwithvalue("@business_name", convert.tostring(txtbusinessname.text))             cmd.parameters.addwithvalue("@g_name", convert.tostring(txtgname.text))             cmd.parameters.addwithvalue("@g_nicno", convert.tostring(txtgnicno.text))             cmd.parameters.addwithvalue("@g_address1", convert.tostring(txtgaddress1.text))             cmd.parameters.addwithvalue("@g_address2", convert.tostring(txtgaddress2.text))             cmd.parameters.addwithvalue("@g_address3", convert.tostring(txtgaddress3.text))             cmd.parameters.addwithvalue("@g_telephoneno", convert.tostring(txtgtelephoneno.text))             cmd.executenonquery()             messagebox.show("new custormer added sucsessfully !")             txtcustormerid.clear()             txtfirstname.clear()             txtlastname.clear()             txtnicno.clear()             txtcaddress1.clear()             txtcaddress2.clear()             txtcaddress3.clear()             txtctelephoneno.clear()             txtbusinessname.clear()             txtgname.clear()             txtgaddress1.clear()             txtgaddress2.clear()             txtgaddress3.clear()             txtgtelephoneno.clear()             txtgnicno.clear()         end using     catch ex exception         msgbox(ex.message)             'da.dispose()         'ds.clear()         ' dr.close()         cmd.dispose()         con.close()     end try

when click save button error,

enter image description here

i try more , more, can't go forward. please me guys :)

try with

 query = "insert mcs.custormer (custormer_id,first_name,last_name,nic_no,c_address1,c_address2,c_address3,c_telephoneno,membership_date,business_name,g_name,g_nicno,g_address1,g_address2,g_address3,g_telephoneno)" & _             "values (@custormer_id,@first_name,@last_name,@nic_no,@c_address1,@c_address2,@c_address3,@c_telephoneno,@membership_date,@business_name,@g_name,@g_nicno,@g_address1,@g_address2,@g_address3,@g_telephoneno)"

also please refer mysql insert syntax.hope helps.


Comments

Post a Comment

Popular posts from this blog

sql - VB.NET Operand type clash: date is incompatible with int error -

-
i trying display records table named staffpresentee database using clause... i using visual studio 2010... the table design follows- .......fieldname..................datatype........allownull 1......staff_id (fk).............numeric(18,0)......yes 2.......date........................date.............no 3......present.....................char(1)..........yes note type of 2nd field date , not datetime... i want display records table have today's date int 'date' field... current query is- cmd = new sqlclient.sqlcommand("select * staffpresentee date=" & date.now.date, cn) dr = cmd.executereader for dr = cmd.executereader error "operand type clash: date incompatible int" i tried select * staffpresentee query without clause runs correctly. try putting date value in sigle quotes maybe. cmd = new sqlclient.sqlcommand("select * staffpresentee date='" & _
Read more

SVG stroke-linecap doesn't work for circles in Firefox? -

-
i've got problem svg stroke-linecap attribute. i've got circular progress bar in angularjs , set outer circle (blue one) have rounded "ends". @ fiddle . <svg ... height="130" width="130"> <!-- ngif: background --> <circle ... ng-if="background" fill="#fff" class="ng-scope" stroke-width="13" stroke="#cc3399" r="57.5" cy="65" cx="65" stroke-linecap="round" /> <!-- end ngif: background --> <circle ... fill="none" stroke-dashoffset="36.12831551628261" stroke-dasharray="361.28315516282623" stroke-width="13" stroke="#432db3" stroke-linecap="round" r="57.5" cy="65" cx="65" transform="rotate(-89.9, 65, 65)" /> </svg> how can that?
Read more

python - TypeError: Scalar value for argument 'color' is not numeric in openCV -

-
here code im = cv2.imread('luffy.jpg') gray = cv2.cvtcolor(im,cv2.color_bgr2gray) ret,thresh = cv2.threshold(gray,127,255,0) contours,h = cv2.findcontours(thresh,cv2.retr_tree,cv2.chain_approx_simple) cnt in contours: moment = cv2.moments(cnt) c_y = moment['m10']/(moment['m00']+0.01) c_x = moment['m01']/(moment['m00']+0.01) centroid_color = im[c_x,c_y] centroid_color = np.array((centroid_color[0],centroid_color[1],centroid_color[2])) print type(centroid_color) cv2.fillpoly(im,cnt,centroid_color) i getting error on last line try , pass centroid_color color argument. <type 'numpy.ndarray'> , have been able pass data type cv2.fillpoly color in other instances, not sure why having problem here. fillpoly() expects iterable, i.e. put cnt in brackets. believe duplicate of https://stackoverflow.com/a/17582850/5818240 . moreover, centroid color variable contains strings. need convert them i
Read more