怎麽用循環把數據插入到數據庫表中(.net)

for (int i = 0; i < dt.Rows.Count; i++)

{

string strex = "insert into pub_ExcellenceProject(id,projectCode,mainid,bank,Fujia,newTechnologyProject,GreenBuild,Others,insertUserName,insertTime,updateUserName,updateTime)";

strex += " VALUES ( " + SysConvert.ToDBString(dt.Rows[i]["id"].ToString());

strex += " , " + SysConvert.ToDBString(dt.Rows[i]["projectCode"].ToString());

strex += " ," + SysConvert.ToDBString(dt.Rows[i]["mainid"].ToString());

strex += " , " + SysConvert.ToInt32(dt.Rows[i]["bank"].ToString());

strex += " ," + SysConvert.ToDBString(dt.Rows[i]["Fujia"].ToString());

strex += " ," + SysConvert.ToDBString(dt.Rows[i]["newTechnologyProject"].ToString());

strex += " , " + SysConvert.ToDBString(dt.Rows[i]["GreenBuild"].ToString());

strex += " ," + SysConvert.ToDBString(dt.Rows[i]["Others"].ToString());

strex += " , " + SysConvert.ToDBString(dt.Rows[i]["insertUserName"].ToString());

strex += " ," + SysConvert.ToDBString(SysConvert.ToDateTimeString(DateTime.Parse(dt.Rows[i]["insertTime"].ToString())));

strex += " , " + SysConvert.ToDBString(dt.Rows[i]["updateUserName"].ToString());

strex += " ," + SysConvert.ToDBString(SysConvert.ToDateTimeString(DateTime.Parse( dt.Rows[i]["updateTime"].ToString())));

strex += " )";

sqlcmd.CommandText = strex;

sqlcmd.ExecuteNonQuery();

}

就可以了

dt是壹個數據源

filePath文件路徑

filePostfix 文件後綴

public bool InsertAppurtenance(string filePath, string fileName, string filePostfix,string remark,int isshare)

{

bool flag = false;

SqlCommand comm = (SqlCommand)SysUtil.GetCommand();

//判斷文件名稱的長度

if (fileName.Length > 300)

{

fileName = fileName.Substring(0, 300);

}

try

{

//內容

FileStream fs = new FileStream(filePath, FileMode.Open, FileAccess.Read);

byte[] fileContent = new byte[fs.Length];

fs.Read(fileContent, 0, (int)fs.Length);

fs.Close();

//文件大小

decimal size = Convert.ToDecimal(FileSize(filePath));

//組合sql語句

string strSql = string.Empty;

strSql = "INSERT INTO jzs_FileInfoDir(ID,fatherProjectCode,fileName,ParentID,fileContent,filePostfix,IsDirectory,IsShare,userId,remark,insertTime,insertUserName,updateTime,updateUserName) VALUES(";

strSql += "'" + Guid.NewGuid().ToString();///

strSql += "','" + ProjectInfo.FatherProjectCode + "',";

strSql += "'" + fileName + "',";

strSql += "'" + pid + "',";

strSql += "@FileContent,";

strSql += "'" + filePostfix + "',";

strSql += "0 ";

strSql += " ," + SysConvert.ToInt32(isshare);

strSql += "," + SysConvert.ToDBString(manager);

strSql += " ,"+SysConvert.ToDBString(remark);

strSql += ", " + SysConvert.ToDBString(SysConvert.ToDateTimeString(SystemInfo.CurrentDate))+ ",";

strSql += "'" + LoginUserInfo.Id + "'";

strSql += "," +SysConvert.ToDBString(SysConvert.ToDateTimeString(SystemInfo.CurrentDate))+ ",";

strSql += "'" + LoginUserInfo.Id + "'";

strSql += ")";

comm.CommandText = strSql;

SqlParameter para = new SqlParameter("@FileContent", SqlDbType.Image);

para.Value = fileContent;

comm.Parameters.Add(para);

comm.ExecuteNonQuery();

flag= true;

}

catch (Exception)

{

MessageBox.Show(fileName + "." + filePostfix + "已經被打開，請關閉後重新添加。", "系統提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);

flag= false;

}

finally

{

comm.Connection.Close();

}

return flag;

}

上一篇:季k線的使用秘訣

下一篇:全民奇跡MU那些榜上無名的BOSS 悠悠輪回蒼茫奇跡