且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

C#/SQL:输入字符串的格式不正确

更新时间:2023-11-08 10:47:52

你好

由于难以阅读,请您重新格式化您的问题.这样做时,请包括您在使用代码按钮时遇到问题的代码示例.

最后,在使用参数时,您需要首先使用断言,例如如果参数的值是Date,则使用DateTime.TryParse如果是if语句,则可以对int执行相同的操作,例如int.TryParse.构造参数时都不做 如您所显示的那样,好像无法解析DateTime,则在TryParse返回布尔值时引发异常;如果将字符串解析为DateTime,则抛出true;否则,则返回false. >

I tried all the possibilities, I wrote ' comm.Parameters.Add("@facultate", C1.Text); ' and give me the same error.. I do not understand why .. and if I try to debug and see exactly what value it has and stopped at line "
comm.Parameters.Add(new SqlParameter("@numar", SqlDbType.Int) { Value = int.Parse(T9.Text ) }); he stoped here and give me: 1. when coverting a string to datetime, parse the string to take before putting each variable into the datetime object... 2. make sure your method arguments are in the right format. " I can send the whole project with everything in.

PS. : i take date from FORM DataTimePiker..


comm.Parameters.Add(new SqlParameter("@facultate", SqlDbType.VarChar) { Value = C1.Text });
                comm.Parameters.Add(new SqlParameter("@domeniul", SqlDbType.VarChar) { Value = T1.Text });
                comm.Parameters.Add(new SqlParameter("@specializare", SqlDbType.VarChar) { Value = T2.Text });
                comm.Parameters.Add(new SqlParameter("@forma_invatamant", SqlDbType.VarChar) { Value = C2.Text });
                comm.Parameters.Add(new SqlParameter("@d_inscriere", SqlDbType.DateTime) { Value = DTP1.Value.ToString("MM/dd/yyyy") });
                comm.Parameters.Add(new SqlParameter("@nume_prenume", SqlDbType.VarChar) { Value = T3.Text });
                comm.Parameters.Add(new SqlParameter("@cod", SqlDbType.VarChar) { Value = T4.Text });
                comm.Parameters.Add(new SqlParameter("@localitate", SqlDbType.VarChar) { Value = T5.Text });
                comm.Parameters.Add(new SqlParameter("@judet", SqlDbType.VarChar) { Value = T6.Text });
                comm.Parameters.Add(new SqlParameter("@tara", SqlDbType.VarChar) { Value = T7.Text });
               comm.Parameters.Add(new SqlParameter("@strada", SqlDbType.VarChar) { Value = T8.Text });
                comm.Parameters.Add(new SqlParameter("@numar", SqlDbType.Int) { Value = int.Parse(T9.Text ) });
                comm.Parameters.Add(new SqlParameter("@bloc", SqlDbType.VarChar) { Value = T10.Text });
                comm.Parameters.Add(new SqlParameter("@scara", SqlDbType.VarChar) { Value = int.Parse(T11.Text) });
                comm.Parameters.Add(new SqlParameter("@etaj", SqlDbType.Int) { Value = int.Parse(T12.Text) });
                comm.Parameters.Add(new SqlParameter("@apartament", SqlDbType.Int) { Value = int.Parse(T3.Text) });
                comm.Parameters.Add(new SqlParameter("@sector", SqlDbType.VarChar) { Value = T14.Text });
                comm.Parameters.Add(new SqlParameter("@cod_p", SqlDbType.Int) { Value = int.Parse(T15.Text) });
                comm.Parameters.Add(new SqlParameter("@data_nasterii", SqlDbType.DateTime) { Value = DTP2.Value.ToString("MM/dd/yyyy") });
                comm.Parameters.Add(new SqlParameter("@locul_nasterii", SqlDbType.VarChar) { Value = T16.Text });
                comm.Parameters.Add(new SqlParameter("@judet_n", SqlDbType.VarChar) { Value = T17.Text });
                comm.Parameters.Add(new SqlParameter("@tara_n", SqlDbType.VarChar) { Value = T18.Text });
                comm.Parameters.Add(new SqlParameter("@sex", SqlDbType.VarChar) { Value = C3.Text });
                comm.Parameters.Add(new SqlParameter("@stare_civila", SqlDbType.VarChar) { Value = C4.Text });
                comm.Parameters.Add(new SqlParameter("@cetatenie", SqlDbType.VarChar) { Value = C5.Text });
                comm.Parameters.Add(new SqlParameter("@cetatenie_op", SqlDbType.Int) { Value = int.Parse(T19.Text) });
                comm.Parameters.Add(new SqlParameter("@etnie", SqlDbType.VarChar) { Value = T20.Text });
                comm.Parameters.Add(new SqlParameter("@incadrare", SqlDbType.VarChar) { Value = C6.Text });
                comm.Parameters.Add(new SqlParameter("@cnp", SqlDbType.Int) { Value = int.Parse(T21.Text) });
                comm.Parameters.Add(new SqlParameter("@serie", SqlDbType.VarChar) { Value = T22.Text });
                comm.Parameters.Add(new SqlParameter("@numar_cnp", SqlDbType.Int) { Value = T23.Text });
                comm.Parameters.Add(new SqlParameter("@eliberat", SqlDbType.VarChar) { Value = T24.Text });
                comm.Parameters.Add(new SqlParameter("@e_data", SqlDbType.DateTime) { Value = DTP3.Value.ToString("MM/dd/yyyy") });
                comm.Parameters.Add(new SqlParameter("@studii_preuni", SqlDbType.VarChar) { Value = C7.Text });
                comm.Parameters.Add(new SqlParameter("@nume_unitate", SqlDbType.VarChar) { Value = T25.Text });
                comm.Parameters.Add(new SqlParameter("@spec_fili_profil", SqlDbType.VarChar) { Value = T26.Text });
                comm.Parameters.Add(new SqlParameter("@oras_s", SqlDbType.VarChar) { Value = T27.Text });
                comm.Parameters.Add(new SqlParameter("@judet_s", SqlDbType.VarChar) { Value = T28.Text });
                comm.Parameters.Add(new SqlParameter("@tara_s", SqlDbType.VarChar) { Value = T29.Text });
                comm.Parameters.Add(new SqlParameter("@forma_de_invatamant", SqlDbType.VarChar) { Value = C8.Text });
                comm.Parameters.Add(new SqlParameter("@medie_bac", SqlDbType.Decimal) { Value = decimal.Parse(T30.Text) });
                comm.Parameters.Add(new SqlParameter("@durata_studii", SqlDbType.Int) { Value = int.Parse(C9.Text) });
                comm.Parameters.Add(new SqlParameter("@data_absolvirii", SqlDbType.DateTime) { Value = DTP4.Value.ToString("MM/dd/yyyy") });
                comm.Parameters.Add(new SqlParameter("@tipul_diploma", SqlDbType.VarChar) { Value = C10.Text });
                comm.Parameters.Add(new SqlParameter("@serie_diploma", SqlDbType.VarChar) { Value = T31.Text });
                comm.Parameters.Add(new SqlParameter("@numar_diploma", SqlDbType.Int) { Value = int.Parse(T32.Text) });
                comm.Parameters.Add(new SqlParameter("@emis_de_catre", SqlDbType.VarChar) { Value = T33.Text });
                comm.Parameters.Add(new SqlParameter("@data_emiterii", SqlDbType.DateTime) { Value = DTP5.Value.ToString("MM/dd/yyyy") });
                comm.Parameters.Add(new SqlParameter("@nr_foi_matricole", SqlDbType.Int) { Value = int.Parse(T34.Text) });
                comm.Parameters.Add(new SqlParameter("@introducere_date", SqlDbType.VarChar) { Value = T35.Text });
                comm.Parameters.Add(new SqlParameter("@semnatura", SqlDbType.VarChar) { Value = T36.Text });


Hello,

Can you please reformat your question as it's difficult to read. When doing so include a sample of the code which you are having issues with using the code button.

Lastly, when working with parameters you need to use assertion first e.g. if a value to a parameter is a Date then use DateTime.TryParse if a if statement, same can be done for int e.g. int.TryParse. Neither is to be done when constructing the parameter as you have shown as if the DateTime can not be parsed then an exception is thrown while TryParse returns a bool, true if the string was parsed as a DateTime while false if not.