byte[] arrPhoto = File.ReadAllBytes(path);
m_employee.photo = ?
这个值该怎么填,求高手知道,因为这是个项目。数据库操作已经在别的类中写好了
public static void AddEmployee(Employee employee)
{
string strField = "name, officeId, password, cardNumber,gender,nation,religion,homeTown,marriage,politics,education,DOB,workPhone,mobile,homePhone,homeAddress,mailingAddress,jobNumber,jobTitle,skillLevel,ID,socailId,entryDate,leaveDate,email,comment,photo";
string strData = string.Format("'{0}', '{1}', '{2}', '{3}','{4}','{5}','{6}', '{7}', '{8}', '{9}', '{10}','{11}','{12}', '{13}','{14}', '{15}', '{16}', '{17}', '{18}','{19}', '{20}','{21}', '{22}', '{23}', '{24}','{25}','{26}'",
employee.name, employee.officeId, employee.password, employee.cardNumber, employee.gender, employee.nation, employee.religion, employee.homeTown, employee.marriage, employee.politics, employee.education,
employee.DOB, employee.workPhone, employee.mobile, employee.homePhone, employee.homeAddress, employee.mailingAddress, employee.jobNumber, employee.jobTitle, employee.skillLevel,
employee.ID, employee.socailId, employee.entryDate, employee.leaveDate, employee.email, employee.comment,employee.photo);
sqladd("Employee", strField, strData);
}我直接调用
m_employee.photo = ?
这个值该怎么填,求高手知道,因为这是个项目。数据库操作已经在别的类中写好了
public static void AddEmployee(Employee employee)
{
string strField = "name, officeId, password, cardNumber,gender,nation,religion,homeTown,marriage,politics,education,DOB,workPhone,mobile,homePhone,homeAddress,mailingAddress,jobNumber,jobTitle,skillLevel,ID,socailId,entryDate,leaveDate,email,comment,photo";
string strData = string.Format("'{0}', '{1}', '{2}', '{3}','{4}','{5}','{6}', '{7}', '{8}', '{9}', '{10}','{11}','{12}', '{13}','{14}', '{15}', '{16}', '{17}', '{18}','{19}', '{20}','{21}', '{22}', '{23}', '{24}','{25}','{26}'",
employee.name, employee.officeId, employee.password, employee.cardNumber, employee.gender, employee.nation, employee.religion, employee.homeTown, employee.marriage, employee.politics, employee.education,
employee.DOB, employee.workPhone, employee.mobile, employee.homePhone, employee.homeAddress, employee.mailingAddress, employee.jobNumber, employee.jobTitle, employee.skillLevel,
employee.ID, employee.socailId, employee.entryDate, employee.leaveDate, employee.email, employee.comment,employee.photo);
sqladd("Employee", strField, strData);
}我直接调用
http://dotnet.aspx.cc/file/Upload-Image-To-Access-With-C-Sharp-And-VB.NET.aspx
m_employee.photo =arrPhoto;应该就可以的,数据库的image类型对应的是byte[]
http://msdn.microsoft.com/zh-cn/library/cc716729.aspx如果不能运行,则说明你定义的AddEmployee方法是错误的
string strData = string.Format("'{0}', '{1}', '{2}', '{3}','{4}','{5}','{6}', '{7}', '{8}', '{9}', '{10}','{11}','{12}', '{13}','{14}', '{15}', '{16}', '{17}', '{18}','{19}', '{20}','{21}', '{22}', '{23}', '{24}','{25}','{26}'",你这种写法是错误的,对于数字类型的,是不能加单引号的,你什么都加,会报告SQL错误的