110,566
社区成员
发帖
与我相关
我的任务
分享
string source = @" server = .;database = DB1; integrated security=SSPI ";
SqlConnection sqlcon = new SqlConnection(source);
sqlcon.Open();
SqlCommand sqlcom = new SqlCommand();
sqlcom.Connection = sqlcon;
sqlcom.CommandText = "insert into ChangedFile(filed,filedtype) values(@filed,@filedtype)";
sqlcom.Parameters.Add("@filed", SqlDbType.VarChar);
sqlcom.Parameters.Add("@filedtype", SqlDbType.Int);
sqlcom.Parameters["@filed"].Value = e.FullPath;
sqlcom.Parameters["@filedtype"].Value = 1;
sqlcom.ExecuteNonQuery();
sqlcon.Close();