Недопустимое имя столбца в кнопке обновления.
Я проверяю, что предполагаемые недействительные имена столбцов верны в моей корректности. Но каждый раз, когда я запускаю и нажимаю кнопку обновления, он показывает erros, говорящий
Invalid column name in 11.
Не
Что я уже пробовал:
rivate Sub btnUpdate_Click(sender As Object, e As EventArgs) Handles btnUpdate.Click Try conn = New SqlConnection(strcon) conn.Open() Dim str As String = "Update PatientInfo set Surname =@Surname,Amount =@Amt, [11]=@11, [12]=@12, [13]=@13, [14]=@14, [15]=@15, [16]=@16, [17]=@17, [18]= @18, [21]= @21, [22]= @22, [23]= @23, [24]= @24, [25]= @25, [26]= @26, [27]= @27, [28]= @28, [31]= @31, [32]= @32, [33]= @33, [34]= @34, [35]= @35, [36]= @36, [37]= @37, [38]= @38, [41]= @41, [42]= @42, [43]= @43, [44]= @44, [45]= @45, [46]= @46, [47]= @47, [48]= @48, [51]= @51, [52]= @52, [53]= @53, [54]= @54, [55]= @55, [61]= @61, [62]= @62, [63]= @63, [64]= @64, [65]= @65, [71]= @71, [72]= @72, [73]= @73, [74]= @74, [75]= @75, [81]= @81, [82]= @82, [83]= @83, [84]= @84, [85]= @85, Button1=@Btn1, Button2=@Btn2, Button3=@Btn3, Button4=@Btn4, Button5=@Btn5, Button7=@Btn6, Button6=@Btn7, Button8=@Btn8, Button9=@Btn9, Button10=@Btn10, Button11=@Btn11, Button12=@Btn12, Button13=@Btn13, Button15=@Btn15, Button14=@Btn14, Button16=@Btn16, Button17=@Btn17, Button18=@Btn18, Button19=@Btn19, Button20=@Btn20, Button21=@Btn21, Button22=@Btn22, Button23=@Btn23, Button25=@Btn25, Button24=@Btn24, Button26=@Btn26, Button27=@Btn27, Button28=@Btn28, Button29=@Btn29, Button30=@Btn30, Button31=@Btn31, Button32=@Btn32, Button33=@Btn33, Button35=@Btn35, Button34=@Btn34, Button36=@Btn36, Button37=@Btn37, Button38=@Btn38, Button39=@Btn39, Button40=@Btn40, Button41=@Btn41, Button42=@Btn42, Button43=@Btn43, Button44=@Btn44, Button46=@Btn46, Button45=@Btn45, Button47=@Btn47, Button48=@Btn48, Button49=@Btn49, Button50=@Btn50, Button51=@Btn51, Button52=@Btn52, Button53=@Btn53, Button54=@Btn54, Button55=@Btn55, Button56=@Btn56, Button57=@Btn57, Button58=@Btn58, Button59=@Btn59, Button60=@Btn60, Button61=@Btn61, Button62=@Btn62, Button63=@Btn63, Button64=@Btn64, Button65=@Btn65, Button66=@Btn66, Button67=@Btn67, Button68=@Btn68, Button69=@Btn69, Button70=@Btn70, Button71=@Btn71, Button72=@Btn72, Button73=@Btn73, Button74=@Btn74, Button75=@Btn75, Button76=@Btn76, Button77=@Btn77, Button78=@Btn78, Button79=@Btn79, Button80=@Btn80, Button81=@Btn81, Button82=@Btn82, Button83=@Btn83, Button84=@Btn84, Button85=@Btn85, Button86=@Btn86, Button87=@Btn87, Button88=@Btn88, Button89=@Btn89, Button90=@Btn90, Button91=@Btn91, Button92=@Btn92, Button93=@Btn93, Button94=@Btn94, Button95=@Btn95, Button96=@Btn96, Button97=@Btn97, Button98=@Btn98, Button99=@Btn99, Button100=@Btn100, Button101=@Btn101, Button102=@Btn102, Button103=@Btn103, Button104=@Btn104, Button105=@Btn105, Button106=@Btn106, Button107=@Btn107, Button108=@Btn108, Button109=@Btn109, Button110=@Btn110, Button111=@Btn111, Button112=@Btn112, Button113=@Btn113, Button114=@Btn114, Button115=@Btn115, Button116=@Btn116, Button117=@Btn117, Button118=@Btn118, Button119=@Btn119, Button120=@Btn120, Button121=@Btn121, Button122=@Btn122, Button123=@Btn123, Button124=@Btn124, Button125=@Btn125, Button126=@Btn126, Button127=@Btn127, Button128=@Btn128, Button129=@Btn129, Button130=@Btn130, Button131=@Btn131, Button132=@Btn132, Button133=@Btn133, Button134=@Btn134, Button135=@Btn135, Button136=@Btn136, Button137=@Btn137, Button138=@Btn138, Button139=@Btn139, Button140=@Btn140, Button141=@Btn141, Button142=@Btn142, Button143=@Btn143, Button144=@Btn144, Button145=@Btn145, Button146=@Btn146, Button147=@Btn147, Button148=@Btn148, Button149=@Btn149, Button150=@Btn150, Button151=@Btn151, Button152=@Btn152, Button153=@Btn153, Button154=@Btn154, Button155=@Btn155, Button156=@Btn156, Button157=@Btn157, Button158=@Btn158, Button159=@Btn159, Button160=@Btn160, Button161=@Btn161, Button162=@Btn162, Button163=@Btn163, Button164=@Btn164, Button165=@Btn165, Button166=@Btn166, Button167=@Btn167, Button168=@Btn168, Button169=@Btn169, Button170=@Btn170, Button171=@Btn171, Button172=@Btn172, Button173=@Btn173, Button174=@Btn174, Button175=@Btn175, Button176=@Btn176, Button177=@Btn177, Button178=@Btn178, Button179=@Btn179, Button180=@Btn180, Button181=@Btn181, Button182=@Btn182, Button183=@Btn183, Button184=@Btn184, Button185=@Btn185, Button186=@Btn186, Button187=@Btn187, Button188=@Btn188, Button189=@Btn189, Button190=@Btn190, Button191=@Btn191, Button192=@Btn192, Button193=@Btn193, Button194=@Btn194, Button195=@Btn195, Button196=@Btn196, Button197=@Btn197, Button198=@Btn198, Button199=@Btn199, Button200=@Btn200, Button201=@Btn201, Button202=@Btn202, Button203=@Btn203, Button204=@Btn204, Button205=@Btn205, Button206=@Btn206, Button207=@Btn207, Button208=@Btn208, Button209=@Btn209, Button210=@Btn210, Button211=@Btn211, Button212=@Btn212, Button213=@Btn213, Button214=@Btn214, Button215=@Btn215, Button216=@Btn216, Button217=@Btn217, Button218=@Btn218, Button219=@Btn219, Button220=@Btn220, Button221=@Btn221, Button222=@Btn222, Button223=@Btn223, Button224=@Btn224, Button225=@Btn225, Button226=@Btn226, Button227=@Btn227, Button228=@Btn228, Button229=@Btn229, Button230=@Btn230, Button231=@Btn231, Button232=@Btn232, Button233=@Btn233, Button234=@Btn234, Button235=@Btn235, Button236=@Btn236, Button237=@Btn237, Button238=@Btn238, Button239=@Btn239, Button240=@Btn240, Button241=@Btn241, Button242=@Btn242, Button243=@Btn243, Button244=@Btn244, Button245=@Btn245, Button246=@Btn246, Button247=@Btn247, Button248=@Btn248, Button249=@Btn249, Button250=@Btn250, Button251=@Btn251, Button252=@Btn252, Button253=@Btn253, Button254=@Btn254, Button255=@Btn255, Button256=@Btn256, Button257=@Btn257, Button258=@Btn258, Button259=@Btn259, Button260=@Btn260 Where [Patient ID]=@PID" cmd = New SqlCommand(str, conn) cmd.Parameters.AddWithValue("@PID", txtPID.Text) cmd.Parameters.AddWithValue("@Surname", txtSurname.Text) cmd.Parameters.AddWithValue("@Amt", txtAmt.Text) cmd.Parameters.AddWithValue("@11", txt11.Text) cmd.Parameters.AddWithValue("@12", txt12.Text) cmd.Parameters.AddWithValue("@13", txt13.Text) cmd.Parameters.AddWithValue("@14", txt14.Text) cmd.Parameters.AddWithValue("@15", txt15.Text) cmd.Parameters.AddWithValue("@16", txt16.Text) cmd.Parameters.AddWithValue("@17", txt17.Text) cmd.Parameters.AddWithValue("@18", txt18.Text) cmd.Parameters.AddWithValue("@21", txt21.Text) cmd.Parameters.AddWithValue("@22", txt22.Text) cmd.Parameters.AddWithValue("@23", txt23.Text) cmd.Parameters.AddWithValue("@24", txt24.Text) cmd.Parameters.AddWithValue("@25", txt25.Text) cmd.Parameters.AddWithValue("@26", txt26.Text) cmd.Parameters.AddWithValue("@27", txt27.Text) cmd.Parameters.AddWithValue("@28", txt28.Text) cmd.Parameters.AddWithValue("@31", txt31.Text) cmd.Parameters.AddWithValue("@32", txt32.Text) cmd.Parameters.AddWithValue("@33", txt33.Text) cmd.Parameters.AddWithValue("@34", txt34.Text) cmd.Parameters.AddWithValue("@35", txt35.Text) cmd.Parameters.AddWithValue("@36", txt36.Text) cmd.Parameters.AddWithValue("@37", txt37.Text) cmd.Parameters.AddWithValue("@38", txt38.Text) cmd.Parameters.AddWithValue("@41", txt41.Text) cmd.Parameters.AddWithValue("@42", txt42.Text) cmd.Parameters.AddWithValue("@43", txt43.Text) cmd.Parameters.AddWithValue("@44", txt44.Text) cmd.Parameters.AddWithValue("@45", txt45.Text) cmd.Parameters.AddWithValue("@46", txt46.Text) cmd.Parameters.AddWithValue("@47", txt47.Text) cmd.Parameters.AddWithValue("@48", txt48.Text) cmd.Parameters.AddWithValue("@51", txt51.Text) cmd.Parameters.AddWithValue("@52", txt52.Text) cmd.Parameters.AddWithValue("@53", txt53.Text) cmd.Parameters.AddWithValue("@54", txt54.Text) cmd.Parameters.AddWithValue("@55", txt55.Text) cmd.Parameters.AddWithValue("@61", txt61.Text) cmd.Parameters.AddWithValue("@62", txt62.Text) cmd.Parameters.AddWithValue("@63", txt63.Text) cmd.Parameters.AddWithValue("@64", txt64.Text) cmd.Parameters.AddWithValue("@65", txt65.Text) cmd.Parameters.AddWithValue("@71", txt71.Text) cmd.Parameters.AddWithValue("@72", txt72.Text) cmd.Parameters.AddWithValue("@73", txt73.Text) cmd.Parameters.AddWithValue("@74", txt74.Text) cmd.Parameters.AddWithValue("@75", txt75.Text) cmd.Parameters.AddWithValue("@81", txt81.Text) cmd.Parameters.AddWithValue("@82", txt82.Text) cmd.Parameters.AddWithValue("@83", txt83.Text) cmd.Parameters.AddWithValue("@84", txt84.Text) cmd.Parameters.AddWithValue("@85", txt85.Text) cmd.Parameters.AddWithValue("@Btn1", Button1.Text) cmd.Parameters.AddWithValue("@Btn2", Button2.Text) cmd.Parameters.AddWithValue("@Btn3", Button3.Text) cmd.Parameters.AddWithValue("@Btn4", Button4.Text) cmd.Parameters.AddWithValue("@Btn5", Button5.Text) cmd.Parameters.AddWithValue("@Btn6", Button6.Text) cmd.Parameters.AddWithValue("@Btn7", Button7.Text) cmd.Parameters.AddWithValue("@Btn8", Button8.Text) cmd.Parameters.AddWithValue("@Btn9", Button9.Text) cmd.Parameters.AddWithValue("@Btn10", Button10.Text) cmd.Parameters.AddWithValue("@Btn11", Button11.Text) cmd.Parameters.AddWithValue("@Btn12", Button12.Text) cmd.Parameters.AddWithValue("@Btn13", Button13.Text) cmd.Parameters.AddWithValue("@Btn14", Button14.Text) cmd.Parameters.AddWithValue("@Btn15", Button15.Text) cmd.Parameters.AddWithValue("@Btn16", Button16.Text) cmd.Parameters.AddWithValue("@Btn17", Button17.Text) cmd.Parameters.AddWithValue("@Btn18", Button18.Text) cmd.Parameters.AddWithValue("@Btn19", Button19.Text) cmd.Parameters.AddWithValue("@Btn20", Button20.Text) cmd.Parameters.AddWithValue("@Btn21", Button21.Text) cmd.Parameters.AddWithValue("@Btn22", Button22.Text) cmd.Parameters.AddWithValue("@Btn23", Button23.Text) cmd.Parameters.AddWithValue("@Btn24", Button24.Text) cmd.Parameters.AddWithValue("@Btn25", Button25.Text) cmd.Parameters.AddWithValue("@Btn26", Button26.Text) cmd.Parameters.AddWithValue("@Btn27", Button27.Text) cmd.Parameters.AddWithValue("@Btn28", Button28.Text) cmd.Parameters.AddWithValue("@Btn29", Button29.Text) cmd.Parameters.AddWithValue("@Btn30", Button30.Text) cmd.Parameters.AddWithValue("@Btn31", Button31.Text) cmd.Parameters.AddWithValue("@Btn32", Button32.Text) cmd.Parameters.AddWithValue("@Btn33", Button33.Text) cmd.Parameters.AddWithValue("@Btn34", Button34.Text) cmd.Parameters.AddWithValue("@Btn35", Button35.Text) cmd.Parameters.AddWithValue("@Btn36", Button36.Text) cmd.Parameters.AddWithValue("@Btn37", Button37.Text) cmd.Parameters.AddWithValue("@Btn38", Button38.Text) cmd.Parameters.AddWithValue("@Btn39", Button39.Text) cmd.Parameters.AddWithValue("@Btn40", Button40.Text) cmd.Parameters.AddWithValue("@Btn41", Button41.Text) cmd.Parameters.AddWithValue("@Btn42", Button43.Text) cmd.Parameters.AddWithValue("@Btn43", Button43.Text) cmd.Parameters.AddWithValue("@Btn44", Button44.Text) cmd.Parameters.AddWithValue("@Btn45", Button45.Text) cmd.Parameters.AddWithValue("@Btn46", Button46.Text) cmd.Parameters.AddWithValue("@Btn47", Button47.Text) cmd.Parameters.AddWithValue("@Btn48", Button48.Text) cmd.Parameters.AddWithValue("@Btn49", Button49.Text) cmd.Parameters.AddWithValue("@Btn50", Button50.Text) cmd.Parameters.AddWithValue("@Btn51", Button51.Text) cmd.Parameters.AddWithValue("@Btn52", Button52.Text) cmd.Parameters.AddWithValue("@Btn53", Button53.Text) cmd.Parameters.AddWithValue("@Btn54", Button54.Text) cmd.Parameters.AddWithValue("@Btn55", Button55.Text) cmd.Parameters.AddWithValue("@Btn56", Button56.Text) cmd.Parameters.AddWithValue("@Btn57", Button57.Text) cmd.Parameters.AddWithValue("@Btn58", Button58.Text) cmd.Parameters.AddWithValue("@Btn59", Button59.Text) cmd.Parameters.AddWithValue("@Btn60", Button60.Text) cmd.Parameters.AddWithValue("@Btn61", Button61.Text) cmd.Parameters.AddWithValue("@Btn62", Button62.Text) cmd.Parameters.AddWithValue("@Btn63", Button63.Text) cmd.Parameters.AddWithValue("@Btn64", Button64.Text) cmd.Parameters.AddWithValue("@Btn65", Button65.Text) cmd.Parameters.AddWithValue("@Btn66", Button66.Text) cmd.Parameters.AddWithValue("@Btn67", Button67.Text) cmd.Parameters.AddWithValue("@Btn68", Button68.Text) cmd.Parameters.AddWithValue("@Btn69", Button69.Text) cmd.Parameters.AddWithValue("@Btn70", Button70.Text) cmd.Parameters.AddWithValue("@Btn71", Button71.Text) cmd.Parameters.AddWithValue("@Btn72", Button72.Text) cmd.Parameters.AddWithValue("@Btn73", Button73.Text) cmd.Parameters.AddWithValue("@Btn74", Button74.Text) cmd.Parameters.AddWithValue("@Btn75", Button75.Text) cmd.Parameters.AddWithValue("@Btn76", Button76.Text) cmd.Parameters.AddWithValue("@Btn77", Button77.Text) cmd.Parameters.AddWithValue("@Btn78", Button78.Text) cmd.Parameters.AddWithValue("@Btn79", Button79.Text) cmd.Parameters.AddWithValue("@Btn80", Button80.Text) cmd.Parameters.AddWithValue("@Btn81", Button81.Text) cmd.Parameters.AddWithValue("@Btn82", Button82.Text) cmd.Parameters.AddWithValue("@Btn83", Button83.Text) cmd.Parameters.AddWithValue("@Btn84", Button84.Text) cmd.Parameters.AddWithValue("@Btn85", Button85.Text) cmd.Parameters.AddWithValue("@Btn86", Button86.Text) cmd.Parameters.AddWithValue("@Btn87", Button87.Text) cmd.Parameters.AddWithValue("@Btn88", Button88.Text) cmd.Parameters.AddWithValue("@Btn89", Button89.Text) cmd.Parameters.AddWithValue("@Btn90", Button90.Text) cmd.Parameters.AddWithValue("@Btn91", Button91.Text) cmd.Parameters.AddWithValue("@Btn92", Button92.Text) cmd.Parameters.AddWithValue("@Btn93", Button93.Text) cmd.Parameters.AddWithValue("@Btn94", Button94.Text) cmd.Parameters.AddWithValue("@Btn95", Button95.Text) cmd.Parameters.AddWithValue("@Btn96", Button96.Text) cmd.Parameters.AddWithValue("@Btn97", Button97.Text) cmd.Parameters.AddWithValue("@Btn98", Button98.Text) cmd.Parameters.AddWithValue("@Btn99", Button99.Text) cmd.Parameters.AddWithValue("@Btn100", Button100.Text) cmd.Parameters.AddWithValue("@Btn101", Button101.Text) cmd.Parameters.AddWithValue("@Btn102", Button102.Text) cmd.Parameters.AddWithValue("@Btn103", Button103.Text) cmd.Parameters.AddWithValue("@Btn104", Button104.Text) cmd.Parameters.AddWithValue("@Btn105", Button105.Text) cmd.Parameters.AddWithValue("@Btn106", Button106.Text) cmd.Parameters.AddWithValue("@Btn107", Button107.Text) cmd.Parameters.AddWithValue("@Btn108", Button108.Text) cmd.Parameters.AddWithValue("@Btn109", Button109.Text) cmd.Parameters.AddWithValue("@Btn110", Button110.Text) cmd.Parameters.AddWithValue("@Btn111", Button111.Text) cmd.Parameters.AddWithValue("@Btn112", Button112.Text) cmd.Parameters.AddWithValue("@Btn113", Button113.Text) cmd.Parameters.AddWithValue("@Btn114", Button114.Text) cmd.Parameters.AddWithValue("@Btn115", Button115.Text) cmd.Parameters.AddWithValue("@Btn116", Button116.Text) cmd.Parameters.AddWithValue("@Btn117", Button117.Text) cmd.Parameters.AddWithValue("@Btn118", Button118.Text) cmd.Parameters.AddWithValue("@Btn119", Button119.Text) cmd.Parameters.AddWithValue("@Btn120", Button120.Text) cmd.Parameters.AddWithValue("@Btn121", Button121.Text) cmd.Parameters.AddWithValue("@Btn122", Button122.Text) cmd.Parameters.AddWithValue("@Btn123", Button123.Text) cmd.Parameters.AddWithValue("@Btn124", Button124.Text) cmd.Parameters.AddWithValue("@Btn125", Button125.Text) cmd.Parameters.AddWithValue("@Btn126", Button126.Text) cmd.Parameters.AddWithValue("@Btn127", Button127.Text) cmd.Parameters.AddWithValue("@Btn128", Button128.Text) cmd.Parameters.AddWithValue("@Btn129", Button129.Text) cmd.Parameters.AddWithValue("@Btn130", Button130.Text) cmd.Parameters.AddWithValue("@Btn131", Button131.Text) cmd.Parameters.AddWithValue("@Btn132", Button132.Text) cmd.Parameters.AddWithValue("@Btn133", Button133.Text) cmd.Parameters.AddWithValue("@Btn134", Button134.Text) cmd.Parameters.AddWithValue("@Btn135", Button135.Text) cmd.Parameters.AddWithValue("@Btn136", Button136.Text) cmd.Parameters.AddWithValue("@Btn137", Button137.Text) cmd.Parameters.AddWithValue("@Btn138", Button138.Text) cmd.Parameters.AddWithValue("@Btn139", Button139.Text) cmd.Parameters.AddWithValue("@Btn140", Button140.Text) cmd.Parameters.AddWithValue("@Btn141", Button141.Text) cmd.Parameters.AddWithValue("@Btn142", Button143.Text) cmd.Parameters.AddWithValue("@Btn143", Button143.Text) cmd.Parameters.AddWithValue("@Btn144", Button144.Text) cmd.Parameters.AddWithValue("@Btn145", Button145.Text) cmd.Parameters.AddWithValue("@Btn146", Button146.Text) cmd.Parameters.AddWithValue("@Btn147", Button147.Text) cmd.Parameters.AddWithValue("@Btn148", Button148.Text) cmd.Parameters.AddWithValue("@Btn149", Button149.Text) cmd.Parameters.AddWithValue("@Btn150", Button150.Text) cmd.Parameters.AddWithValue("@Btn151", Button151.Text) cmd.Parameters.AddWithValue("@Btn152", Button152.Text) cmd.Parameters.AddWithValue("@Btn153", Button153.Text) cmd.Parameters.AddWithValue("@Btn154", Button154.Text) cmd.Parameters.AddWithValue("@Btn155", Button155.Text) cmd.Parameters.AddWithValue("@Btn156", Button156.Text) cmd.Parameters.AddWithValue("@Btn157", Button157.Text) cmd.Parameters.AddWithValue("@Btn158", Button158.Text) cmd.Parameters.AddWithValue("@Btn159", Button159.Text) cmd.Parameters.AddWithValue("@Btn160", Button160.Text) cmd.Parameters.AddWithValue("@Btn161", Button161.Text) cmd.Parameters.AddWithValue("@Btn162", Button162.Text) cmd.Parameters.AddWithValue("@Btn163", Button163.Text) cmd.Parameters.AddWithValue("@Btn164", Button164.Text) cmd.Parameters.AddWithValue("@Btn165", Button165.Text) cmd.Parameters.AddWithValue("@Btn166", Button166.Text) cmd.Parameters.AddWithValue("@Btn167", Button167.Text) cmd.Parameters.AddWithValue("@Btn168", Button168.Text) cmd.Parameters.AddWithValue("@Btn169", Button169.Text) cmd.Parameters.AddWithValue("@Btn170", Button170.Text) cmd.Parameters.AddWithValue("@Btn171", Button171.Text) cmd.Parameters.AddWithValue("@Btn172", Button172.Text) cmd.Parameters.AddWithValue("@Btn173", Button173.Text) cmd.Parameters.AddWithValue("@Btn174", Button174.Text) cmd.Parameters.AddWithValue("@Btn175", Button175.Text) cmd.Parameters.AddWithValue("@Btn176", Button176.Text) cmd.Parameters.AddWithValue("@Btn177", Button177.Text) cmd.Parameters.AddWithValue("@Btn178", Button178.Text) cmd.Parameters.AddWithValue("@Btn179", Button179.Text) cmd.Parameters.AddWithValue("@Btn180", Button180.Text) cmd.Parameters.AddWithValue("@Btn181", Button181.Text) cmd.Parameters.AddWithValue("@Btn182", Button182.Text) cmd.Parameters.AddWithValue("@Btn183", Button183.Text) cmd.Parameters.AddWithValue("@Btn184", Button184.Text) cmd.Parameters.AddWithValue("@Btn185", Button185.Text) cmd.Parameters.AddWithValue("@Btn186", Button186.Text) cmd.Parameters.AddWithValue("@Btn187", Button187.Text) cmd.Parameters.AddWithValue("@Btn188", Button188.Text) cmd.Parameters.AddWithValue("@Btn189", Button189.Text) cmd.Parameters.AddWithValue("@Btn190", Button190.Text) cmd.Parameters.AddWithValue("@Btn191", Button191.Text) cmd.Parameters.AddWithValue("@Btn192", Button192.Text) cmd.Parameters.AddWithValue("@Btn193", Button193.Text) cmd.Parameters.AddWithValue("@Btn194", Button194.Text) cmd.Parameters.AddWithValue("@Btn195", Button195.Text) cmd.Parameters.AddWithValue("@Btn196", Button196.Text) cmd.Parameters.AddWithValue("@Btn197", Button197.Text) cmd.Parameters.AddWithValue("@Btn198", Button198.Text) cmd.Parameters.AddWithValue("@Btn199", Button199.Text) cmd.Parameters.AddWithValue("@Btn200", Button200.Text) cmd.Parameters.AddWithValue("@Btn201", Button201.Text) cmd.Parameters.AddWithValue("@Btn202", Button202.Text) cmd.Parameters.AddWithValue("@Btn203", Button203.Text) cmd.Parameters.AddWithValue("@Btn204", Button204.Text) cmd.Parameters.AddWithValue("@Btn205", Button205.Text) cmd.Parameters.AddWithValue("@Btn206", Button206.Text) cmd.Parameters.AddWithValue("@Btn207", Button207.Text) cmd.Parameters.AddWithValue("@Btn208", Button208.Text) cmd.Parameters.AddWithValue("@Btn209", Button209.Text) cmd.Parameters.AddWithValue("@Btn210", Button210.Text) cmd.Parameters.AddWithValue("@Btn211", Button211.Text) cmd.Parameters.AddWithValue("@Btn212", Button212.Text) cmd.Parameters.AddWithValue("@Btn213", Button213.Text) cmd.Parameters.AddWithValue("@Btn214", Button214.Text) cmd.Parameters.AddWithValue("@Btn215", Button215.Text) cmd.Parameters.AddWithValue("@Btn216", Button216.Text) cmd.Parameters.AddWithValue("@Btn217", Button217.Text) cmd.Parameters.AddWithValue("@Btn218", Button218.Text) cmd.Parameters.AddWithValue("@Btn219", Button219.Text) cmd.Parameters.AddWithValue("@Btn220", Button220.Text) cmd.Parameters.AddWithValue("@Btn221", Button221.Text) cmd.Parameters.AddWithValue("@Btn222", Button222.Text) cmd.Parameters.AddWithValue("@Btn223", Button223.Text) cmd.Parameters.AddWithValue("@Btn224", Button224.Text) cmd.Parameters.AddWithValue("@Btn225", Button225.Text) cmd.Parameters.AddWithValue("@Btn226", Button226.Text) cmd.Parameters.AddWithValue("@Btn227", Button227.Text) cmd.Parameters.AddWithValue("@Btn228", Button228.Text) cmd.Parameters.AddWithValue("@Btn229", Button229.Text) cmd.Parameters.AddWithValue("@Btn230", Button230.Text) cmd.Parameters.AddWithValue("@Btn231", Button231.Text) cmd.Parameters.AddWithValue("@Btn232", Button232.Text) cmd.Parameters.AddWithValue("@Btn233", Button233.Text) cmd.Parameters.AddWithValue("@Btn234", Button234.Text) cmd.Parameters.AddWithValue("@Btn235", Button235.Text) cmd.Parameters.AddWithValue("@Btn236", Button236.Text) cmd.Parameters.AddWithValue("@Btn237", Button237.Text) cmd.Parameters.AddWithValue("@Btn238", Button238.Text) cmd.Parameters.AddWithValue("@Btn239", Button239.Text) cmd.Parameters.AddWithValue("@Btn240", Button240.Text) cmd.Parameters.AddWithValue("@Btn241", Button241.Text) cmd.Parameters.AddWithValue("@Btn242", Button243.Text) cmd.Parameters.AddWithValue("@Btn243", Button243.Text) cmd.Parameters.AddWithValue("@Btn244", Button244.Text) cmd.Parameters.AddWithValue("@Btn245", Button245.Text) cmd.Parameters.AddWithValue("@Btn246", Button246.Text) cmd.Parameters.AddWithValue("@Btn247", Button247.Text) cmd.Parameters.AddWithValue("@Btn248", Button248.Text) cmd.Parameters.AddWithValue("@Btn249", Button249.Text) cmd.Parameters.AddWithValue("@Btn250", Button250.Text) cmd.Parameters.AddWithValue("@Btn251", Button251.Text) cmd.Parameters.AddWithValue("@Btn252", Button252.Text) cmd.Parameters.AddWithValue("@Btn253", Button253.Text) cmd.Parameters.AddWithValue("@Btn254", Button254.Text) cmd.Parameters.AddWithValue("@Btn255", Button255.Text) cmd.Parameters.AddWithValue("@Btn256", Button256.Text) cmd.Parameters.AddWithValue("@Btn257", Button257.Text) cmd.Parameters.AddWithValue("@Btn258", Button258.Text) cmd.Parameters.AddWithValue("@Btn259", Button259.Text) cmd.Parameters.AddWithValue("@Btn260", Button260.Text) cmd.ExecuteNonQuery() MessageBox.Show("Data has been updated!") loadData() cmd.Dispose() conn.Close() Catch ex As Exception MessageBox.Show(ex.Message) End Try End Sub
PIEBALDconsult
Названия параметров могут не начинаться с цифры, может быть?
Member 12905345
Я уже превращаюсь в персонажа, но это дает мне ту же проблему