Question

怎么用循环把数据插入到数据库表中(.net)

代码写清楚点 我是菜鸟啊 老大帮帮我把

把txt文件数据插到数据库中 搞一点源码。

Answer 1

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;
}

Answer 2

先FOR（要插入的数据总行总）
{
插入操作
}

Answer 3

用文件流读取，再添加数据！

Answer 4

你是要把一张表里符合要求的数据查到另一张表里吗？
可以用T-SQL实现的