> Can you show part of code you're using?
string content;
StreamReader file = new StreamReader(txtPhoto.Text);
content = file.ReadToEnd();
content = content.Replace("'", "''");
photo = content;
I had been escaping \ with this:
content = content.Replace("\\","\\\\");
but that does absolutely nothing. If I remember correctly its not an
escape character, should I use the Ascii_Char(n) for special objects
such as carriage returns and what have you?
this is the actual insert code
dbCnxn.execOpen();
string insert = "INSERT INTO members (CODE_MEMBER, ID_FAMILY,
FNAME, SNAME, FLNAME, SLNAME, BIRTHDATE, GENDER, CELL_PHONE, WORK_PHONE,
ALT_PHONE, EMAIL, NIT, PROFESSION, JOB, JOB_POSITION, PHOTO) VALUES ( '"
+ Core.Config.AppSet.Default.code + "', " + family + ",'" + fname +
"','" + sname + "','" + flname + "','" + slname + "','" + birthdate +
"','" + gender + "', " + phone2 + ", " + phone3 + "," + phone4 + ",'" +
email + "','" + nit + "','" + profession + "','" + job + "','" +
position + "'";
//Just in case some no essential information is empty
insert = insert.Replace("''", "null");
insert = insert + ", '" + photo + "')";
int b = dbCnxn.sqlExecute(insert);
dbCnxn.execClose();
dbCnxn belongs to class I created to handle all the calls to dotnet
provider all that method does is adds the previously opened conectiona
and transaction to the command and calls the ExecuteNonQuery() method
this enough info or need some more?
James
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
|
