Как сделать create table?

AppDomain.CurrentDomain.BaseDirectory

using System;
using System.ComponentModel;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using NativeExcel;
using System.Reflection;
using System.Data.SqlClient;
using System.Data;
 
 
namespace Exp_Exel
{
    public partial class Frm_Analiz_znp : Form
    {
        public Frm_Analiz_znp()
        {
            InitializeComponent();
        }
 
        private void Button1_Click(object sender, EventArgs e)
        {
            string MyComboData2 = (string)comboBox2.SelectedItem; /*подразделение*/
            DateTime MyDateData_c = dateTimePicker1.Value;
            DateTime MyDateData_po = dateTimePicker2.Value;
 
            //Вызов Экселя//
            string Path = System.Windows.Forms.Application.StartupPath + "\\Data\\";
            IWorkbook book = NativeExcel.Factory.OpenWorkbook(Path + "VesZNP.xls");
            Path = @"\\Docx\report\";
            string file_name = Path + DateTime.Now.ToFileTime().ToString() + "VesZNP.xls";
 
 
            book.SaveAs(file_name);
            book = NativeExcel.Factory.OpenWorkbook(file_name);
            IWorksheet MySheet = book.ActiveSheet;
            IRange range = MySheet.Range[1, 1, 1, 1];
            range.Rows.RowHeight = 1;
 
            MySheet.Cells[2, 1].Value = "Плановая трудоемкость по участкам и по машинам " + MyComboData2 + " за период с " + Convert.ToDateTime(MyDateData_c.Date.ToString().Substring(0, 10)) + " по " + Convert.ToDateTime(MyDateData_po.Date.ToString().Substring(0, 10));
 
            int i = 6;
 
            //Подключение к БД "test"//
            Connection_manager.Set_Connection("Data Source=test;Initial Catalog=test;Persist Security Info=True;User ID=root; Password = password987654321");
            Connection_manager.Set_month("10");
            DialogResult = DialogResult.OK;
 
            //подключение SQL - вывожу результат//
            SqlConnection MyConnection5 = Connection_manager.GetCurrentConnection();
            SqlCommand MySelectCommand5 = new SqlCommand();
 
            MySelectCommand5.CommandText = @"CREATE TABLE #PR1(Job bigint, Suffix smallint, StatusRus nvarchar(100), StartDate datetime, EndDate datetime, BuhOrderCode nvarchar(100), BuhOrderDesc nvarchar(100), 
ItemID int, SLCode nvarchar(100), FullName nvarchar(500), ItemTypesID int, SN nvarchar(100), ProcessName nvarchar(100), [Route] nvarchar(100), 
IsTargetItem int, JobOperationID int, QtyReleased numeric(18, 8), QtyComplete numeric(18, 8), ElemNum int, WC int, WorksAspect nvarchar(100), SiteWC nvarchar(100), 
[Operation] nvarchar(100), Equipment nvarchar(100), EqModelPower nvarchar(100), Payable nvarchar(100), CorrectFactor numeric(18, 8), Profession nvarchar(100), 
PerformersQty int, [Rank] int, Valuation numeric(18, 8), Laboriousness numeric(18, 8), HasClosedOpers int, Reason nvarchar(100)) 
insert into #PR1 (Job, Suffix, StatusRus, StartDate, EndDate, BuhOrderCode, BuhOrderDesc, ItemID, SLCode, FullName, ItemTypesID, SN, ProcessName, [Route], JobOperationID, QtyReleased, QtyComplete, ElemNum, WC, WorksAspect, SiteWC, [Operation], Equipment, EqModelPower, Payable, CorrectFactor, Profession, PerformersQty, [Rank], Valuation, Laboriousness, HasClosedOpers, Reason) 
EXECUTE dbo.GetRptPurpleTrud '2023-04-01', '2023-04-30', 207000, null;
delete from #pr1 where Laboriousness = 0";
          
