这是运行后提示的
未处理的“System.Data.SqlClient.SqlException”类型的异常出现在 System.Data.dll 中
其他信息: 第 1 行: '(' 附近有语法错误
下面是代码- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Text;
- using System.Windows.Forms;
- using System.Data.SqlClient;
- using System.IO;
- namespace 输出
- {
- public partial class Form1 : Form
- {
- public Form1()
- {
- InitializeComponent();
- }
- SqlConnection sqlcn;
- string ConStr;
- string picname;
- private void Form1_Load(object sender, EventArgs e)
- {
- ConStr = "Server=10.57.147.242;UID=sa;Pwd=;Database=designer";
- sqlcn = new SqlConnection(ConStr);
- sqlcn.Open();
- }
- private void pictureBox1_Click(object sender, EventArgs e)
- {
- openFileDialog1.Filter = "Gif图片|*.gif|Jpg图片|*.jpg|BMP图片|*.bmp";
- this.openFileDialog1.ShowDialog();
- if (this.openFileDialog1.FileName.Trim() == "")
- {
- return;
- }
- try
- {
- picname = openFileDialog1.FileName;
- pictureBox1.Image = Image.FromFile(picname);
- }
- catch
- {
- MessageBox.Show(this, "打开图像文件错误!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
- }
- }
- private void button1_Click(object sender, EventArgs e)
- {
- if (textBox1.Text == "" || pictureBox1.Image == null)
- {
- MessageBox.Show("输入的信息不完整,重新输入!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
- }
- else
- {
- string myinsert = "insert into 照片(FNumber,image) values('" + textBox1.Text + "','" + picname + "')";
- SqlCommand mycom = new SqlCommand(myinsert, sqlcn);
- mycom.ExecuteNonQuery();
- sqlcn.Close();
- sqlcn.Dispose();
- MessageBox.Show("已成功向数据库表中插入一条记录!", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
- }
- }
- }
- }
复制代码 |