错误:对象必须实现IConvertible. [英] Error : Object must implement IConvertible.

问题描述

我的输入"表单具有三个下拉菜单，两个日历和几个文本框.
这是我的代码:

My Entry form Has three dropdown, two calendar''s and few text box.
here is my code:

protected void btn_Save_Click(object sender, EventArgs e)
     {
      
         string s = "insert into SchoolSubjectMaster([Class],[PaperCode],[SubjectName],[SubjectNameAbbr],[SubjectCategory],[MaxMarks],[MinMarks],[ActivationDate],[DeActivationDate],[ActiveStatus]) VALUES(@Class,@PaperCode,@SubjectName,@SubjectNameAbbr,@SubjectCategory,@MaxMarks,@MinMarks,@ActivationDate,@DeActivationDate,@ActiveStatus)";
         SqlCommand cmd = new SqlCommand(s, cn);
            cmd.Parameters.Add("@Class", System.Data.SqlDbType.VarChar);
            cmd.Parameters["@Class"].Value = Drp_Class.Text;
            cmd.Parameters.Add("@PaperCode", System.Data.SqlDbType.VarChar);
            cmd.Parameters["@PaperCode"].Value = txt_paprCd.Text;
            cmd.Parameters.Add("@SubjectName", System.Data.SqlDbType.VarChar);
            cmd.Parameters["@SubjectName"].Value = txt_Subj.Text;
            cmd.Parameters.Add("@SubjectNameAbbr", System.Data.SqlDbType.VarChar);
            cmd.Parameters["@SubjectNameAbbr"].Value = txt_Abbr.Text;
            cmd.Parameters.Add("@SubjectCategory", System.Data.SqlDbType.VarChar);
            cmd.Parameters["@SubjectCategory"].Value = Drp_SubCat.Text;
            cmd.Parameters.Add("@MaxMarks", System.Data.SqlDbType.VarChar);
            cmd.Parameters["@MaxMarks"].Value = txt_mx.Text;
            cmd.Parameters.Add("@MinMarks", System.Data.SqlDbType.VarChar);
            cmd.Parameters["@MinMarks"].Value = txt_min.Text;
            cmd.Parameters.Add("@ActivationDate", System.Data.SqlDbType.DateTime);
            cmd.Parameters["@ActivationDate"].Value = txt_ActDate.Text;
            cmd.Parameters.Add("@DeActivationDate", System.Data.SqlDbType.DateTime);
            cmd.Parameters["@DeActivationDate"].Value = txt_DeactDate;
            cmd.Parameters.Add("@ActiveStatus", System.Data.SqlDbType.VarChar);
            cmd.Parameters["@ActiveStatus"].Value = Drp_ActStat.Text;
         cn.Open();
         cmd.ExecuteNonQuery();
         cn.Close();
         Response.Redirect("SubSave");
     }

我遇到此错误:对象必须实现IConvertible.


该错误已解决，现在下拉列表中的另一个错误为静态信息:Drp_ActStat，Drp_SubCat.Text
动态:Drp_Class.Text
错误:字符串或二进制数据将被截断.
该声明已终止.

请给我建议解决方案.
谢谢

I am Getting This Error: Object must implement IConvertible.


The error is Resolved, Now another Error For the Dropdown''s static: Drp_ActStat , Drp_SubCat.Text
Dynamic: Drp_Class.Text
Error: String or binary data would be truncated.
The statement has been terminated.

Please Suggest me the Solution.
Thank You

推荐答案

只是一个猜测，但是...

变更:

Just a guess, but...

Change:

cmd.Parameters["@DeActivationDate"].Value = txt_DeactDate;

收件人:

To:

cmd.Parameters["@DeActivationDate"].Value = txt_DeactDate.Text;

假定txt_DeactDate是文本框，则以下行:

Assuming that txt_DeactDate is a TextBox, the following line:

cmd.Parameters["@DeActivationDate"].Value = txt_DeactDate;

应实际读取

cmd.Parameters["@DeActivationDate"].Value = txt_DeactDate.Text;

这篇关于错误:对象必须实现IConvertible.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！