public bool SaveQAInfoList(string str) { //BinaryFormatter formatter = new BinaryFormatter(); //byte[] array = Encoding.ASCII.GetBytes(str); //MemoryStream strm = new MemoryStream(array); //List<MyQAInfo> myQAInfoList = (List<MyQAInfo>)formatter.Deserialize(strm); List <MyQAInfo> myQAInfoList = changeType.changeStrToT <List <MyQAInfo> >(str); try { List <string> sqllist = new List <string>(); foreach (MyQAInfo item in myQAInfoList) { string sql = string.Empty; sql = @" insert into QA (QAINFO_ID, .QAINFO_CODE, .QAINFO_PARENTID, .QAINFO_QUESTION, .QAINFO_ANSWER, .QAINFO_CREATETIME, .QAINFO_LASTMODIFIEDTIME, .QAINFO_MODIFICATIONTIMES, .QAINFO_IFINVALID, .QAINFO_STATE) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')"; sql = string.Format(sql, item.QAINFO_ID, item.QAINFO_CODE, item.QAINFO_PARENTID, item.QAINFO_QUESTION, item.QAINFO_ANSWER, item.QAINFO_CREATETIME, item.QAINFO_LASTMODIFIEDTIME, item.QAINFO_MODIFICATIONTIMES, item.QAINFO_IFINVALID, item.QAINFO_STATE); sqllist.Add(sql); } db.Execute(sqllist); return(true); } catch (Exception ex) { return(false); } }