Cómo insertar datos en una tabla de base de datos usando un bucle (.net)

{

string strex = "insertar en pub_ExcellenceProject(id,projectCode,mainid,bank,Fujia. newTechnologyProject,GreenBuild,Otros,insertUserName,insertTime,updateUserName,updateTime)";

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

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

strex += " , " + SysConvert.ToDBString(dt.Rows[i]["mainCode"].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]["Otros"].ToString());

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

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

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

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

strex += " )";

sqlcmd.CommandText = strex; p>

sqlcmd.ExecuteNonQuery()ExecuteNonQuery();

}

Eso es

dt es una fuente de datos

filePath ruta del archivo

sufijo del archivo filePostfix

public bool Insertar

Accesorio(string filePath, string fileName, string filePostfix,string remark,int isshare)

{

bool flag = false;

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

// Determinar la longitud del nombre del archivo

if (fileName.Length > 300)

{

fileName = fileName.Substring(0, 300);

}

prueba

{

/ /contents

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

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

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

fs.Close();

//tamaño del archivo

tamaño decimal = Convert.ToDecimal(FileSize(filePath));

//Fusionar sentencias 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 += " '" + nombre de archivo + "',";

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

strSql += "@FileContent,";

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

strSql += "0 ";

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

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

strSql += " ," + SysConvert.ToDBString(observación); >

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

StrSql += ", " + SysCon

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

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

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

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

strSql += ")";

Comm.CommandText = strSql

Comm.CommandText = strSql; CommandText = strSqlParameters.Add(para);

comm.ExecuteNonQuery();

flag= true;

}

catch ( Excepción)

{

MessageBox.Show( fileName + ".". + filePostfix + "Ya abierto, cierre y vuelva a agregar"., "Consejo del sistema", MessageBoxButtons. OK , MessageBoxIcon.Warning);

flag= false;

}

finalmente

{

comm Connection.Close( );

}

devolver bandera;

}

Finalmente

{<. / p>

comm.Connection.Close( );

}

Indicador de retorno;

}