            MySelectCommand5.Parameters.Add("@MyDateParam1", SqlDbType.DateTime);
            MySelectCommand5.Parameters["@MyDateParam1"].Value = MyDateData_c.Date;
            MySelectCommand5.Parameters.Add("@MyDateParam2", SqlDbType.DateTime);
            MySelectCommand5.Parameters["@MyDateParam2"].Value = MyDateData_po.Date;
            MySelectCommand5.Connection = MyConnection5;
            MySelectCommand5.CommandTimeout = 0;
            System.Data.DataTable MyConnteyner5 = new System.Data.DataTable();
        SqlDataAdapter MyAdapter5 = new SqlDataAdapter(MySelectCommand5);
        MyAdapter5.Fill(MyConnteyner5);
            if (MyConnteyner5.Rows.Count > 0)
            {
                foreach (DataRow MyRow5 in MyConnteyner5.Rows)
                {
                    MySheet.Cells[i, 1].Value = MyRow5["Description"];
                    MySheet.Cells[i, 1].Font.Bold = true;
                    i = i + 2;
                    i++;
 
            SqlConnection MyConnection1 = Connection_manager.GetCurrentConnection();
        SqlCommand MySelectCommand1 = new SqlCommand();     
        MySelectCommand1.CommandText = @"Update #PR1 set #PR1.qtyreleased = #PR1.qtyreleased - jobtranoper.QtyCompleteDelta
from jobtranoper
where jobtranoper.joboperationid = #PR1.joboperationid and #PR1.startdate < '2023-04-01' and jobtranoper.FactualDate < '2023-04-01' delete from #PR1 where qtyreleased = 0";
        MySelectCommand1.CommandText = @"delete FROM #PR1 WHERE statusrus = 'Отменено' and qtycomplete = 0 and job not in,select jto.job, from JobTranOper jto where jto.job = #PR1.job and rowdate >= '2023-04-01' and rowdate <= '2023-04-30' delete from #PR1 where qtyreleased = 0";
        MySelectCommand1.CommandText = @"select SiteWC, buhOrderDesc, sn, sum(#PR1.qtyreleased * #PR1.performersqty * #PR1.Laboriousness) as norma, 
sum(#PR1.qtyreleased * #PR1.Valuation) as summa from #PR1
group by SiteWC, sn, buhOrderDesc
Order by SiteWC, sn, buhOrderDesc";
 
                    MySelectCommand1.Parameters.Add("@MyDateParam1", SqlDbType.DateTime);
            MySelectCommand1.Parameters["@MyDateParam1"].Value = MyDateData_c.Date;
            MySelectCommand1.Parameters.Add("@MyDateParam2", SqlDbType.DateTime);
            MySelectCommand1.Parameters["@MyDateParam2"].Value = MyDateData_po.Date;
            MySelectCommand1.Connection = MyConnection1;
            MySelectCommand1.CommandTimeout = 0;
            System.Data.DataTable MyConnteyner1 = new System.Data.DataTable();
        SqlDataAdapter MyAdapter1 = new SqlDataAdapter(MySelectCommand1);
        MyAdapter1.Fill(MyConnteyner1);
            if (MyConnteyner1.Rows.Count > 0)
            {
                decimal summ = 0;
                foreach (DataRow MyRow1 in MyConnteyner1.Rows)
                {
                    MySheet.Cells[i, 1].Value = MyRow1["job"]; // job
                    MySheet.Cells[i, 2].Value = MyRow1["suffix"]; //suffix
                    MySheet.Cells[i, 3].Value = MyRow1["slcode"]; //slcode
                    MySheet.Cells[i, 4].Value = MyRow1["fullname"]; //fullname
                    MySheet.Cells[i, 5].Value = MyRow1["SiteWC"]; //qtyreleased
                    MySheet.Cells[i, 6].Value = MyRow1["buhOrderDesc"]; //qtycomplete
                    MySheet.Cells[i, 7].Value = MyRow1["sn"]; //quantity
                    MySheet.Cells[i, 8].Value = MyRow1["summa"]; // summa
                    MySheet.Cells[i, 9].Value = MyRow1["UnitMeasure"]; //unitmeasure
                        //    MySheet.Cells[i, 10].Value = MyRow1[""]; 
                          //  MySheet.Cells[i, 11].Value = MyRow1[""];
                          //  MySheet.Cells[i, 12].Value = MyRow1[""];
                          //  MySheet.Cells[i, 13].Value = MyRow1[""];
                          //  MySheet.Cells[i, 14].Value = MyRow1[""];
                          //  MySheet.Cells[i, 15].Value = MyRow1[""];
                            summ = summ + Convert.ToDecimal(MyRow1["summa"].ToString());
                    range = MySheet.Range[i, 1, i, 9];
                    range.Borders[XlBordersIndex.xlAround].ColorIndex = XlColorIndex.xlColorIndexAutomatic;
                    range.Borders[XlBordersIndex.xlInsideAll].ColorIndex = XlColorIndex.xlColorIndexAutomatic;
                    i++;
                }
 
}
                    
                }
            }
 
            book.SaveAs(file_name);
            System.Diagnostics.Process.Start(file_name);
 
            
        Close();
 
        }
 
