注册 登录
编程论坛 SQL Server论坛

请问一下,哪儿出错了

辜小东 发布于 2008-04-29 10:33, 747 次点击
SqlCommand com = new SqlCommand( );
            com.Connection =con;
            com.Parameters.Add("@v1",SqlDbType.VarChar,50,"品种");
            com.Parameters.Add("@v2",SqlDbType.Int,4,"农户ID");
            com.Parameters.Add("@v3",SqlDbType.Decimal ,9,"收购价");
            com.Parameters.Add("@v4",SqlDbType.DateTime ,8,"成熟时间");
            com.Parameters.Add("@v5",SqlDbType.Decimal ,9,"数量");
            com.Parameters["@v1"].Value = TextBox1.Text;
            com.Parameters["@v2"].Value = TextBox2.Text;
            com.Parameters["@v3"].Value = TextBox3.Text;
            com.Parameters["@v4"].Value = TextBox4.Text;
            com.Parameters["@v5"].Value = TextBox5.Text;
             = "select * from farmer where 品种=@v1and农户ID=@v2and收购价=@v3and成熟时间=@v4and数量=@v5";
            SqlDataReader dr=com.ExecuteReader ();  提交的时候老是显示字符串格式不对这个格式有哪儿不对吗?
1 回复
#2
yangwen2008-05-03 12:10
试试单引号
1