اثر پروانه ای

file.copy("D:\\Source\\", "\\192.168.1.201\\Source1\\New\\")

ممنون

  public void AddNewRecord(string filePath, string title)

        {

            if (!File.Exists(filePath))

                throw new FileNotFoundException(

                    "لطفا مسیر فایل معتبری را مشخص نمائید", filePath);

            byte[] buffer = File.ReadAllBytes(filePath);

            using (SqlConnection objSqlCon = new SqlConnection())

            {

                objSqlCon.ConnectionString =

                    "Data Source=tik-pc;Initial Catalog=ss;Integrated Security = true";

                objSqlCon.Open();

                using (SqlTransaction objSqlTran = objSqlCon.BeginTransaction())

                {

                    using (SqlCommand objSqlCmd = new SqlCommand(

                                "AddFile", objSqlCon, objSqlTran))

                    {

                        objSqlCmd.CommandType = CommandType.StoredProcedure;

                        SqlParameter objSqlParam1 = new SqlParameter("@Title", SqlDbType.NVarChar, 255);

                        objSqlParam1.Value = title;

                        SqlParameter objSqlParamOutput = new SqlParameter("@filepath", SqlDbType.VarChar, -1);

                        objSqlParamOutput.Direction = ParameterDirection.Output;

                        SqlParameter objSqlParamOutput2 = new SqlParameter("@ID1", SqlDbType.UniqueIdentifier);

                        objSqlParamOutput2.Direction = ParameterDirection.Output;

                        objSqlCmd.Parameters.Add(objSqlParam1);

                        objSqlCmd.Parameters.Add(objSqlParamOutput);

                        objSqlCmd.Parameters.Add(objSqlParamOutput2);

                        objSqlCmd.ExecuteNonQuery();

                        string Path = objSqlCmd.Parameters["@filepath"].Value.ToString();

                        this.Text = Path;

                        textBox3.Text = objSqlCmd.Parameters["@ID1"].Value.ToString();

                        //زمینه تراکنش فایل استریم موجود را دریافت کرده و از آن برای نوشتن محتویات فایل استفاده خواهیم کرد

                        //این مورد نیز یکی از تازه‌های اس کیوال سرور 2008 است

                        using (SqlCommand objCmd = new SqlCommand(

                            "SELECT GET_FILESTREAM_TRANSACTION_CONTEXT()", objSqlCon, objSqlTran))

                        {

                            byte[] objContext = (byte[])objCmd.ExecuteScalar();

                            using (SqlFileStream objSqlFileStream =

                                new SqlFileStream(Path, objContext, FileAccess.Write))

                            {

                                objSqlFileStream.Write(buffer, 0, buffer.Length);

                            }

                        }

                    }

                    objSqlTran.Commit();

                }

            }

        }

//دستور درج رکورد در T-SQL

 DECLARE @ID UNIQUEIDENTIFIER
   SET @ID = NEWID() 
  
   INSERT INTO [tblFiles]
     (
       [FileId],
       [title],
       [SystemFile]
     )
   VALUES
     (
       @ID,
       @Title,
       CAST('' AS VARBINARY(MAX))
     )

//دستورات حذف درC#

        public void DeleteRecord(string fileId)
        {
            //byte[] buffer = File.ReadAllBytes(fileId);

            using (SqlConnection objSqlCon = new SqlConnection())
            {
                objSqlCon.ConnectionString =
                    "Data Source=tik-pc;Initial Catalog=ss;Integrated Security = true";
                objSqlCon.Open();

                using (SqlTransaction objSqlTran = objSqlCon.BeginTransaction())
                {
                    using (SqlCommand objSqlCmd = new SqlCommand(
                                "[Delete12]", objSqlCon, objSqlTran))
                    {
                        objSqlCmd.CommandType = CommandType.StoredProcedure;

                        SqlParameter objSqlParam1 = new SqlParameter("@ID", SqlDbType.VarChar, 50);
                        objSqlParam1.Value = fileId;

                        SqlParameter objSqlParamOutput = new SqlParameter("@filepath", SqlDbType.VarChar, -1);
                        objSqlParamOutput.Direction = ParameterDirection.Output;

                        objSqlCmd.Parameters.Add(objSqlParam1);
                        objSqlCmd.Parameters.Add(objSqlParamOutput);

                        objSqlCmd.ExecuteNonQuery();
                    
                        string Path = objSqlCmd.Parameters["@filepath"].Value.ToString();

            objSqlCmd.Parameters["@ID1"].Value.ToString();
                
                    }
                    objSqlTran.Commit();
                }
            }
        }

//دستور حذف با T-SQL

 delete from tblFiles
   WHERE [FileId] = @ID checkpoint