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

为何我的插入就是不行呢???

ggaolin 发布于 2007-12-13 16:35, 1552 次点击
高手请指教一下,当我点击“添加”的时候,就是不行,麻烦能否给指点一下?谢谢。
public static bool insertOperate(oil y)
        {
            try
            {
                
                SqlConnection con=oilOperate.createCon();
                con.Open();
//                SqlCommand cmd=new SqlCommand("insert into price  values(y.DateTime,y.Categories,y.Products,y.TodayPrices,y.PreviousDay,y.Remarks,y.Units,y.messagePerson,y.messageUnit,y.visiable)",con);
                
                SqlCommand cmd=new SqlCommand("insert into Price values(@DateTime,@Categories,@Products,@TodayPrices,@PreviousDay,@Remarks,@Units,@messagePerson,@messageUnit,@visiable)",con);
                SqlParameter para=new SqlParameter("@DateTime",SqlDbType.SmallDateTime,4);
                para.Value=y.DateTime;
                cmd.Parameters.Add(para);

                para=new SqlParameter("@Categories",SqlDbType.VarChar,20);
                para.Value=y.Categories;
                cmd.Parameters.Add(para);

                para=new SqlParameter("@Products",SqlDbType.VarChar,20);
                para.Value=y.Products;
                cmd.Parameters.Add(para);

                para=new SqlParameter("@TodayPrices",SqlDbType.VarChar,20);
                para.Value=y.TodayPrices;
                cmd.Parameters.Add(para);

                para=new SqlParameter("@PreviousDay",SqlDbType.VarChar,20);
                para.Value=y.PreviousDay;
                cmd.Parameters.Add(para);

                para=new SqlParameter("@Remarks",SqlDbType.VarChar,50);
                para.Value=y.Remarks;
                cmd.Parameters.Add(para);

                para=new SqlParameter("@Units",SqlDbType.VarChar,20);
                para.Value=y.Units;
                cmd.Parameters.Add(para);

                para=new SqlParameter("@messagePerson",SqlDbType.VarChar,50);
                para.Value=y.messagePerson;
                cmd.Parameters.Add(para);

                para=new SqlParameter("@messateUnit",SqlDbType.VarChar,50);
                para.Value=y.messageUnit;
                cmd.Parameters.Add(para);
            
                para=new SqlParameter("@visiable",SqlDbType.VarChar,10);
                para.Value=y.visiable;
                cmd.Parameters.Add(para);

                cmd.ExecuteNonQuery();
                return true;
            }
            catch(Exception e)
            {
                return false;
            }
            
        }
7 回复
#2
ggaolin2007-12-13 16:37
会是我的表的字段有问题?但是除了DateTime之外,其他的都是varchar类型,怎么会出问题呢???
#3
loveling2007-12-27 16:04
是不是你的插入语句有问题啊 但似乎我看着是没多大问题啊啊
#4
菜鳥弎魛2007-12-28 14:42
insert into Price (,.........) values
把这里写完试试
#5
soonce2007-12-29 10:04
我也觉得是不是应该把字段名都列出来试试。
#6
人妖1232007-12-29 10:11
设置一个断点,一下就知道哪里错误了。
#7
cyyu_ryh2007-12-29 10:25
你把语句放到查询分析器里
输入自定义数据看SQL有错没
1