我想把图象插入ACESS数据库中,在数据库中设置了三个字段,其中image是OLE类型,插入时报错,错误提示是INSERT into 语句的语法错误....但是如果我不插入图象,只插入StudentID, Name字符串类型有没有错误,期待大家回复.

byte[]image_bytes =null;
OpenFileDialog myDialog = new OpenFileDialog();
myDialog.ShowDialog();
if(myDialog.FileName.Trim()!="")
{
pictureBox1.Image = System.Drawing.Bitmap.FromFile(myDialog.FileName);
}

Stream mystream = myDialog.OpenFile();
leng =(int)mystream.Length;
image_bytes = new byte[leng];
mystream.Read(image_bytes,0,leng);
mystream.Close();

string CString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + Application.StartupPath + @"\S11.MDB";
MyCon=new OleDbConnection(CString);
try//创建连接对象
{
MyCon.Open();//打开连接}
}

catch(Exception ee)
{
MessageBox.Show(ee.Message);

}
try
{
string SqlCmd = "INSERT INTO st(StudentID, Name, image) VALUES (@StudentID, @Name, @image)";
MyCom = new OleDbCommand(SqlCmd,MyCon);
MyCom.Parameters.Add("@StudentID", OleDbType.VarChar,8).Value = "11010187";
MyCom.Parameters.Add("@Name", OleDbType.VarChar,8).Value = "杜威";
MyCom.Parameters.Add("@image",OleDbType.Binary,leng).Value = image_bytes;
MyCom.ExecuteNonQuery();
MessageBox.Show("成功");
}
catch(Exception ee)
{

MessageBox.Show(ee.Message);
}

MyCom.Parameters.Add("@image",OleDbType.Binary,leng).Value = image_bytes;

去掉再看下

谢谢版主回复,去掉还是不行.....

leng 改成image看看...

把错误代码贴出来...

谢谢三楼, MyCom.Parameters.Add("@image",OleDbType.Binary,leng).Value = image_bytes;
leng 改成image,参数就不正确了.
系统提示是 :
INSERT into 语句的语法错误

把leng去掉，然后格式化image_bytes看看

谢谢hoya回复,
MyCom.Parameters.Add("@image",OleDbType.Binary) = image_bytes;
还是一样的错误.

继续关注....

把 leng 改成一个具体的值呢?

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.OleDb;
using System.IO;

namespace db
{
public partial class Form1 : Form
{
byte[] image_bytes = null;
public OleDbConnection MyCom = null;
private string fullname;

public Form1()
{
InitializeComponent();
}

public void button1_Click(object sender, EventArgs e)
{

OpenFileDialog myDialog = new OpenFileDialog();
myDialog.ShowDialog();
this.fullname = myDialog.FileName;
if (myDialog.FileName.Trim() != "")
{
pictureBox1.Image = System.Drawing.Bitmap.FromFile(myDialog.FileName);
}

}

private void button2_Click(object sender, EventArgs e)
{
string CString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + Application.StartupPath + @"\S11.mdb";

MyCom= new OleDbConnection(CString);
MyCom.Open();

FileStream mystream = File.OpenRead(this.fullname);
image_bytes = new byte[mystream.Length];
mystream.Read(image_bytes, 0, image_bytes.Length);
mystream.Close();

string SqlCmd = "INSERT INTO st(StudentID, Name,myimage) VALUES ('" +this.textBox1.Text + "','" + this.textBox2.Text + "',@image)";
OleDbCommand cmd = new OleDbCommand(SqlCmd, MyCom);
//cmd.Parameters.Add("@StudentID", OleDbType.VarChar, 8).Value = this.textBox1.Text;
//cmd.Parameters.Add("@Name", OleDbType.VarChar, 8).Value = this.textBox2.Text;
cmd.Parameters.Add("@image", OleDbType.Binary).Value = image_bytes;
try
{

cmd.ExecuteNonQuery();
MessageBox.Show("成功");
}
catch (Exception ee)
{

MessageBox.Show(ee.Message);
}

finally
{
MyCom.Close();
}
}
}
}
调试了一会，不过还是调试出来了，你看看吧，有什么问题在贴出来了