String dateString;
dateString = this.dateTimePickerxs.Text.Trim();
Convert.ToDateTime(dateString); if (this.comboBox3.Text.Trim() == "" || this.textBox1.Text.Trim() == "" || this.textBox3.Text.Trim() == "" || this.textBox9.Text.Trim() == "" || this.textBox5.Text.Trim() == "" || this.textBox6.Text.Trim() == "" || this.comboBox2.Text.Trim() == "" || this.comboBox4.Text.Trim() == "" || this.dateTimePickerxs.Text.Trim() == "")
MessageBox.Show("请录入必要的信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
else
{
SqlConnection conn = new SqlConnection("Data Source=localhost;User ID=sa;PWD=;DataBase=sale MIS");
conn.Open();
string sql = "select 汽车编号 from 销售管理信息表 where 汽车编号='" + this.comboBox2.Text.Trim() + "'";
SqlCommand cmd = new SqlCommand(sql, conn);
if (null == cmd.ExecuteScalar())
{
if (Convert.ToInt32(this.textBox3.Text.Trim()) <= Convert.ToInt32(this.textBox2.Text.Trim()))
{
cmd.CommandText = "insert into 销售管理信息表 values('" + this.textBox1.Text.Trim() + "','" + this.comboBox2.Text.Trim() + "','" + this.comboBox3.Text.Trim() + "','" + this.comboBox4.Text.Trim() + "','" + this.textBox9.Text.Trim() + "','" + this.textBox3.Text.Trim() + "','" + this.textBox4.Text.Trim() + "','" + Convert.ToDateTime(dateString) + "','" + this.textBox5.Text.Trim() + "','" + this.textBox6.Text.Trim() + "','" + this.textBox7.Text.Trim() + "','" + this.textBox8.Text.Trim() + "')"; cmd.ExecuteNonQuery() // string strSQL = "insert into 销售管理信息表 values ('" + Convert.ToInt32(this.textBox1.Text.Trim()) + "','" + Convert.ToInt32(this.comboBox2.Text.Trim()) + "','" + this.comboBox3.Text.Trim() + "','" + this.comboBox4.Text.Trim() + "','" + float.Parse(this.textBox9.Text.Trim()) + "','" + Convert.ToInt32(this.textBox3.Text.Trim()) + "','" + float.Parse(this.textBox4.Text.Trim()) + "','" + Convert.ToDateTime(dateTimePicker1.Text.Trim()) + "','" + Convert.ToInt32(this.textBox5.Text.Trim()) + "','" + this.textBox6.Text.Trim() + "','" + this.textBox7.Text.Trim() + "','" + this.textBox8.Text.Trim() + "')";
string strSQL = "select * from 销售管理信息表 where 汽车编号='" + this.comboBox1.Text.Trim() + "'";
SqlDataAdapter da = new SqlDataAdapter(strSQL, conn); //创建数据集对象ds
DataSet thisDataSet = new DataSet();
//执行SQL语句,填充数据集对象ds
da.Fill(thisDataSet, "销售管理信息表"); //将数据集对象ds绑定至dataGridView控件
this.dataGridView1.DataSource = thisDataSet;
this.dataGridView1.DataMember = "销售管理信息表"; MessageBox.Show("添加信息成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
} else
{ MessageBox.Show("库存量不足" + this.textBox3.Text.Trim() + "该药品最多能销售" + this.textBox2.Text.Trim() + "个", "提示");
// if (this.textBox5.Text.Trim() == "")
// MessageBox.Show("职员编号为必输项,请选择!", "提示!", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("请选择顾客所要购买汽车的汽车编号", "提示");
}
// string strSQL = "insert into 销售管理信息表 values ('" + Convert.ToInt32(this.textBox1.Text.Trim()) + "','" + Convert.ToInt32(this.comboBox2.Text.Trim()) + "','" + this.comboBox3.Text.Trim() + "','" + this.comboBox4.Text.Trim() + "','" + float.Parse(this.textBox9.Text.Trim()) + "','" + Convert.ToInt32(this.textBox3.Text.Trim()) + "','" + float.Parse(this.textBox4.Text.Trim()) + "','" + Convert.ToDateTime(dateTimePicker1.Text.Trim()) + "','" + Convert.ToInt32(this.textBox5.Text.Trim()) + "','" + this.textBox6.Text.Trim() + "','" + this.textBox7.Text.Trim() + "','" + this.textBox8.Text.Trim() + "')"; conn.Close();
一直出现从字符串到datetime转换有问题,但我时间按钮明明转换了,请各位帮帮忙,做毕设很痛苦!!!
dateString = this.dateTimePickerxs.Text.Trim();
Convert.ToDateTime(dateString); if (this.comboBox3.Text.Trim() == "" || this.textBox1.Text.Trim() == "" || this.textBox3.Text.Trim() == "" || this.textBox9.Text.Trim() == "" || this.textBox5.Text.Trim() == "" || this.textBox6.Text.Trim() == "" || this.comboBox2.Text.Trim() == "" || this.comboBox4.Text.Trim() == "" || this.dateTimePickerxs.Text.Trim() == "")
MessageBox.Show("请录入必要的信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
else
{
SqlConnection conn = new SqlConnection("Data Source=localhost;User ID=sa;PWD=;DataBase=sale MIS");
conn.Open();
string sql = "select 汽车编号 from 销售管理信息表 where 汽车编号='" + this.comboBox2.Text.Trim() + "'";
SqlCommand cmd = new SqlCommand(sql, conn);
if (null == cmd.ExecuteScalar())
{
if (Convert.ToInt32(this.textBox3.Text.Trim()) <= Convert.ToInt32(this.textBox2.Text.Trim()))
{
cmd.CommandText = "insert into 销售管理信息表 values('" + this.textBox1.Text.Trim() + "','" + this.comboBox2.Text.Trim() + "','" + this.comboBox3.Text.Trim() + "','" + this.comboBox4.Text.Trim() + "','" + this.textBox9.Text.Trim() + "','" + this.textBox3.Text.Trim() + "','" + this.textBox4.Text.Trim() + "','" + Convert.ToDateTime(dateString) + "','" + this.textBox5.Text.Trim() + "','" + this.textBox6.Text.Trim() + "','" + this.textBox7.Text.Trim() + "','" + this.textBox8.Text.Trim() + "')"; cmd.ExecuteNonQuery() // string strSQL = "insert into 销售管理信息表 values ('" + Convert.ToInt32(this.textBox1.Text.Trim()) + "','" + Convert.ToInt32(this.comboBox2.Text.Trim()) + "','" + this.comboBox3.Text.Trim() + "','" + this.comboBox4.Text.Trim() + "','" + float.Parse(this.textBox9.Text.Trim()) + "','" + Convert.ToInt32(this.textBox3.Text.Trim()) + "','" + float.Parse(this.textBox4.Text.Trim()) + "','" + Convert.ToDateTime(dateTimePicker1.Text.Trim()) + "','" + Convert.ToInt32(this.textBox5.Text.Trim()) + "','" + this.textBox6.Text.Trim() + "','" + this.textBox7.Text.Trim() + "','" + this.textBox8.Text.Trim() + "')";
string strSQL = "select * from 销售管理信息表 where 汽车编号='" + this.comboBox1.Text.Trim() + "'";
SqlDataAdapter da = new SqlDataAdapter(strSQL, conn); //创建数据集对象ds
DataSet thisDataSet = new DataSet();
//执行SQL语句,填充数据集对象ds
da.Fill(thisDataSet, "销售管理信息表"); //将数据集对象ds绑定至dataGridView控件
this.dataGridView1.DataSource = thisDataSet;
this.dataGridView1.DataMember = "销售管理信息表"; MessageBox.Show("添加信息成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
} else
{ MessageBox.Show("库存量不足" + this.textBox3.Text.Trim() + "该药品最多能销售" + this.textBox2.Text.Trim() + "个", "提示");
// if (this.textBox5.Text.Trim() == "")
// MessageBox.Show("职员编号为必输项,请选择!", "提示!", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("请选择顾客所要购买汽车的汽车编号", "提示");
}
// string strSQL = "insert into 销售管理信息表 values ('" + Convert.ToInt32(this.textBox1.Text.Trim()) + "','" + Convert.ToInt32(this.comboBox2.Text.Trim()) + "','" + this.comboBox3.Text.Trim() + "','" + this.comboBox4.Text.Trim() + "','" + float.Parse(this.textBox9.Text.Trim()) + "','" + Convert.ToInt32(this.textBox3.Text.Trim()) + "','" + float.Parse(this.textBox4.Text.Trim()) + "','" + Convert.ToDateTime(dateTimePicker1.Text.Trim()) + "','" + Convert.ToInt32(this.textBox5.Text.Trim()) + "','" + this.textBox6.Text.Trim() + "','" + this.textBox7.Text.Trim() + "','" + this.textBox8.Text.Trim() + "')"; conn.Close();
一直出现从字符串到datetime转换有问题,但我时间按钮明明转换了,请各位帮帮忙,做毕设很痛苦!!!
解决方案 »
- VS2010 winform中 usercontrol 怎么放到窗体上
- 大家好,.NET的人面试JAva的人会有什么后果?进来看题目
- 关于TreeView控件的问题 小弟在线等待。。。。
- .Net2003中制作的安装程序向导,怎么只检查C盘的空间呀????????????????
- 怪怪怪!!!关于主窗体与子窗体的问题,请教!
- 急!!!!!!!!在线等!!!!!!!!!得到一个文件流(stream)后,如何把他存成相应的文件.
- 如何在FORM传到WINFORM
- 企业级应用开发 使用VS.NET、UML和MSF电子书谁有?
- 你们显示报表是用什么控件的?是CrystalReportViewer吗?谢
- 谁知道这些数据什么意思吗
- 问个新手问题 打开项目
- c# api hook 全盘获取键盘的值
dateString = this.dateTimePickerxs.Text.Trim();
Convert.ToDateTime(dateString);
你把datestring定义成字符串了 ,应该定义为DateTime 类型
oracle不行
必须为 insert into nn(mm)values(to_date('2009-01-23 22:22:22','yyyy-mm-dd z4h:mi:ss'))
String dateString;
dateString = this.dateTimePickerxs.Text.Trim();
Convert.ToDateTime(dateString);
这三句代码中的dateTimePickerxs.Text.Trim(),你是输入的,还是日期控件生成的,如果是输入,是否符合日期格式:2010/4/20,或者2010-4-20,如果不是这样的格式肯定会报错
在懒也要用
string.format()
http://blog.163.com/mengfanzong@126/blog/static/12948713820101263264327/
要不然 用Trim()就错了
dateString = Convert.ToDateTime( this.dateTimePickerxs.Text.Trim());
楼主应该先下个断点看报什么错,根据错误修改能好一些!
---------------------------------------------
这个代码太糟糕了,建议你该成参数的形式。