       private void ComboBox2_DropDown(object sender, EventArgs e)
{
    //заполнение комбо-бокса Склад//
    SqlConnection MyConnection6 = Connection_manager.GetCurrentConnection();
    SqlCommand MySelectCommand6 = new SqlCommand();
    string zamena5 = comboBox2.Text.Replace("*", "%");
    MySelectCommand6.CommandText = @"select ID as whse
                                             from test2.dbo.WC
                                             where (ShortName in ('1', '2', '4', '5', '7') and WCPlot like '%000') or WCPlot = '206203' order by cast(ShortName as int)";
    MySelectCommand6.Connection = MyConnection6;
    System.Data.DataTable MyConnteyner6 = new System.Data.DataTable();
    SqlDataAdapter MyAdapter6 = new SqlDataAdapter(MySelectCommand6);
    MyAdapter6.Fill(MyConnteyner6);
    comboBox2.Items.Clear();
    foreach (DataRow MyRow6 in MyConnteyner6.Rows)
    {
        comboBox2.Items.Add(MyRow6["whse"].ToString());
    }
}
 
 
private void Frm_Analiz_znp_Load(object sender, EventArgs e)
{
    var yr = DateTime.Today.Year;
    var mth = DateTime.Today.Month;
    var firstDay = new DateTime(yr, mth, 1).AddMonths(-1).AddMonths(1);
    var lastDay = new DateTime(yr, mth, 1).AddDays(0).AddMonths(1);
 
    dateTimePicker1.Value = firstDay;
    dateTimePicker2.Value = lastDay;
}
 
private void Button2_Click(object sender, EventArgs e)
{
    Frm_Help MyFrm1 = new Frm_Help();
    MyFrm1.ShowDialog();
}
        
private void ComboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
 
}
    }
}

            MySelectCommand5.CommandText = @"CREATE TABLE #PR1(Job bigint, Suffix smallint, StatusRus nvarchar(100), StartDate datetime, EndDate datetime, BuhOrderCode nvarchar(100), BuhOrderDesc nvarchar(100), 
ItemID int, SLCode nvarchar(100), FullName nvarchar(500), ItemTypesID int, SN nvarchar(100), ProcessName nvarchar(100), [Route] nvarchar(100), 
IsTargetItem int, JobOperationID int, QtyReleased numeric(18, 8), QtyComplete numeric(18, 8), ElemNum int, WC int, WorksAspect nvarchar(100), SiteWC nvarchar(100), 
[Operation] nvarchar(100), Equipment nvarchar(100), EqModelPower nvarchar(100), Payable nvarchar(100), CorrectFactor numeric(18, 8), Profession nvarchar(100), 
PerformersQty int, [Rank] int, Valuation numeric(18, 8), Laboriousness numeric(18, 8), HasClosedOpers int, Reason nvarchar(100)) 
insert into #PR1 (Job, Suffix, StatusRus, StartDate, EndDate, BuhOrderCode, BuhOrderDesc, ItemID, SLCode, FullName, ItemTypesID, SN, ProcessName, [Route], JobOperationID, QtyReleased, QtyComplete, ElemNum, WC, WorksAspect, SiteWC, [Operation], Equipment, EqModelPower, Payable, CorrectFactor, Profession, PerformersQty, [Rank], Valuation, Laboriousness, HasClosedOpers, Reason) 
EXECUTE dbo.GetRptPurpleTrud '2023-04-01', '2023-04-30', 207000, null delete from #pr1 where Laboriousness = 0";
            // MySelectCommand5.CommandText = @"UPDATE #PR1";
            //string sqlExpression = "UPDATE #PR1";
            MySelectCommand5.Parameters.Add("@MyDateParam1", SqlDbType.DateTime);
            MySelectCommand5.Parameters["@MyDateParam1"].Value = MyDateData_c.Date;
            MySelectCommand5.Parameters.Add("@MyDateParam2", SqlDbType.DateTime);
            MySelectCommand5.Parameters["@MyDateParam2"].Value = MyDateData_po.Date;
            MySelectCommand5.Connection = MyConnection5;
            MySelectCommand5.CommandTimeout = 0;
            System.Data.DataTable MyConnteyner5 = new System.Data.DataTable();
        SqlDataAdapter MyAdapter5 = new SqlDataAdapter(MySelectCommand5);
        MyAdapter5.Fill(MyConnteyner5);