谁能帮我把这些sql语句转换为OleDb,在线等，很急！谢谢

[zhongxin]

public int StoreImg(string file)
{
FileStream fs=new FileStream(file,FileMode.Open);
BinaryReader br=new BinaryReader(fs);
imagedata=br.ReadBytes(Convert.ToInt32(fs.Length));
OleDbConnection conn=new OleDbConnection("Provider=SQLOLEDB;Data Source=ms-p4;Initial Catalog=sub platform;user id=coins.net;password=coins.net");
conn.Open();
OleDbCommand com=new OleDbCommand();
com.CommandText="insert into image values(@imagedata)";
com.Connection=conn;
com.Parameters.Add("@imagedata",OleDbType.VarBinary);
com.Parameters["@imagedata"].Value=imagedata;
com.ExecuteNonQuery();
com.CommandText=null;
br.Close();
conn.Close();
fs.Close();
return imagedata.GetLength(0);
}

[timmy3310]

public int StoreImg(string file)
{
FileStream fs=new FileStream(file,FileMode.Open);
BinaryReader br=new BinaryReader(fs);
imagedata=br.ReadBytes(Convert.ToInt32(fs.Length));
OleDbConnection conn=new SqlConnection("Provider=SQLOLEDB;Data Source=ms-p4;Initial Catalog=sub platform;user id=coins.net;password=coins.net");
conn.Open();
OleDbCommand com=new OleDbCommand();
com.CommandText="insert into image values(?)";
com.Connection=conn;
com.Parameters.Add("@imagedata",OleDbType.LongVarBinary);
com.Parameters["@imagedata"].Value=imagedata;
com.ExecuteNonQuery();
com.CommandText=null;
br.Close();
conn.Close();
fs.Close();
return imagedata.GetLength(0);
}

[cmsoft]

using System.OleDb;


SqlCommand,SqlConnect之类的前面的Sql换成OleDb

即如：OleDbConnection,OleDbCommand

[cmsoft]

using System.Data.OleDb;

[Cnapollo]

Provider=SQLOLEDB;Data Source=ms-p4;Initial Catalog=sub platform;user id=coins.net;password=coins.net

[zhongxin]

3ks so much to timmy3310(Tim)!!!

[gordenfl]

up

[zhongxin]

发错了，应该是
public int StoreImg(string file)
{
FileStream fs=new FileStream(file,FileMode.Open);
BinaryReader br=new BinaryReader(fs);
imagedata=br.ReadBytes(Convert.ToInt32(fs.Length));
SqlConnection conn=new SqlConnection("Data Source=ms-p4;Initial Catalog=sub platform;user id=coins.net;password=coins.net");
conn.Open();
SqlCommand com=new SqlCommand();
com.CommandText="insert into image values(@imagedata)";
com.Connection=conn;
com.Parameters.Add("@imagedata",SqlDbType.Image);
com.Parameters["@imagedata"].Value=imagedata;
com.ExecuteNonQuery();
com.CommandText=null;
br.Close();
conn.Close();
fs.Close();
return imagedata.GetLength(0);
}