基本信息

---

下载

   源码介绍

---

C#实现自动更新

//连接数据库
string strConnection="Provider = Microsoft.Jet.OLEDB.4.0 ;Jet OLEDB:Database Password=;Data Source ="
Application.StartupPath.ToString().Trim() "\\mydatabase.mdb" ;
OleDbConnection myConnect=new OleDbConnection(strConnection);
OleDbCommand myCommand=new OleDbCommand("select * from 版本",myConnect);
OleDbDataAdapter myDataAdapter=new OleDbDataAdapter();
myDataAdapter.SelectCommand=myCommand;
OleDbCommandBuilder myCommandBuilder=new OleDbCommandBuilder(myDataAdapter);
myConnect.Open();

//获取已有的数据
m_DataSet=new DataSet();
try
{
myDataAdapter.Fill(m_DataSet,this.m_TableName);
//如果是首次上传，则增加一条记录
if(m_DataSet.Tables[m_TableName].Rows.Count==0)
{
DataRow newrow=m_DataSet.Tables[m_TableName].NewRow();
newrow["序号"]="1";
m_DataSet.Tables[m_TableName].Rows.Add(newrow);
}

DataRow row=m_DataSet.Tables[m_TableName].Rows[0];
//填入去掉路径的文件名称
row["文件名称"]=this.GetFileNameFromPath(this.txtFileName.Text.Trim());
//填入版本号
row["版本号"]=this.txtVersion.Text.Trim();

//将实际文件存入记录中
FileStream fs=new FileStream(this.txtFileName.Text.Trim(),FileMode.Open);
byte [] myData = new Byte [fs.Length ];
fs.Position = 0;
fs.Read (myData,0,Convert.ToInt32 (fs.Length ));
row["文件内容"] = myData;
fs.Close();//关闭文件