注册 登录
编程论坛 ASP.NET技术论坛

varchar到money的转换?

littldoudou 发布于 2009-08-31 15:45, 599 次点击
try
            {
                string  shipname1 = this.TextBox1.Text.Trim();
                string companyname1 = this.TextBox3.Text.Trim();
                string portofregistry1 = this.TextBox5.Text.Trim();
                string  peccancytime1 =  this.Text1.Value.ToString().Trim();
                string peccancyplace1 =this.TextBox2.Text.Trim();
                string  peccancyreason1 =  this.TextBox4.Text.Trim();
                Decimal  peccancymoney1 = Convert.ToDecimal(this.TextBox6.Text.Trim());
                string pk = shipname1 + peccancytime1;
               
                Regex re=new Regex(@"^[0-9]+$");
                //连接数据库
                string strConnection = "data source=(local);user id=sa; password = sa;initial catalog=cjg";
                myconn = new SqlConnection(strConnection);
                if(shipname1!=""&&companyname1!=""&&portofregistry1!=""&&peccancytime1!=""&&peccancyplace1!=""&&peccancyreason1!=""&&TextBox6.Text!="")
                {
               
                    myconn.Open();
                    string insertstr = "insert into [peccancy](shipname,companyname,portofregistry,peccancytime,peccancyplace,peccancyreason,peccancymoney,pk) values ('"+shipname1+"','"+companyname1+"','"+portofregistry1+"','"+peccancytime1+"','"+peccancyplace1+"','"+peccancyreason1+"','"+@peccancymoney1+"','"+pk+"')";
                    SqlCommand cmd = new SqlCommand(insertstr,myconn);
                    cmd.Parameters.Add("@peccancymoney1",peccancymoney1);
                    cmd.ExecuteNonQuery();                       
                    //关闭连接
                    myconn.Close();
           

                    //
                    Response.Write("<script language=javascript>alert('保存成功!')</script>") ;
                    this.BindData();
                    //
                    TextBox1.Text = "";
                    TextBox2.Text = "";
                    TextBox3.Text = "";
                    TextBox4.Text = "";
                    TextBox5.Text = "";
                    TextBox6.Text = "";
                    this.Text1.Value = "";
                    //this.TextBox8.Text = "";
                    //TextBox7.Text = "";
                    //TextBox10.Text = "";
                }
               
                else
                {
                    Response.Write("<script language=javascript>alert('请填满所有项!')</script>") ;
                }
            }   
            catch(Exception ex)
            {
                throw ex;
            }
这段程序报“/WebApplication1”应用程序中的服务器错误。
--------------------------------------------------------------------------------
不允许从数据类型 varchar 到数据类型 money 的隐性转换(表 'cjg.dbo.peccancy',列 'peccancymoney')。请使用 CONVERT 函数来运行此查询。
这样的错误,该如何解决?
2 回复
#2
jedypjd2009-08-31 16:25
请使用 CONVERT 函数,不是已经告诉你了嘛
#3
jedypjd2009-08-31 16:25
请使用 CONVERT 函数,不是已经告诉你了嘛
1