请高手们指点,要急死了!
其中:qydate和jcdate对应的字段类型是日期型insert into water_dj values('" + StoreID + "','" + JH + "','" + Kh + "',to_date('" + qydate + "','yyyy-mm-dd'),to_date('" + jcdate + "','yyyy-mm-dd')," + qyl + "," + coc + "," + coz + "," + hcoc + "," + hcoz + "," + clc + "," + clz + "," + cac + "," + caz + "," + mgc + "," + mgz + "," + soc + "," + soz + "," + Convert.ToDecimal(khd) + "," + Convert.ToDecimal(yd) + "," + Convert.ToDecimal(col) + "," + Convert.ToDecimal(qw) + "," + Convert.ToDecimal(bz) + ")我将这段语句换成相应的数据,在sql*plus worksheet中执行正常,我不明白为什么在vs2005中调试时,就是出现“数据库错误,错误原因:输入字符串的格式不正确。将一个字符串转换成为datatime时,应先分析该字符串以获取日期,然后将变量放置到datatime对象中
其中:qydate和jcdate对应的字段类型是日期型insert into water_dj values('" + StoreID + "','" + JH + "','" + Kh + "',to_date('" + qydate + "','yyyy-mm-dd'),to_date('" + jcdate + "','yyyy-mm-dd')," + qyl + "," + coc + "," + coz + "," + hcoc + "," + hcoz + "," + clc + "," + clz + "," + cac + "," + caz + "," + mgc + "," + mgz + "," + soc + "," + soz + "," + Convert.ToDecimal(khd) + "," + Convert.ToDecimal(yd) + "," + Convert.ToDecimal(col) + "," + Convert.ToDecimal(qw) + "," + Convert.ToDecimal(bz) + ")我将这段语句换成相应的数据,在sql*plus worksheet中执行正常,我不明白为什么在vs2005中调试时,就是出现“数据库错误,错误原因:输入字符串的格式不正确。将一个字符串转换成为datatime时,应先分析该字符串以获取日期,然后将变量放置到datatime对象中
解决方案 »
- 模拟QQ登录总是提示qq密码不正确~!密码没错可以肯定!请高手赐教!
- 不同类型的List找交集
- C# 水晶报表(winform) 不显示时间字段,小弟分少,但是求帮助啊!
- 用clsFTP类 做FTP下载数据并显示进度条,但好像无法获取FTP上文件大小?进度条无法显示。
- C# 两个窗体传值,不管From2是否打开,窗体From1必须传值给From2,怎么实现呢?
- finally会执行吗
- 小弟才疏学浅,c#文件访问出错了。。。。。。。急~
- c# 关于windows编程的一些问题
- 学习C#时的小问题,大家帮忙
- 求分析,这块代码出问题了,点击按钮没反应
- 背包问题
- WinForm datagrid的数据列宽怎么设置?
你里面加这么多+干什么?...
protected void Button1_Click(object sender, EventArgs e)
{
string name = Session["UserName"].ToString();
string StoreID = this.Label1.Text.Trim();
string JH = this.DDLsearch.SelectedValue.ToString();
string Kh = Convert.ToString(HyDb.ReturnSQL("select kh from userinfo where username='" + name + "'"));
string qydate = this.txtqydate.Text.Trim();
string jcdate = this.txtjcdate.Text.Trim();
string qyl = this.txtqyl.Text.Trim();
string coc = this.Txtcochu.Text.Trim();
string coz = this.Txtcozhong.Text.Trim();
string hcoc = this.Txthcochu.Text.Trim();
string hcoz = this.Txthcozhong.Text.Trim();
string clc = this.Txtclchu.Text.Trim();
string clz = this.Txtclzhong.Text.Trim();
string cac = this.Txtcachu.Text.Trim();
string caz = this.Txtcazhong.Text.Trim();
string mgc = this.Txtmgchu.Text.Trim();
string mgz = this.Txtmgzhong.Text.Trim();
string soc = this.Txtsochu.Text.Trim();
string soz = this.Txtsozhong.Text.Trim();
string khd = this.Txtkhd.Text.Trim();
string yd = this.Txtyd.Text.Trim();
string col = this.Txtcolor.Text.Trim();
string qw = this.Txtqw.Text.Trim();
string bz = this.Txtbz.Text.Trim();
//try
//{
//HyDb.NoreturnSql("insert into water_dj values('" + StoreID + "','" + JH + "','" + Kh + "','" + qydate + "','" + jcdate + "'," + qyl + "," + coc + "," + coz + "," + hcoc + "," + hcoz + "," + clc + "," + clz + "," + cac + "," + caz + "," + mgc + "," + mgz + "," + soc + "," + soz + "," + Convert.ToDecimal(khd) + "," + Convert.ToDecimal(yd) + "," + Convert.ToDecimal(col) + "," + Convert.ToDecimal(qw) + "," + Convert.ToDecimal(bz) + ")");
HyDb.NoreturnSql("insert into water_dj values('" + StoreID + "','" + JH + "','" + Kh + "',to_date('" + qydate + "','yyyy-mm-dd'),to_date('" + jcdate + "','yyyy-mm-dd')," + qyl + "," + coc + "," + coz + "," + hcoc + "," + hcoz + "," + clc + "," + clz + "," + cac + "," + caz + "," + mgc + "," + mgz + "," + soc + "," + soz + "," + Convert.ToDecimal(khd) + "," + Convert.ToDecimal(yd) + "," + Convert.ToDecimal(col) + "," + Convert.ToDecimal(qw) + "," + Convert.ToDecimal(bz) + ")"); HyDb.NoreturnSql("commit");
AutoID();
//}
//catch (Exception ex)
//{
// Response.Write("数据库错误,错误原因:" + ex.Message);
// Response.End();
//}
this.clear();
}
定义string strsql="insert into water_dj values('" + StoreID + "','" + JH + "','" + Kh + "','" + qydate + "','" + jcdate + "'," + qyl + "," + coc + "," + coz + "," + hcoc + "," + hcoz + "," + clc + "," + clz + "," + cac + "," + caz + "," + mgc + "," + mgz + "," + soc + "," + soz + "," + Convert.ToDecimal(khd) + "," + Convert.ToDecimal(yd) + "," + Convert.ToDecimal(col) + "," + Convert.ToDecimal(qw) + "," + Convert.ToDecimal(bz) + ")"
断点跟踪,取strsql的值,在oracle里执行,看哪出错
处理方法很简单,你在C#中拼接SQL语句时,先ToString('yyyy-MM-dd')转换下,然后拼接到SQL语句里即可,同理,你后面的Convert.ToDecimal转换都是多余的,因为最终是会自动调用ToString转换到字符串来拼接这些SQL片段的。
直接在赋值的时候就转成DATETIME型的试试行不
string sID = "123";
string sName = "aaa";
int iAge = 15;
String.Format("insert into table {ID, name, Age} values {'{0}', '{1}', {2}}", sID, sName, iAge);
string qydate = this.txtqydate.Text.Trim();
string jcdate = this.txtjcdate.Text.Trim();
这样也能变成不是'yyyy-MM-dd'的样式????......
DateTime qydate=Convert.ToDateTime(this.txtqydate.Text.Trim());
{
if (!IsPostBack)
{
……
txtqydate.Text = Convert.ToString(DateTime.Now.AddDays(-1).ToString().Substring(0, 10));
txtjcdate.Text = Convert.ToString(DateTime.Now.ToString().Substring(0, 10));
}
}已经将变量转换成字符型的了啊?而且将textbox设成了只读!为了方便用户录入,而且要求这两个日期必须是当天和前一天的!
2、设置断点取sql语句直接在orcl上运行,看报什么错
string t = textBox1.Text;
int space = t.IndexOf(" ");
string s1 = t.Substring(2);
char op = Convert.ToChar(t.Substring(space + 1, 1));
string s2 = t.Substring(3);
Single arg1 = Convert.ToSingle(s1);
Single arg2 = Convert.ToSingle(s2);
总是提示输入字符串的格式不正确!!!帮忙解决下