c#database选择然后插入.但是值为0

我试图选择然后从表1插入日期时间到表2.我已成功插入数据.但是,表2中显示的日期时间为00:00:00. Idk哪里出错.有人请帮我解决这个问题.我正在努力解决这个问题.这是SELECT然后插入的正确方法吗？ (从表1中选择然后插入表2)

try
    {
        String myConnectionString;
        myConnectionString= "server=localhost;uid=root;pwd=root;database=meDicloud;Sslmode=None;charset=utf8";

        MysqLConnection connection = new MysqLConnection(myConnectionString);
        MysqLCommand cmd = new MysqLCommand();

        cmd.Commandtype = commandType.Text;

        EncodingProvider ppp;
        ppp = CodePagesEncodingProvider.Instance;
        Encoding.RegisterProvider(ppp);

        connection.open();   

        String SELEct = "SELEct time from assign where userId=@name";
        cmd.Parameters.AddWithValue("@name",txtValue.Text);                           
        cmd.CommandText = SELEct;
        cmd.Connection = connection;


        MysqLDataReader SELEctAssign = cmd.ExecuteReader();
        SELEctAssign.Read();
        String assign = (SELEctAssign["time"].ToString());
        SELEctAssign.Close();


        cmd.Commandtype = commandType.Text;
        cmd.CommandText = "INSERT into bluetooth (userId,arm,armnumberDone,armnumber,comDate,assignDate,status) VALUES (@name,@stupid0,@stupid1,@stupid2,@stupid3,@stupid4,@stupid5)";
        cmd.Parameters.AddWithValue("@stupid0",databaseLinE);
        cmd.Parameters.AddWithValue("@stupid1",counter);
        cmd.Parameters.AddWithValue("@stupid2",databasevalue);
        cmd.Parameters.AddWithValue("@stupid3",datetiR_481_11845@e.Now);
        cmd.Parameters.AddWithValue("@stupid4",assign);
        cmd.Parameters.AddWithValue("@stupid5",completE);
        cmd.Connection = connection;


        cmd.ExecuteNonQuery();
        connection.Close();

    }

    catch (MysqLException eX)
    {
        txtExercise.Text = ex.ToString();
    }

try
{
      String myConnectionString;
      myConnectionString = "server=localhost;uid=root;pwd=root;database=meDicloud;Sslmode=None;charset=utf8";

      MysqLConnection connection = new 
           MysqLConnection(myConnectionString);
      MysqLCommand cmd = new MysqLCommand();

      cmd.Commandtype = commandType.Text;

      EncodingProvider ppp;
      ppp = CodePagesEncodingProvider.Instance;
      Encoding.RegisterProvider(ppp);

      connection.open();

      String SELEct = "SELEct time from assign where userId=@name";
      cmd.Parameters.AddWithValue("@name",txtValue.Text);
      cmd.CommandText = SELEct;
      cmd.Connection = connection;

      MysqLDataReader SELEctAssign = cmd.ExecuteReader();
      SELEctAssign.Read();
      String assign = (SELEctAssign["time"].ToString());
      SELEctAssign.Close();

      datetiR_481_11845@e assignDate = datetiR_481_11845@e.Now;
      datetiR_481_11845@e.TryParseExact(assign,out assignDatE);

      cmd.Commandtype = commandType.Text;
      cmd.CommandText = "INSERT into bluetooth 
(userId,@stupid5)";
      cmd.Parameters.AddWithValue("@stupid0",databaseLinE);
      cmd.Parameters.AddWithValue("@stupid1",counter);
      cmd.Parameters.AddWithValue("@stupid2",databasevalue);
      cmd.Parameters.AddWithValue("@stupid3",datetiR_481_11845@e.Now);
      cmd.Parameters.AddWithValue("@stupid4",assignDatE);
      cmd.Parameters.AddWithValue("@stupid5",completE);
      cmd.Connection = connection;

      cmd.ExecuteNonQuery();
      connection.Close();
   }
  catch (MysqLException eX)
  {
      txtExercise.Text = ex.ToString();
  }
}